The Scary DBA

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)

503 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

56 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

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

333 reads

Extended Events Capturing the T-SQL of Prepared Statements

• by Grant Fritchey

• The Scary DBA

I asked this question myself: Is there a way to use Extended Events to capture the T-SQL of a prepared statement? Why would I be concerned with prepared statements?...

2020-07-15 (first published: 2020-07-06)

313 reads

SQL Server Backups on AWS RDS

• by Grant Fritchey

• The Scary DBA

One of the things I love the most about Platform as a Service offerings is the fact that it makes it so I don’t have to do silly things...

2020-07-09 (first published: 2020-06-29)

299 reads

State of Database Monitoring

• by Grant Fritchey

• The Scary DBA

Redgate published a report that many of you helped with by providing information. First, thanks! Your info really helped. Second, do you want to see it? You can. Go...

2020-06-22

9 reads

Database Fundamentals #26: The Primary Key War

• by Grant Fritchey

• The Scary DBA

There is a war about primary keys in the database world. There are two camps. The first camp believes that primary keys should only ever be created on meaningful...

2020-07-06 (first published: 2020-06-22)

673 reads

Combining DMVs, Query Store and Extended Events Is Challenging

• by Grant Fritchey

• The Scary DBA

I was recently asked a question on a forum by a person who was frustrated with all the tool choices we have for measuring performance. Moreover, they were frustrated...

2020-06-18

3 reads

AWS RDS and SQL Server Deadlocks

• by Grant Fritchey

• The Scary DBA

What’s the story with AWS RDS and SQL Server deadlocks? I’m approaching AWS RDS like I was taking on a new role at a new organization. Do we have...

2020-06-08

62 reads