SQL Clone
SQLServerCentral is supported by Redgate
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: June 2011

Presentations in Action

The first book I read for my 12 goal oriented books was Jerry Weissman’s Presentations in Action: 80 Memorable Presentation Lessons from the Masters.

Up front, let me say, this book met my expectations. I expected to see a lot of things I already knew. I expected to learn… Read more

1 comments, 628 reads

Posted in The Scary DBA on 27 June 2011

Make the Optimizer Work Harder

One of my favorite indicators for whether or not you have a good execution plan is when you see the “Reason for Early Termination” property in the TSQL operator like this:

The optimizer considered this particular plan “Good Enough.” which is what you want to see. When you see “Timeout”… Read more

2 comments, 2,690 reads

Posted in The Scary DBA on 20 June 2011

Rebind and Rewind in Execution Plans

Ever looked at an execution plan? If you answered no, you can’t possibly have ever tried to tune a query, or, you’re doing it wrong. For every one else, no doubt you’ve looked at the tool tips or the property sheets of an operator and you’ve seen the Rebind &… Read more

0 comments, 4,685 reads

Posted in The Scary DBA on 15 June 2011

Time for a Little PD

No, PD doesn’t stand for PowerShell Development. It stands for Professional Development. Sharks either swim or die (and yes, I know that’s not 100% accurate, but I need a hook on which to hang this lesson). Knowledge workers either develop more knowledge or become buggy whip manufacturers. It’s that simple.… Read more

1 comments, 731 reads

Posted in The Scary DBA on 13 June 2011

SQL Cruise Alaska 2011

Yes, I went on the SQL Cruise to Alaska. Yes, it was as grand as you’ve heard. Yes, I’m going to be putting up a series of blog posts about it. This is the first. It’s also part of my class work done during the cruise.

Three Reasons for Choosing…

Read more

0 comments, 528 reads

Posted in The Scary DBA on 8 June 2011