Before you install Denali CTP1 …

  SQL PASS 2010 is over, and the first CTP of Denali is out. Lots of interesting stuff got announced and Demo’d at PASS. If you were part of the insider sessions, you probably got demos of some of the CTP1 features as well. But, before you install CTP1 from that DVD in your hand,…

0

Cumulative Update 3 for SQL Server Management Studio 2008 R2: What’s in it for managing SQL Azure Databases?

Microsoft SQL Azure Database periodically adds new features to its existing service offerings. A few months back, via the Service Update 2 and Service Update 3, the following features were made available to users of SQL Azure Databases: “ALTER DATABASE MODIFY NAME” T-SQL. This now allows users to change the names of their database hosted…


SQL Server Code-Named “Denali” – Viewing SQL Error Logs from WMI/SSMS when SQL Server is offline

John Emmanuel Mandam (johnema@microsoft.com) is a colleague of mine in the SQL Server Manageability team and he wrote up this useful blog on using WMI to query SQL Server Error Log Events in SQL Server code named “Denali”. Query SQL Server ErrorLog Events using WMI (WQL) To diagnose why SQL Server instance or instances are…