This article demonstrates a more comprehensive method to audit changes to statistics. This method involves the use of Extended Events.
The post Statistics Auditing to make you Omniscient first appeared...
2021-12-29
80 reads
This article demonstrates a more comprehensive method to audit changes to statistics. This method involves the use of Extended Events.
The post Statistics Auditing to make you Omniscient first appeared...
2021-12-28
7 reads
By combining the raw power of the Extended Events engine in SQL Server with the Blocked Process Report, we are able to achieve real value in blocking monitoring.
The post...
2021-12-28
652 reads
Queries will fail. That is as inevitable as death and taxes. This article demonstrates how to find some truly horrible queries.
The post Queries that Fail and How to find...
2021-12-28
753 reads
Stability and reporting go hand in hand. You cannot truly have stability without reporting. Take the time to share the stability successes with the business. Let them revel in...
2022-01-10 (first published: 2021-12-27)
329 reads
No matter how you name it, "hairball", "spaghetti code", "tech debt" or "DIY code", the result is the same - you are dealing with legacy code that nobody wants...
2022-01-05 (first published: 2021-12-25)
353 reads
In this article, I have shown the importance of performing three different validation tests against your Availability Group Endpoints. Each test also demonstrates what can be run in the...
2021-10-22 (first published: 2021-10-12)
516 reads
In this article, I have shown the importance of performing three different validation tests against your Availability Group Endpoints. Each test also demonstrates what can be run in the...
2021-10-12
14 reads
In this article, I have shown the importance of performing three different validation tests against your Availability Group Endpoints. Each test also demonstrates what can be run in the...
2021-12-01 (first published: 2021-10-12)
385 reads
In this article, I have shown the importance of performing three different validation tests against your Availability Group Endpoints. Each test also demonstrates what can be run in the...
2021-10-12
8 reads
By Steve Jones
This is my last week of the year working (I guess I come back...
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
I wrote a PowerQuery that parses a table from a PDF, and I want...
Comments posted to this topic are about the item Attaching an SQL Server database...
Comments posted to this topic are about the item Superseded Indexes
Which of these indexes is superseded by another?
See possible answers