MDW Reports–New Source Code ZIP File Available

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. The reports assume that…

9

SQL Saturday 47 Phoenix February 2011

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. SQL Server 2008 Data Collector Proof of Concept – How…

0

SQL Server 2008 Data Collector Proof of Concept

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 installation of the new Query Hash Stats…

1

Bill Ramos–Moving On–But Not Too Far

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 called http://www.advaiya.com. They specialize in developing strategy for the Microsoft product line, delivering content to the community and the Microsoft…

2

May the source be with you! MDW Report Series Part 6–The Final Edition

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. At last week’s SQL PASS, I announced in my Wednesday session that I would release…

16

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

Finding Bill Ramos at SQL PASS 2010

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 6-8pm This event is taking place at…

0

What are all these reports anyways? – MDW Report Series Part 5

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 for the system collection sets. Kalen Delaney covered the top level reports in…

2

Enabling SQL Server Management Pack Alerts with System Center Operations Manager 2007 – Enabling the Blocking Sessions Rule

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” VM using  SQL Server 2008 R2 as the back end. One of the big features of…

2

Installing the SQL Server 2008 R2 Management Pack for System Center Operations Manager 2007 R2

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) on a bare bones Windows Server 2008 R2 Hyper-V virtual machine.  I’ll include…

3