Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

The Scary DBA

I have twenty+ years experience in IT. That time was spent in technical support, development and database administration. I work forRed Gate Software as a Product Evangelist. I write articles for publication at SQL Server Central, Simple-Talk, PASS Book Reviews and SQL Server Standard. I have published two books, ”Understanding SQL Server Execution Plans” and “SQL Server 2008 Query Performance Tuning Distilled.” I’m one of the founding officers of the Southern New England SQL Server Users Group and its current president. I also work on part-time, short-term, off-site consulting contracts. In 2009 and 2010 I was awarded as a Microsoft SQL Server MVP. In the past I’ve been called rough, intimidating and scary. To which I usually reply, “Good.” You can contact me through grant -at- scarydba dot kom (unobfuscate as necessary).

Archives: July 2009

PASS & SQL Bloggers


PASS is trying to find better ways to reach out to SQL Bloggers. They’re going to experiment with taking advantage of the new subgroup features offered by LinkedIn. Membership to the subgroup will come fromthose currently listed in the PASS blog directory. If you’re looking to get into a…

Read more

0 comments, 525 reads

Posted in The Scary DBA on 31 July 2009

No really. When did this statement start?


I thought I had an interesting answer to the question. Unfortunately Adam Machanic, who has been working in this specific area quite a bit longer than I have, and, let’s face it, is a bit smarter, pointed out (in the comments) the possibility that I didn’t have this quite right.

Read more

0 comments, 534 reads

Posted in The Scary DBA on 31 July 2009

When did this statement start?


UPDATE: This post is incorrect. Adam nailed it in the comments. I explain my mistake here.

A question came up over at SQL Server Central where someone was wondering if it was possible to know when a given statement within a batch started. Immediately I thought, oh yeah,…

Read more

0 comments, 609 reads

Posted in The Scary DBA on 28 July 2009

Attache/Brief Case Review


Steve Jones, through a series of comments, emails, blackmail, back-alley deals & tons of whining, agreed to let me review a brief case, the Maxpedition Hard Use Gear Aggressor Attache. The review is up over at SQL Server Central and a video I made of the bag should be…

Read more

0 comments, 223 reads

Posted in The Scary DBA on 24 July 2009

Conversations


Do you know how to start a conversation or how to join one? I usually wait for a pause and then blurt out whatever point I thought was missed, missing, or insufficiently covered. In other words, don’t come to me for advice. The fact of the matter is, while the…

Read more

0 comments, 241 reads

Posted in The Scary DBA on 21 July 2009

MS Field Engineer’s on Performance Troubleshooting


Do you want to get a glimpse into how the Microsoft Field Engineers would go about troubleshooting performance issues on your server? Then go and read this blog entry by Denzil Ribeiro. Not only is this an excellent how-to on troubleshooting performance problems, but Mr. Ribeiro provides multiple links that…

Read more

0 comments, 359 reads

Posted in The Scary DBA on 20 July 2009