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

Introducing Azure Data Studio

If you’re watching Microsoft Ignite or tracking the information coming out of it on social media, then you know that Azure SQL Studio has been changed to Azure Data Studio. I’ve got an early release on some of the bits. Let’s explore what’s going on. Azure Data Studio The core… Read more

9 comments, 3,528 reads

Posted in The Scary DBA on 24 September 2018

Extended Events and Stored Procedure Parameter Values

One complaint I’ve received frequently is that you can’t see stored procedure parameter values in Extended Events. That is patently not true. However, it does depend on where and how you capture the events and which stored procedure parameter values you’re going for. I think this is a holdover from… Read more

4 comments, 348 reads

Posted in The Scary DBA on 24 September 2018

Databases and DevOps, It’s Not Just Me

Anyone who subscribes to my blog or my YouTube channel as well as anyone following me on social media knows that I talk about DevOps and databases a lot. I can’t help it. I have a real passion for the topic. I sincerely believe we should all be taking advantage… Read more

5 comments, 300 reads

Posted in The Scary DBA on 19 September 2018

Announcing the 5th Edition of SQL Server 2017 Query Performance Tuning

I am quite excited to announce that the latest, most up to date, and by far the largest, copy of my book on query tuning is now available. 900 pages of information on how to improve the performance on your Azure SQL Database and SQL Server instances has been published.… Read more

7 comments, 265 reads

Posted in The Scary DBA on 18 September 2018

Query Store and Log Backups

A question that came up recently around Query Store is what happens when there are log backups in use on the database. Let’s talk about it. Query Store and Log Backups The core of the answer is very simple. Query Store, like any other data written to a database, whether… Read more

3 comments, 200 reads

Posted in The Scary DBA on 17 September 2018

3rd Edition, SQL Server Execution Plans, a Story

Four years ago, after a bunch of dithering and some negotiations with Tony Davis, my editor, I started to update my book, SQL Server Execution Plans. We managed to convince Hugo Kornelis to be the tech editor. I started to do the real writing in early 2015. I was most… Read more

27 comments, 1,859 reads

Posted in The Scary DBA on 12 September 2018

Estimated Plans and Forced Plans from Query Store

While all plans are estimated plans, there is still a difference between capturing an estimated plan and looking at a plan from the cache or from query store. Or is there? A question came up during a recent presentation; what happens to capturing an estimated plan when you’re forcing plans?… Read more

0 comments, 1,748 reads

Posted in The Scary DBA on 10 September 2018

Back to University, Redgate University

Let’s be really clear, Redgate makes ingeniously simple tools. That’s a fact. Nothing has changed. However, if you really want to get the full range of capability out of the tools, you need to understand how best to put them to work. Enter Redgate University. Redgate University The concept is… Read more

1 comments, 268 reads

Posted in The Scary DBA on 3 September 2018