This article shows how to audit the logon events for SQL Server 2012 and beyond through the use of XEvents.
Audit Logons with Extended Events
Month: April 2020
Decoded Statistics Names and More
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.