Blog Posts

Learning Jupyter Notebooks

• The Scary DBA

I’m starting the process of learning how to use Jupyter Notebooks. Notebooks are documents that contain live code, commentary, results, pictures and more. Jupyter Notebooks are used for presentations,…

Grant Fritchey

2019-04-08

25 reads

Jobs That Beat The Caring Out Of You

• The Scary DBA

I was inspired by Jen McCown’s story here. Read that first. It’s WAY better than mine. This is not an April Fools post. Fools are involved, but none were…

Grant Fritchey

2019-04-01

60 reads

Can You Force A Parallel Plan in Query Store?

• The Scary DBA

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…

Grant Fritchey

2019-03-25

61 reads

Monitoring Your Databases and Servers and…

• The Scary DBA

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…

Grant Fritchey

2019-03-19

2 reads

Compliance Ain’t Easy

• The Scary DBA

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

Grant Fritchey

2019-03-18

1 reads

Database Development Gone Wrong

• The Scary DBA

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…

Grant Fritchey

2019-03-13

1 reads

Missing Indexes in the Query Store

• The Scary DBA

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…

Grant Fritchey

2019-03-11

5 reads

system_health Extended Events in Azure SQL Database

• The Scary DBA

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…

Grant Fritchey

2019-03-04

How Do You Export A Database in Azure Data Studio

• The Scary DBA

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…

Grant Fritchey

2019-02-25

Installing Extensions to Azure Data Studio

• The Scary DBA

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…

Grant Fritchey

2019-02-18