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

Execution Plan Metrics and Units of Measure

Have you ever looked at the properties inside an execution plan and wondered what the units of measure were? I know I have. I also get the question pretty frequently about all sorts of properties. What does EstimatedAvailableMemoryGrant display it’s units in anyway? For that matter, what the heck is… Read more

1 comments, 155 reads

Posted in The Scary DBA on 11 December 2017

SQL in the City 2017

Redgate is once again hosting a live, virtual event for SQL in the City. We’re going to give you a lot of educational content on DevOps, SQL Server, Monitoring, GDPR and compliance. We’ll also be doing all this with Redgate tools. Here’s my promotional video for the event:

I… Read more

1 comments, 126 reads

Posted in The Scary DBA on 8 December 2017

Why I Use AdventureWorks for Demos

I know that when some people see AdventureWorks, their vision turns all red around the edges, their blood pressure spikes and they begin to foam at the mouth. I do understand. AdventureWorks, Microsoft’s very old, near ubiquitous, sample database suffers from a lot off issues.

What’s The Matter With AdventureWorks?

Read more

7 comments, 141 reads

Posted in The Scary DBA on 4 December 2017