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...
2020-08-11 (first published: 2020-08-03)
418 reads
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)
418 reads
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)
484 reads
2020-08-01
90 reads
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
7 reads
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.
2020-07-28
205 reads
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
54 reads
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)
330 reads
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
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)
300 reads
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)
273 reads
By Devin-Knight
There are a lot of hot phrases you’ve likely heard thrown around during various...
By Kamil
Azure Data Factory is a fantastic tool which allows you to orchestrate ETL/ELT processes...
By Steve Jones
Today is the last day that the PASS and SQL Saturday websites will be...
Comments posted to this topic are about the item Who is my customer?
Hi, First time poster, and hoping everyone goes easy on me. I am very...
hi all, I need some help here. Recently, I've found a db with error...