DB Automation with Azure DevOps

• by Grant Fritchey

• The Scary DBA

I sincerely believe the key to your future as a DBA is your ability to automate everything you do. However, the single hardest thing that you have to do...

2020-03-31 (first published: 2020-03-25)

398 reads

Unit Testing & Intelligent Query Processing

• by Grant Fritchey

• The Scary DBA

Actually, these two topics don’t have anything to do with one another. I just ran out of days to promote everyone individually who was taking part in putting on...

2020-03-31

5 reads

Extended Events: Queries and Waits

• by Grant Fritchey

• The Scary DBA

Wouldn’t it be great to be able to put together queries and waits at the same time? You all capture query metrics using some method. Most of us query...

2020-03-30

6 reads

Containers and DevOps

• by Grant Fritchey

• The Scary DBA

Over the last couple of years, one of these single most exciting technologies to come out around the Data Platform has been containers. You may not see them change...

2020-03-27 (first published: 2020-03-20)

282 reads

Figuring Out How To Hide Production Data

• by Grant Fritchey

• The Scary DBA

There’s a really simple conundrum that we go through all the time. The best data for development is production You can’t have production data for development You have to...

2020-03-27

110 reads

Being an Efficient DBA

• by Grant Fritchey

• The Scary DBA

Or database developer, report writer, whatever. SQL Server, SQL Server Management Studio, and all the tools provide a bunch of ways to get things done. However, some ways are...

2020-03-24

33 reads

Extended Events: Live Data Explorer, Getting Started

• by Grant Fritchey

• The Scary DBA

One reason a lot of people don’t like Extended Events is because the output is in XML. Let’s face it, XML is a pain in the bottom. However, there...

2020-03-24 (first published: 2020-03-16)

239 reads

Extended Events: Live Data Explorer, Grouping

• by Grant Fritchey

• The Scary DBA

Of all the things that Extended Events does, I’ve found the ability to quickly and easily gather a little bit of data and then use the Data Explorer window...

2020-03-23

89 reads

Missing #SQLFamily? Check This Out.

• by Grant Fritchey

• The Scary DBA

I am an introvert. Lots of people don’t believe it, but it’s true. However, I really do love getting to see my #SQLFamily all over the world in my...

2020-03-19

9 reads

Extended Events: system_health and a Long Running Query

• by Grant Fritchey

• The Scary DBA

Wouldn’t it be great to just quickly and easily take a look at your system to see if you had any queries that ran for a long time, but,...

2020-03-16 (first published: 2020-03-09)

536 reads