As promised, here are the resources from the SQL Server 2008 presentation I did at NTNU 5/3. For those of you that didn't attend, I still recommend you to take a look at the links below. I hope everyone had a good time hearing about PowerShell, Reporting Services, and geospatial support - I sure did have a good time presenting it.
Visual StudioHow to configue Visual Studio to Debug .NET Framework Source Code:
http://blogs.msdn.com/sburke/archive/2008/01/16/configuring-visual-studio-to-debug-net-framework-source-code.aspxSQL Server and PowerShell:
The PowerShell script for selecting data:
http://hansolav.net/blog/content/binary/powershellsql.txtMicrosoft SQL Server Homepage:
http://www.microsoft.com/sqlReporting ServicesThe report I created with Reporting Services:
http://hansolav.net/blog/content/binary/report.rdl.txt (rename to .rdl)
GeospatialThe spatial queries:
http://hansolav.net/blog/content/binary/spatial.sql.txtUtilities for loading shapefiles into SQL Server and visualizing spatial query results:
http://www.sharpgis.net/post/2007/12/Shapefile-to-SqlServer-2008-to-WPF.aspx
Background image for the visualization tool:
http://visibleearth.nasa.gov/view_rec.php?id=7105Some shapefiles:
http://www.census.gov/geo/www/cob/bdy_files.htmlhttp://www.geog.ucsb.edu/~ta176/g176b/lab6/lab6_data.ziphttp://www.cipotato.org/diva/data/MoreData.htmhttp://biogeo.berkeley.edu/bgm/gdata.phpAnother visualization tool that I didn't use:
http://conceptdevelopment.net/Database/Geoquery/Isaac's blog on MSDN:
http://blogs.msdn.com/isaac/default.aspxThe SQL Server Battleship game that I mentioned:
http://www.conceptdevelopment.net/Database/Battleship2008/Imagine CupMore information about Imagine Cup:
http://msstudent.no/ImagineCupNorge/ImagineCup2008/tabid/647/Default.aspxFeel free to send me questions at hansolav *AT* hansolav.net.