Capturing Queries Can Be a Pain

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...

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

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...

Good Morning!

Grant notes that helping others can help you personally.

Announcing: AWS Community Builders

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...

SQL Server Execution Plans, Third Edition, by Grant Fritchey

Every Database Administrator, developer, report writer, and anyone else who writes T-SQL to access SQL Server data, must understand how to read and interpret execution plans. This book leads you right from the basics of capturing plans, through how to interrupt them in their various forms, graphical or XML, and then how to use the information you find there to diagnose the most common causes of poor query performance.

• Download free eBook
• Printed book:
  • US
  • UK

AWS Deployment Pipelines

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...

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

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...

Do More, With Less

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...

Extended Events Capturing the T-SQL of Prepared Statements

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?...

SQL Server Backups on AWS RDS

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...