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 2018

Automating Automatic Indexing in Azure SQL Database

I’ve been in love with the concept of a database as a service ever since I first laid eyes on Azure SQL Database. It just makes sense to me. Take away the mechanics of server management and database management. Focus on the guts of your database. Backups, consistency checks, these… Read more

5 comments, 1,924 reads

Posted in The Scary DBA on 30 April 2018

YouTube Channel Update: 27 April 2018

Despite a hiccup recently on Twitter where I managed to spam all my followers with links to my YouTube videos (so sorry about that), I am still posting videos. Please subscribe to the channel.

Video Lists

I created video lists. Here they are, in no particular order:

SQL Server and… Read more

0 comments, 467 reads

Posted in The Scary DBA on 27 April 2018

Presentation Tools

Let’s face it, the core of a presentation is you. Your knowledge and your ability to share that knowledge through whatever means you choose, slides, demos, sock puppets, whatever, is the primary tools you need to hone. Know what you know and be ready to acknowledge what you don’t. Put… Read more

6 comments, 290 reads

Posted in The Scary DBA on 23 April 2018

Execution Plan Shortcoming in Extended Events

I use Extended Events almost exclusively for capturing query metrics. They are the most consistent and lowest cost mechanism for getting the time and resources used by a query. They can be filtered, combined with other events, they’re just marvelous… until you capture an execution plan.

Execution Plans in Extended…

Read more

3 comments, 1,552 reads

Posted in The Scary DBA on 16 April 2018

Privacy and Protection, By Design

With all the noise about the upcoming enforcement of GDPR, I know that people are starting to focus more on privacy and protection. Add in all the other news about data breaches and data leaks and suddenly, privacy and protection isn’t just a business concern, it’s personal. Where do you… Read more

0 comments, 423 reads

Posted in The Scary DBA on 11 April 2018

GDPR, Database Backups, and the Right to be Forgotten

I’ve said it before, but it bears repeating, there is no cause for any kind of panic when it comes to the GDPR. None. There are however, a number of concerns. One of those concerns is, well, concerning. How does the right to be forgotten within the GDPR impact… Read more

23 comments, 3,270 reads

Posted in The Scary DBA on 9 April 2018

Buggy Whips 2.0

I recently found myself rereading a very old blog post of mine, from the very beginning of this blog, discussing Buggy Whips. I’ll save you the long read, I was learning new tech, it made me second guess my working assumptions, I was curious if I was manufacturing a… Read more

4 comments, 268 reads

Posted in The Scary DBA on 2 April 2018