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

Can You Force A Parallel Plan in Query Store?

I love the questions I get when presenting: Can You Force a Parallel Plan in Query Store. I haven’t a clue. The trick I think is going to be in setting up the test. Let’s try it out. Reliably Getting a Parallel Plan Because this is for testing, rather than… Read more

0 comments, 94 reads

Posted in The Scary DBA on 25 March 2019

Monitoring Your Databases and Servers and…

You absolutely need to know about the servers you have under management in your estate. You need to know about the databases. Uptime, performance, behaviors, errors, corruption and a much longer list of items that will frankly fill this blog post, are very important to you. I’ve been doing work… Read more

2 comments, 170 reads

Posted in The Scary DBA on 19 March 2019

Compliance Ain’t Easy

I’m sure by now you’ve heard of the GDPR and some of the large scale data breaches that have occurred within it. If you haven’t heard of the GDPR, you’ve been under a rock, or, you’re like me, a United States citizen (it’s amazing how little we know about this… Read more

0 comments, 122 reads

Posted in The Scary DBA on 18 March 2019

Database Development Gone Wrong

I recently shared a story about how I was personally responsible for a development project going off the rails (and oh boy, did it go off the rails). It’s a very painful story to share since I was the principal bad guy. However, I learned a lot of lessons from… Read more

2 comments, 175 reads

Posted in The Scary DBA on 13 March 2019

Missing Indexes in the Query Store

I’ve shown before how to use the DMVs that read the plan cache as a way to connect the missing indexes suggestions with specific queries, but the other place to find missing index suggestions is the Query Store. Pulling from the Query Store The plans stored in the Query Store… Read more

2 comments, 1,990 reads

Posted in The Scary DBA on 11 March 2019

system_health Extended Events in Azure SQL Database

The system_health Extended Events session is incredibly useful. Further, it’s running, by default, in every server you have under management that is 2008 or greater. Things are not the same in Azure though. system_health in Azure SQL Database If you look at the documentation for system_health, it shows that it’s… Read more

1 comments, 176 reads

Posted in The Scary DBA on 4 March 2019

How Do You Export A Database in Azure Data Studio

I’ve been writing a bunch about Azure Data Studio. I’ve also been recording videos on the topic. A comment I received recently asked how to export a database from Azure Data Studio. It made me want to explore the topic of exporting a database as it relates to Azure Data… Read more

4 comments, 2,334 reads

Posted in The Scary DBA on 25 February 2019

Installing Extensions to Azure Data Studio

If you’re even thinking about experimenting with, let alone actively using, Azure Data Studio, you need to plan on installing a few extensions. Buck Woody has a great list that you should look through in this blog post. If you’re just getting started with Azure Data Studio, I have an… Read more

3 comments, 297 reads

Posted in The Scary DBA on 18 February 2019

Query Store and a READ_ONLY Database

What happens in Query Store when the database itself is READ_ONLY? Yeah, I don’t know. Let’s find out. READ_ONLY The only way to find out how this works is to test it. So, let’s write some code: Executing that resulted in a small glitch in the Matrix: 8:00:54 AMStarted executing… Read more

2 comments, 1,747 reads

Posted in The Scary DBA on 11 February 2019

Combine Extended Events and TagWith to Monitor Entity Framework

I’m going to start with a sentence that makes a lot of people crazy; As a DBA and database developer, I love Entity Framework. That’s right. Entity Framework is the bomb. It’s amazing. It does wonderful stuff. Entity Framework makes the developers lives and jobs easier. It makes my life… Read more

2 comments, 146 reads

Posted in The Scary DBA on 4 February 2019

Opening a Twitch Channel, Data Wisdom

I want to let you know that I’m starting a channel on Twitch. You’ll be able to see it here. I’m going to start doing regular live events on Fridays, probably around 10AM. Topics will range from query tuning, to GDPR, to Redgate, to Azure Data Studio, pretty much the… Read more

2 comments, 181 reads

Posted in The Scary DBA on 29 January 2019

Input Into Azure Data Studio

I see more and more people starting to use Azure Data Studio. As it keeps growing and expanding, it’s going to become more and more a go-to tool for everyone that has to work with the Microsoft Data Platform. Wouldn’t it be good to be able to provide direct feedback… Read more

1 comments, 1,782 reads

Posted in The Scary DBA on 28 January 2019

All Day, Training Day at SQLBits

It’s a somewhat late addition, but I have an all-day Training Day at SQLBits. It takes place on Thursday, February 28th. You can read all about it on the SQLBits web site. I want to take a moment here to expand on the information that we’re going to cover. I… Read more

2 comments, 223 reads

Posted in The Scary DBA on 23 January 2019

Critiquing Grant Fritchey: Circa 2008

For several years, I ran a regular feature on this blog, Speaker of the Month. I attend a lot of events, so I have the opportunity to hear a lot of people talk about various topics. I decided, as an attempt to help out, to call out individuals that I… Read more

2 comments, 156 reads

Posted in The Scary DBA on 22 January 2019

Get Your Learn On

There is one truth that I can say about technology with an absolute certainty: It’s going to change. Get your learn on! Technology is going to be shifting under your feet, constantly. Even if all you ever do is work with SQL Server, on premises, on hardware, without VMs, containers,… Read more

1 comments, 141 reads

Posted in The Scary DBA on 21 January 2019

DevOps and Automation Will Eliminate the DBA

I’ve been reading about the death of the DBA ever since I first made the jump from full time developer to full time data professional. The first time I heard it was when SQL Server 7.0 was released. Did you know that SQL Server 7.0 was self-tuning? In fact, it… Read more

12 comments, 2,661 reads

Posted in The Scary DBA on 14 January 2019

PowerShell to Simulate Load

Gathering metrics is quite difficult if there are no queries. So, if you’re working in non-production environments, but you still want to see some sort of load on the server, how can you do it? I use a simple PowerShell script to simulate load. Simulate Load I’ve posted a sample… Read more

4 comments, 2,224 reads

Posted in The Scary DBA on 7 January 2019

Redgate Reviews 2018, Predicts 2019

Our boss came to us and said, “We need one more webinar to round out the year.” Well, we’re just like you guys, counting down the hours until our holidays start like a short-timer in the military looking at that discharge date.  The boss wants an entertaining, engaging, informative webinar.… Read more

0 comments, 159 reads

Posted in The Scary DBA on 17 December 2018

Privacy and Protection in the Age of the GDPR

We’re seeing more and more GDPR-style laws coming out from various governments. With the GDPR starting to do enforcement at long last, it’s pretty clear that privacy and protection is a growing thing. Add to this the fact that SQL Injection is still an issue along with all the other… Read more

4 comments, 237 reads

Posted in The Scary DBA on 10 December 2018

Database Fundamentals #20: Using the JOIN Operator, Inner Join

It is entirely possible to try to JOIN two tables on almost any field, as long as the two data types can, in some way, be made to reconcile to each other, you can try to join the tables. But, most database designs assume a much more directly relationship and… Read more

9 comments, 2,493 reads

Posted in The Scary DBA on 3 December 2018

Older posts