Part of my GDPR series: Authentication in SQL Server, Windows and Mixed Mode, and how it helps with GDPR Article 25, data protection by design and default.
SQL SERVER – SQL Vulnerability Assessment – Security Analysis
SQL Vulnerability Assessment, free in SSMS 17.4 and later, scans SQL Server 2012 and up for security issues and also suggests fixes. Here is how it works.
SQL SERVER – Account Added Automatically in SQL Server Used by SharePoint
A departed user’s account kept being added automatically to SharePoint database roles. How to catch who adds it, and from where, on SQL Server 2025.
SQL SERVER – List Users with System Admin (sysadmin) Rights – Part 2
After my post on listing users with System Admin (sysadmin) rights, Chris Mangrum shared a better script that also covers CONTROL SERVER. Here it is.
SQL SERVER – List Users with System Admin (sysadmin) Rights
My health check needs a DBA with sysadmin rights. Here is a simple script to list users with system admin rights on your SQL Server.
SQL SERVER – Login Failed. The Login is From an Untrusted Domain and Cannot be Used with Windows Authentication – SPN Issue
Login failed, untrusted domain, error 18452, and a cluster that would not fail over. The cause was an SPN. How to read the SPN messages.
SQL SERVER – FIX: Msg 15150 – Cannot Alter The User ‘dbo’.
Deploying SharePoint, a client tried to change the dbo mapping and got Msg 15150: Cannot alter the user ‘dbo’. Here is why it happens and how to fix it.