SQL Server 2008 is chockfull of cool new features, but here is a list of 5 features that I find very useful for day to day operations.

  1. Intellisense, finally!
  2. T-SQL Debugger, finally!
  3. The ability to run a query against multiple servers.
  4. Powershell is now fully integrated.
  5. You can now add a color via connection properties for a server to help distinguish production from test servers.