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
87 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
13 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
753 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
780 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)
337 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)
358 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)
579 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
21 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)
394 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
32 reads
By Brian Kelley
In my YouTube subscriptions feed, a new video for the Azure Cloud Chronicles with...
By Steve Jones
This month we have a great T-SQL Tuesday, hosted by John Sterrett. He has...
By Rohit Garg
PostgreSQL, often referred to as Postgres, is a powerful, open-source object-relational database system that...
Comments posted to this topic are about the item How a Legacy Logic Choked...
I have an Access database with a SQL backend with tables, views, SP's. I...
Good morning, Once again, I find myself Sr. DBA for a company. As I...
The film independence day was released in 1996. Which of these queries returns that year is run today?
See possible answers