-->
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: September 2015

PASS Nominations Committee 2015

The Nominations Committee has done their job and the final report has been published.

Good luck to everyone running. Thank you for stepping up and taking part in this process.

This is the first time in a very long time that I don’t get to put out a “You should… Read more

1 comments, 363 reads

Posted in The Scary DBA on 14 September 2015

Yes, Foreign Keys Help Performance

I created this example several years ago that illustrates how foreign key constraints can help performance. It’s a contrived example. Granted. I feel like it illustrates the point.

However, over the years, people have questioned one aspect of it. The optimizer uses the foreign keys to figure out which tables… Read more

10 comments, 2,488 reads

Posted in The Scary DBA on 9 September 2015

Speaker of the Month: September 2015

Feast or famine.

The last several months I just haven’t seen that many speakers, let alone that many community speakers. Then, in the last month, I’ve seen a ton. Contests being what they are though, someone has to win. To everyone I saw speak at SQL Saturday Oklahoma City and… Read more

1 comments, 347 reads

Posted in The Scary DBA on 4 September 2015