In my MDW Reports series, I attached V1 of the RDL files in my post - May the source be with you! MDW Report Series Part 6–The Final Edition . Since that post, Rachna Agarwal from MSIT in India updated the RDL files that are ready to go in a single ZIP...

Today I presented data collection strategies for SQL Server 2008 at Phoenix SQL Saturday 47 . I’ve attached my deck to this post so that you can get the links and references that I presented. To learn more about the Data Collector, check out these links...

In this blog post, I will go through the steps needed to prepare for a proof of concept (POC) for using the SQL Server 2008 R2 Data Collector (DC) and Management Data Warehouse (MDW) reports (covered in part 2) to get you up and running. I’ll cover the...

Bill Ramos, formally Principal Program Manager, SQL Server Manageability Now WorkStream Manager for http://www.advaiya.com Hi All,       As of November 22, after 15 years at Microsoft as a Program Manager, I'm joining a new company...

Bill Ramos, Principal Program Manager, SQL Server Manageability Up until this point, I’ve walked through step by step how the MDW reports could be recreated to use SQL Server Reporting Services 2008 R2 and edit them in Report Builder 3.0. ...

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...

With the SQL PASS conference beginning tomorrow and in the spirit of Jen & Sean of the MidnightDBA fame I thought I would give you a run down of what I’ll be up to and things you might consider attending – just because. Monday SQL PASS Welcome Reception...

By Bill Ramos, Principal Program Manager, SQL Server Manageability Team It just dawned on me that in preparing for SQL PASS and helping folks understand more about the existing MDW reports, that there is zero documentation on what reports are in SSMS...

Bill Ramos, Principal Program Manager, SQL Manageability In my previous blog post Installing the SQL Server 2008 R2 Management Pack for System Center Operations Manager 2007 R2 I showed how you can install SCOM 2007 R2 on a “bare-metal”...

By Bill Ramos Principal Program Manager, SQL Server Manageability Abstract In this blog post, I will go over the steps to install System Center Operations Manager (SCOM) 2007 R2 and the recent release of the SQL Server 2008 R2 Management Pack (MP...

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...

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...

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...

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...

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...

TechNet Books Online just published three whitepapers - check them out! SQL Server 2008 Management Data Warehouse: http://msdn.microsoft.com/en-us/library/dd939169.aspx SQL Server 2008 Policy-Based Management: http://msdn.microsoft.com/en-us/library/dd938891...

One of the attendees of my TechEd session “DAT315 - Manageability Series: Uncover Hidden Secrets of T-SQL Scripts with Microsoft SQL Server Management Studio” suggested that I post the list of demos that I did for the session so that they could remember...

I’d like to thank everyone who attended my TechEd session today titled “Manageability Series: Microsoft SQL Server Automation on Steroids, Including PowerShell Support”. Sean McCown – SQL MVP – and all around DBA – creator of the Midnight DBA videos available...

This is my first TechEd in a long time. The last time I spoke at a TechEd was back in 1997 in Japan! I have three sessions this Tuesday, Wednesday, and Thursday that talk about how to get the most out of our manageability suite of tools in SSMS. ...

I’ve been playing around Chad Miller’s SQL Server PowerShell Extensions – SQLPSX 1.5 on CodePlex getting ready for my TechEd session Manageability Series: Microsoft SQL Server Automation on Steroids, Including Powershell on Wed 5/13. Chad has developed...

In part 3 of working with the debugger, I’ll talk about how to set breakpoints and the trick to setting them in stored procedures and triggers. This 3 part series covers: Basic debugging Configure remote debugging & best practices Debugging triggers...

This blog will go over what you need to know for setting up your environment for remote debugging along with best practices and other things to consider when using the debugger in SSMS. This 3 part series covers: Basic debugging Configure remote debugging...

In my next series of blog posts, I’ll explore the Transact-SQL Debugger for SQL Server 2008. This feature only works against database instances of SQL Server 2008. If you need to use a debugger for SQL Server 2005, you’ll have to use the Visual Studio...

This is the fourth in a series of posts highlighting Scott Cate ’s video series of Visual Studio tricks over the last few months from Sara Ford’s blog . As I mentioned in Part 1 , many of the commands are documented in the  SQL Server 2008 help topic...

This is the third in a series of posts highlighting Scott Cate ’s video series of Visual Studio tricks over the last few months from Sara Ford’s blog . As I mentioned in Part 1 , many of the commands are documented in the SQL Server 2008 help topic...