Ever wondered what has changed under the hood between versions of Microsoft SQL Server? Well, then this post is for you!
What’s new in SQL 2008
What got deprecated in SQL 2008
What was discontinued in SQL 2008
Breaking changes in SQL 2008
Additional information that I have been meaning to link for a long time:
This is a stored procedure that was custom made by Adam Machanic (Blog) which will allow you to monitor what is running on your SQL Server system. It is a real nifty tool and I highly recommend that you take a look at it.