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 the SQL Server Management Studio (SSMS) shell. Many of these techniques are the result of using Visual Studio as the shell for SSMS. This video demonstrates how to use the “Go To Find Combo” command…

3

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

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 from the old one in 2005. The new Activity Monitor has a Recent Expensive Queries pane that allows you to see which of your active queries based on the data in the dm_exec_requests DMV. By default the…

3

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 some things you should know about how the refresh interval works that isn’t completely documented. Unlike the previous version of the Activity Monitor (AM), the new AM starts up with a 10 second refresh interval. That doesn’t…

2

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

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 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 – SQL Server Management Studio Keyboard Shortcuts.   Blog…

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

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 the event a job fails. I was hoping that there was a single MSDN topic on how to do this, but no such luck. The steps are fairly straight forward, but I managed to get…

2

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 are looking for a very lightweight tool that is easy to install for doing basic operations against SQL Server used by your IIS applications, this tool is just for you. It’s much smaller than SQL Server 2008…

2

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