Is EXISTS(SELECT 1 ...) better than EXISTS(SELECT * ...)? Who would know better than SQL Server?
Specific String Pattern Magically Hidden From Step Output in SQL Agent History. Who Knew?
Installing SQL Server 2019 CTP 2.5 fails with almost no useful info. Searching on code or message finds nothing. This post fixes that 😎
Come see how to prevent SQL Server from starting, and in an easy-to-fix-yet-impossible-to-find way! 😈
Server Audits allow filtering on certain fields. Two fields claim to be strings, yet don't accept strings for filters. Here's how I figured out filtering on action_id (i.e. the event) :-)
What is GDPR, everyone's (current) favorite acronym? It stands for "General Data Protection Regulation" and is an act / law / set of laws that governs the collection, retention, and use of personal information for EU (European Union) and UK citizens. It's the topic "flavor of the month" due to it going into effect on… Continue reading Will GDPR cause a “Database Run”?
Server Audits allow filtering on certain fields. Two fields claim to be strings, yet don't accept strings for filters. Here's how I figured out filtering on class_type (i.e. object type) :-)
Some object definitions will be wrong after using sp_rename. But there's another way to have an out-of-sync definition that most are unaware of.