Monday, September 29, 2008

Improved Management Studio in SQL Server 2008

The new SQL Server Management Studio (SSMS) in SQL Server 2008 just rocks! It’s still the same tool, they haven’t changed that again, but so many features have been improved. Right clicks are different; there is more visualization, the activity monitor is completely different, not just in the way it looks but in what it does and how it does it. We have IntelliSense (which never made the cut in SQL Server 2005). The T-SQL Debugger is back. In Query Analyser (SQL Server 2000) it was a separate program, now it’s encapsulated in the tool. Having written your query all you do is click debug!

One really great feature is the new Object Search – a real time saver. You can now search anything from the name of a database or a table down to a column, an index or a user, all in one screen. Within Object Explorer Details there is also the possibility to “drill down” into the details of an object. When you’re happy with the layout it’s still there when you open SSMS the next time. And the real nice part is it can be copied (with column headers) into e.g. Excel.

Here’s a concise list of what has been added/improved in SQL Server 2008.