January 2009 - Posts

28 January 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 posting from Guy Kawasaki on How to use Twitter as a Twool . I got hooked! You can check out by Tweets at http://twitter.com/billramo . What makes Twitter Read More...

1 Comments

 

19 January 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 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 Read More...

3 Comments

Filed under: SSMS

 

13 January 2009
Not 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 Read More...

3 Comments

Filed under: Activity Monitor

 

02 January 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 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 Read More...

1 Comments

 

01 January 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 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 Read More...

1 Comments