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

Youtube Channel Update


I just wanted to take a moment to promote the work I’ve been doing with the YouTube Channel.

I’ve published four videos in the last week. The most popular was an introduction to the GDPR:

I’ll be talking about that quite a bit more in the coming weeks. Read more

1 comments, 270 reads

Posted in The Scary DBA on 29 January 2018

You Need a New Hobby

Not sure who this is that is attempting to hack into my blog so desperately, but seriously, time for a new hobby:

administrador 20 mins ago
administrador 1 hour 41 mins ago
administrador 3 hours 2 mins ago
administrador 4 hours 20 mins ago

Read more

10 comments, 287 reads

Posted in The Scary DBA on 23 January 2018

Database Fundamentals #16: Removing Data With T-SQL

Deleting data from a table using T-SQL works quite a lot like the UPDATE statement.

How it Works

In the same way you supply the statement, DELETE, and then the table name. You’re not going to specify columns in any way because deleting data is all about removing a… Read more

4 comments, 2,211 reads

Posted in The Scary DBA on 22 January 2018

Updated YouTube Channel

Hello all,

I’ve recently updated my YouTube channel. I’m going to be posting a lot more videos up there. If you would like to take advantage of it, please go here and click on the subscribe button. I’ll be covering pretty much the same type of thing there that I… Read more

4 comments, 318 reads

Posted in The Scary DBA on 16 January 2018

Getting Started in a SQL Server 2017 VM in Azure

You say you’re ready to dip your toes in the Azure ocean? Come on in, the water’s fine!

Oh, you want to really dip your toes. You’re starting with Virtual Machines? OK. I guess. It’s not where the real excitement is. You should be checking out Azure SQL Database and… Read more

2 comments, 1,194 reads

Posted in The Scary DBA on 15 January 2018

Statistics Use, Extended Events and Execution Plans

Query tuning ain’t easy.

Figuring out which index is getting used is one step, and generally simple, look at the execution plan to see which index is in use and whether it’s being used in a SEEK or a SCAN. Done. However, when your index isn’t being used, how do… Read more

2 comments, 2,223 reads

Posted in The Scary DBA on 8 January 2018

Snow, Heathrow Airport, Disaster Recovery

I recently flew from Boston to the UK through the Heathrow airport. It just happened to be on the day that the UK got about 1.5 inches of snow (sorry, 3.8 centimetres, according to Weather Underground though, just 15mm, not sure about that). I spent a little more than… Read more

0 comments, 683 reads

Posted in The Scary DBA on 2 January 2018