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: August 2018

Why I Love Extended Events, Reason 394: Customize Live Data

There are so many reasons to love Extended Events that it can really be overwhelming, but, one more reason that I love them are the ability to customize Live Data. More importantly, you can share that customization with others or move it between machines. Let’s explore this. Customize Live Data… Read more

3 comments, 342 reads

Posted in The Scary DBA on 27 August 2018

SQL in the City Summit

This fall, in October, Redgate Software will be hosting three, live, in-person events. These events will take place in New York, London and Chicago. They are on the 12th, 18th, and 26th of October, respectively. You can follow this link to read all the details. I’ll be speaking there, along… Read more

0 comments, 1,452 reads

Posted in The Scary DBA on 21 August 2018

Actual Execution Plan Costs

Why don’t “actual execution plans” have “actual execution plan costs”? This is a question and a myth I have to fight against all the time. It’s so hard to convince people that all execution plans are estimated plans in the first place (by the way, all execution plans are estimated… Read more

0 comments, 289 reads

Posted in The Scary DBA on 20 August 2018

Rant: There Is No NoSQL Data Storage Engine

Do I need relational or NoSQL? How does NoSQL help me scale? Will I get paid better with NoSQL or relational? Does NoSQL make my butt look big? OK, maybe I made up that last one. However, the others are all variations of questions I’ve been seeing a lot of… Read more

6 comments, 2,833 reads

Posted in The Scary DBA on 15 August 2018

Measuring Query Execution Time: What Is Most Accurate

Probably the single most important factor when deciding which query to tune, or actively tuning a query, is how you go about measuring query execution time. SQL Server provides a number of different mechanisms (really, maybe too many) to get this done. However, all measures are not created equally. In… Read more

2 comments, 2,701 reads

Posted in The Scary DBA on 13 August 2018

Analyze Actual Execution Plan

One of the many new sets of functionality introduced in SQL Server Management Studio 17 is the new option “Analyze Actual Execution Plan.” If Microsoft continues down this path, there will be a lot of useful functionality at some point. If you haven’t yet looked at Analyze Actual Execution Plan,… Read more

2 comments, 2,607 reads

Posted in The Scary DBA on 6 August 2018

Youtube Channel Update: 3 August 2018

I’ve posted a number of new videos to the Youtube channel that might be of interest if you’re a data professional. First up, I’ve started migrating my Database Fundamentals posts over to Youtube as SQL Server Fundamentals. The first one is available: Speaking of DBAs, the job is not going… Read more

0 comments, 378 reads

Posted in The Scary DBA on 3 August 2018