DROP LOGIN failed with Msg 15173 because the login had granted one or more permission(s) after an AlwaysOn cleanup. Here is how to find and revoke them.
SQL SERVER – Secure by Default – The Mantra
A SQLSaturday discussion led to this secure-by-default reminder: restrict application permissions, protect connections and inspect access before changing it.
SQL Server – 2016 – New Feature: Dynamic Data Masking
Would you want your credit card number shown in clear text? Dynamic Data Masking, new in SQL Server 2016, hides sensitive data right in the database.
SQL SERVER – Login failed for User ‘NT AUTHORITY\ANONYMOUS LOGON’ – ERRORLOG
A reader’s event log and ERRORLOG filled up with Login failed for user ‘NT AUTHORITY\ANONYMOUS LOGON’. Here is why it happens and how SPN errors are involved.
SQL SERVER – Basic Statistics Maintenance – Notes from the Field #083
Statistics help the SQL Server engine pick an optimal plan. This Notes from the Field episode covers the basics of statistics maintenance every DBA should know.
SQL SERVER – Adding Reference Data to Master Data Services – Notes from the Field #081
Reeves Smith shows how to add reference data to Master Data Services with the MDS add-in for Excel, so the business can manage it themselves.
A Custom db_executor Role for Stored Procedure Access
The app gets a permission error while it works for you as a sysadmin. Here is how a db_executor role fixes it without opening everything.