1 DBA's Professional Blog
T-SQL Scripts
Every Database has a DBO or database owner set. Sometimes the owner is invalid, while most of the time the DBO is perfectly normal. It is easy to ignore whether a valid DBO is set or not. And then something breaks and you have to validate it. This article addresses the easy fix to validate the DBO.
Having a Database Owner is not something that most people think about until something breaks. Usually, people will just kind of ignore it because it is just so innocuous and uncommon for the owner to not be “present”.
Excessive memory grants are extremely problematic in SQL Server. These excessive grants do not just happen out of the blue. Memory grants are directly linked to the queries.
Queries will fail. That is as inevitable as death and taxes. This article demonstrates how to find some truly horrible queries.
This article demonstrates a more comprehensive method to audit changes to statistics. This method involves the use of Extended Events.
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.
XEvents is here to stay and is a powerful tool for ALL of your SQL implementations – whether they be Azure SQL or the traditional on-premises SQL Server.
XEvents is a power tool in SQL Server. While it may still be rather immature in the world of SSAS, it still has a great deal of benefit and power to offer.
Auto-generated statistics names can seem like they are entirely random, but there is a method to the madness. With a little effort and a bit of TSQL trickery, we can decode those names and reveal what the names really mean.
The default collation for SQL Server is a pretty bad idea. Sure, it works but so does SQL Server 7. When you have the opportunity to update to more current technologies, it is a good idea. Sometimes though, that upgrade can come with some pain. This article shows how to alleviate one such pain point by fixing problems related to collation conflicts and XE.