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 Studio
How 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.aspx

SQL Server and PowerShell:
The PowerShell script for selecting data: http://hansolav.net/blog/content/binary/powershellsql.txt
Microsoft SQL Server Homepage: http://www.microsoft.com/sql

Reporting Services
The report I created with Reporting Services: http://hansolav.net/blog/content/binary/report.rdl.txt (rename to .rdl)

Geospatial
The spatial queries: http://hansolav.net/blog/content/binary/spatial.sql.txt
Utilities 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=7105
Some shapefiles:
http://www.census.gov/geo/www/cob/bdy_files.html
http://www.geog.ucsb.edu/~ta176/g176b/lab6/lab6_data.zip
http://www.cipotato.org/diva/data/MoreData.htm
http://biogeo.berkeley.edu/bgm/gdata.php

Another visualization tool that I didn't use: http://conceptdevelopment.net/Database/Geoquery/
Isaac's blog on MSDN: http://blogs.msdn.com/isaac/default.aspx
The SQL Server Battleship game that I mentioned: http://www.conceptdevelopment.net/Database/Battleship2008/

Imagine Cup
More information about Imagine Cup: http://msstudent.no/ImagineCupNorge/ImagineCup2008/tabid/647/Default.aspx

Feel free to send me questions at hansolav *AT* hansolav.net.