Attaching MDF and LDF files after a disaster failed with Msg 2571: user guest does not have permission to run DBCC checkprimaryfile. Here is the fix.
SQL SERVER – Create Catalog Error 911: Database ‘SSISDB’ Does Not Exist. Make Sure That he name is entered correctly
Doing create catalog in SSMS failed with Error 911: database SSISDB does not exist. Here is how SQL Server Profiler showed me the real cause.
SQL SERVER – Authentication in SQL Server (Windows and Mixed Mode) – GDPR Series
Authentication in SQL Server identifies the caller through supported identity choices. My GDPR series considered those choices alongside access controls.
SQL SERVER – Historical SSMS Vulnerability Assessment and Current Availability
SQL Vulnerability Assessment was available in older SSMS releases. My walkthrough used SSMS 17.4 with SQL Server 2012 or later.
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
I List Users with System Admin membership before agreeing on the permissions for a health check. This query inspects visible principals.