Bill Ramos on SQL Server

Adventures in SQL Server

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

Author: Bill Ramos Date: 02/19/2011

SQL Saturday 47 Phoenix February 2011

Today I presented data collection strategies for SQL Server 2008 at Phoenix SQL Saturday 47. I’ve...

Author: Bill Ramos Date: 02/19/2011

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

Author: Bill Ramos Date: 01/30/2011

Bill Ramos–Moving On–But Not Too Far

Bill Ramos, formally Principal Program Manager, SQL Server Manageability Now WorkStream Manager for...

Author: Bill Ramos Date: 11/19/2010

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

Author: Bill Ramos Date: 11/18/2010

Author: Bill Ramos Date: 11/14/2010

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

Author: Bill Ramos Date: 10/24/2010

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

Author: Bill Ramos Date: 10/10/2010

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

Author: Bill Ramos Date: 10/03/2010

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

Author: Bill Ramos Date: 06/28/2010

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

Author: Bill Ramos Date: 06/21/2010

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

Author: Bill Ramos Date: 06/19/2010

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

Author: Bill Ramos Date: 06/06/2010

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

Author: Bill Ramos Date: 05/12/2010

New Manageability White Papers for SQL Server 2008

TechNet Books Online just published three whitepapers - check them out! SQL Server 2008 Management...

Author: Bill Ramos Date: 06/12/2009

DAT315 – Session Review for SSMS Tips & Tricks Session

One of the attendees of my TechEd session “DAT315 - Manageability Series: Uncover Hidden Secrets of...

Author: Bill Ramos Date: 05/15/2009

Welcome to TechEd 2009

This is my first TechEd in a long time. The last time I spoke at a TechEd was back in 1997 in Japan!...

Author: Bill Ramos Date: 05/10/2009

SQLPSX from Chad Miller

I’ve been playing around Chad Miller’s SQL Server PowerShell Extensions – SQLPSX 1.5 on CodePlex...

Author: Bill Ramos Date: 05/06/2009

Transact-SQL Debugger for SQL Server 2008 – Part 3

In part 3 of working with the debugger, I’ll talk about how to set breakpoints and the trick to...

Author: Bill Ramos Date: 04/12/2009

Transact-SQL Debugger for SQL Server 2008 – Part 2

This blog will go over what you need to know for setting up your environment for remote debugging...

Author: Bill Ramos Date: 04/12/2009

Transact-SQL Debugger for SQL Server 2008 – Part 1

In my next series of blog posts, I’ll explore the Transact-SQL Debugger for SQL Server 2008. This...

Author: Bill Ramos Date: 04/11/2009

SQL Server Management Studio Tips – Part 4

This is the fourth in a series of posts highlighting Scott Cate’s video series of Visual Studio...

Author: Bill Ramos Date: 04/10/2009

SQL Server Management Studio Tips – Part 3

This is the third in a series of posts highlighting Scott Cate’s video series of Visual Studio...

Author: Bill Ramos Date: 04/09/2009

SQL Server Management Studio Tips – Part 2

This is the second in a series of posts highlighting Scott Cate’s video series of Visual Studio...

Author: Bill Ramos Date: 04/09/2009

SQL Server Management Studio Tips – Part 1

Scott Cate has been publishing a video series of Visual Studio tricks over the last few months from...

Author: Bill Ramos Date: 04/09/2009

SQL Server Agent and Database Mail – Better Together

This post is how to configure SQL Agent to use Database Mail for sending an email to an operator in...

Author: Bill Ramos Date: 03/30/2009

Using Live/Hotmail/MSN for SQL Server 2008 Database Mail

Over the weekend, I was playing around with trying to use my hotmail email account for SQL Server...

Author: Bill Ramos Date: 03/29/2009

Database Manager for IIS 7 RC Preview

I recently had a chance to preview the Release Candidate of Database Manager 1.0 for IIS7. If you...

Author: Bill Ramos Date: 03/26/2009

SQL Server 2008 Management Studio Express – Released to the Web

I just wanted to let the community know that we have just released a new Express edition called SQL...

Author: Bill Ramos Date: 02/20/2009

Window – Window – Where art thou?

If you are a fan of using dual monitors like I am, you have – without a doubt – had a situation...

Author: Bill Ramos Date: 02/18/2009

In my previous blog entry I talked about how Search works within the Object Explorer Details window...

Author: Bill Ramos Date: 02/09/2009

Search in Object Explorer Details Window

There have been quite a few blog postings about the new Search feature in SQL Server 2008 Management...

Author: Bill Ramos Date: 02/08/2009

My Addiction to Twitter

At the beginning of the year, I told myself that I needed to “blog” more and then came across a...

Author: Bill Ramos Date: 01/28/2009

Find strings fast in SQL Server Management Studio

This is the first of a series of video based blog entries where I will share tips and tricks within...

Author: Bill Ramos Date: 01/19/2009

No more excuses of missing indexes with Activity Monitor in SQL Server 2008

The new version of Activity Monitor for SQL Server 2008 Management Studio has a new look and feel...

Author: Bill Ramos Date: 01/13/2009

Case of the missing database name in Activity Monitor

I was going through my backlog of Connect posts today and noticed a submission of a bug report...

Author: Bill Ramos Date: 01/02/2009

DBAs – Are you ready for the steel cage death match?

Times are certainly tough and bound to get tougher in 2009. As a DBA, you and your teammates are in...

Author: Bill Ramos Date: 01/01/2009

New Activity Monitor – What you should know about the Refresh Interval

Now that you know where to find the Activity Monitor in SQL Server 2008 Management Studio, here are...

Author: Bill Ramos Date: 12/29/2008

Where is that darn Activity Monitor in SQL Server 2008?

Technorati Tags: SQL Server 2008,Activity Monitor,SSMS You may have heard – we rewrote the Activity...

Author: Bill Ramos Date: 12/28/2008

Post Web Cast Questions - Answered

Over 900 attended my web cast on Monday. With the help of Bruce Prang and Michael Benkovich, they...

Author: Bill Ramos Date: 12/13/2004