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: April 2017

Food On Your Table

I was asked, “Who here thinks that PASS helps people put food on the table?” To my shame, I initially said no. I mean after all, it’s just training and networking that could lead to improved knowledge and abilities which… hang on. Just how wrong I can be sometimes when… Read more

1 comments, 384 reads

Posted in The Scary DBA on 25 April 2017

Query Hash Values, Plan Guides and the Query Store

I was eating dinner with Hugo Kornelis and we started talking about query hash values. You know, like everyone does at dinner. As we talked about it, I suddenly thought about both Plan Guides and the Query Store. I wondered what happened to the query hash values in that case?… Read more

0 comments, 1,137 reads

Posted in The Scary DBA on 24 April 2017

The Age of Data and Software Development

I am so excited to be a data professional in the modern era. Yeah, 15-20 years ago, it was cool to be a DBA and a database developer. However, now, it’s amazing. Data drives, or should drive, all our decisions. Whether we’re deciding how high to set the cost threshold… Read more

2 comments, 398 reads

Posted in The Scary DBA on 17 April 2017

Alerts From Azure Automation

In a previous post, I showed how to set up statistics maintenance for your Azure databases using Azure Automation. However, what I didn’t show was how to generate an alert when things go south. Let’s do that now.

An Error Needing an Alert

First, I need to generate an… Read more

4 comments, 614 reads

Posted in The Scary DBA on 4 April 2017

Learning Azure From The Web

I’m working on a technical blog post that I hope to be putting up soon. I’ve run into a number of configuration issues that I’m working through. However, it’s these issues that sparked this blog post.

See, we’re learning Azure all wrong.

Use Google/Bing

What’s the first thing you do… Read more

3 comments, 418 reads

Posted in The Scary DBA on 3 April 2017