What Prevents You From Securing Your Servers?

• by Grant Fritchey

• The Scary DBA

Reading about how hackers are using SQL Server instances that are exposed on the internet AND have weak passwords to work into systems, I’m sitting here wondering why. I...

2020-04-06

3 reads

Time To Learn Git

• by Grant Fritchey

• The Scary DBA

I love this quote from Kevin Hill (and not because he mentions me): 3 things I can no longer justify ignoring: #dbatools Git and #Docker for my dev SQL work@cl@sqldbawithbeard@Kendra_Little and @unclebiguns@GFritchey, I blame you...

2020-04-03 (first published: 2020-03-26)

924 reads

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)

353 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

2 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

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

261 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

101 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

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

225 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

79 reads