What Changed, When, and by Whom: Temporal Tables and CDC
The was about announcing change as it happens. This one is about the opposite direction in time: being able to answer, later, what a row used to look like, when it changed, and ideally who…
Obtaining machine names for failed logins
The SQL Server error log contains invaluable details about failed logins, but only if you enable login auditing. Once enabled, the error log will provide the details of logins that failed including the name of…