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 Server 2008 Management Studio Express to the web today! We teased out the Tools portion of SQL Server 2008 Express with Tools into it’s own download. It’s free and has most of the tools you would…

6

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 where you’ll issue a command and you’ll wait and wait and wait – only to figure out that the window appeared off the screen. This frequently happens to me in SQL Server Management…

1

Navigation As You Type in Object Explorer Details Pane

In my previous blog entry I talked about how Search works within the Object Explorer Details window in SQL Server 2008 Management Studio. What people often forget is that the Object Explorer Details window has a navigate as you type capability. Assuming that you have the Object Explorer Details window open and the Name column…

1

Search in Object Explorer Details Window

There have been quite a few blog postings about the new Search feature in SQL Server 2008 Management Studio. Here are some examples of what you can find: MSDN – Using Object Explorer Details and SQL Server Object Search Buck Woody’s Carpe Datum – SQL Server 2008 Improvements Practical’s – Object Explorer Details Brad McGehee…

2

My Addiction to Twitter

At the beginning of the year, I told myself that I needed to “blog” more and then came across a posting from Guy Kawasaki on How to use Twitter as a Twool. I got hooked! You can check out by Tweets at https://twitter.com/billramo. What makes Twitter cool is the ability to take someone that you…

1

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

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

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 indicating that the database name was blank. It turns out that with the SQL Server 2008 cumulative update #2, we fixed the problem. The database name was showing up blank for SPIDs that showed to be inactive…

1

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 a unique position – given all of the relationships you build with your customers – to generally survive a layoff. If you want to increase your odds of staying with your company, check out the…

1

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