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

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…

4

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