The Scary DBA

Review: Stellar Repair for SQL Server

• by Grant Fritchey

• The Scary DBA

I was contacted by Stellar Info quite a while ago. They asked me to try out their software. I said yes, but I was really bad about getting it...

2020-09-23

36 reads

Extended Events: Filter on Stored Procedure Name

• by Grant Fritchey

• The Scary DBA

I just received a question about Extended Events: What about filtering on the stored procedure name. You know I love writing and talking about Extended Events. The answer is,...

2020-09-04 (first published: 2020-08-24)

413 reads

Azure SQL Database Automatic Tuning

• by Grant Fritchey

• The Scary DBA

I really like the automatic tuning aspect of Azure SQL Database. This post is not a full explanation and demo. Instead, I want to point out a small point...

2020-08-27 (first published: 2020-08-17)

221 reads

My First Hand-built AWS CodePipeline

• by Grant Fritchey

• The Scary DBA

I’ve just completed my first, successful, AWS CodePipeline. I’m sorry to say it took me weeks to figure out just how simple this was. Frankly, it’s embarrassing. I already...

2020-08-19 (first published: 2020-08-10)

286 reads

Capturing Queries Can Be a Pain

• by Grant Fritchey

• The Scary DBA

The moment you decide you want to monitor your SQL Server instance for query behavior, you’re going to be forced to make a bunch of choices. Further, all these...

2020-08-11 (first published: 2020-08-03)

410 reads

Announcing: AWS Community Builders

• by Grant Fritchey

• The Scary DBA

I’m excited to be able to announce that the AWS Community Builders, a new program for those who help out with AWS technologies, has been launched. You can read...

2020-07-30

6 reads

Database Fundamentals #28: Creating a Primary Key Using T-SQL

• by Grant Fritchey

• The Scary DBA

There are actually a couple of ways to create a primary key with T-SQL. You can use the ALTER TABLE script to add a primary key to an existing...

2020-08-06 (first published: 2020-07-28)

418 reads

AWS Deployment Pipelines

• by Grant Fritchey

• The Scary DBA

I’m at the just barely scratching the surface level of getting started with AWS Deployment Pipelines. Of course, the first thing I want to do with them is get...

2020-07-20

52 reads

Do More, With Less

• by Grant Fritchey

• The Scary DBA

Next week, July 22 and 23, I’ll be presenting at Redgate Summit. Summt is our smaller, focused sessions. This one is about the concept of how DevOps, or, more...

2020-07-16

37 reads

Database Fundamentals #27: Creating a Primary Key in the Table Designer

• by Grant Fritchey

• The Scary DBA

Defining primary keys is the hardest part of the operation. You will need to work very closely with the business in order to define exactly what column or columns...

2020-07-20 (first published: 2020-07-14)

329 reads