-->
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

SQL Server Automatic Tuning and sys.dm_db_tuning_recommendations

In Azure SQL Database for quite some time and now available in SQL Server 2017, Microsoft has put a lot of the knowledge they’ve gleaned from running more databases that any of the rest of us ever will to work with Automatic Tuning.

Automatic Tuning

The core of automatic… Read more

3 comments, 551 reads

Posted in The Scary DBA on 26 December 2017

Query Store Wait Statistics with sys.query_store_wait_stats

The second best thing to questions that people ask is when I sit down to write a book. It’s so easy to miss things in the day-to-day grind of doing work. Then, late at night, you’re working on a chapter, so you read up on the documentation to ensure that… Read more

8 comments, 253 reads

Posted in The Scary DBA on 18 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

2 comments, 1,282 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, 243 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

9 comments, 277 reads

Posted in The Scary DBA on 4 December 2017