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…


SQL Server Code-Named “Denali”–Getting Started with Availability Groups and Keyboard Customization

Bill Ramos Principal Program Manager, SQL Server Manageability If you missed SQL PASS or you didn’t get your copy of SQL Server code named “Denali”, you’re in luck. You can now download it from: http://www.microsoft.com/downloads/en/details.aspx?FamilyID=6a04f16f-f6be-4f92-9c92-f7e5677d91f9 For the full experience, you will want to run the 64 bit version on Windows Server 2008 R2. You can…

0

Microsoft SQL Server 2008 R2 Management Pack is now available

We’ve made some important improvements and investments in the SQL Management Pack for System Center, and the English language version just RTW-ed last week.   You can read more about it here on the Release Services Team’s blog.   Keep an eye on that blog for updates and info. Regards,Tamara Tan, Bonnie Feinberg, Cory Delamarter, Clifford Dibble, Mauricio…


Server Activity History Report–MDW Report Series Part 4

By Bill Ramos, Program Manager, SQL Server Manageability Team In part 3 of the report series, I showed how to get CPU data from the MDW and display it as a thumbnail chart in the Server Activity History report. In part 4, I’ll show how to extract data from the MDW for the Disk I/O…

2

Server Activity History Report–MDW Report Series Part 3

By Bill Ramos, Program Manager, SQL Server Manageability Team In part 2, I added the hyperlink to the MDW Overview report to launch the Server Activity History report. In this post, I’ll show how to get the data and display the thumbnails in the report for %CPU. I’ll follow up post 4 to include Disk…

0

MDW Overview Report for Data Collector (Server Activity) – MDW Report Series Part 2

By Bill Ramos, Program Manager, SQL Server Manageability Team In this post, we’ll complete the MDW Overview report from part 1 of this series and then start into the makings of the Server Activity report as shown below. The Server Activity report has 4 major sections that I’ll go through that includes the timeline; server…

0

MDW Overview Report for Data Collector – MDW Report Series Part 1

By Bill Ramos, Program Manager, SQL Server Manageability Team The Management Data Warehouse (MDW) overview report that I mentioned in my previous blog post on Viewing MDW Reports with a Low Privileged User Account provides a list of database instances and the last collection set upload times for the MDW database. Below is an example…

2

Viewing MDW Reports with a Low Privileged User Account

Just last week, one of our technical sales people asked me the question, when will we release the source RDL files for the Management Data Warehouse (MDW) feature that we shipped with SQL Server 2008. The reason that he asked was that his customer wanted to host the reports on a Reporting Services server so…

1