Quick Script: Finding Database Owners & Security Admins
A quick script to identify where you might have permission issues at the database level.
T-SQL Tuesday #65 – Failing Over with PowerShell
A look at how I’m using Powershell to hep control who is the owner of a clustered resource for serviceability.
Detaching a Database – File Security Gotcha
A look at what happens to file permissions when you detach a database with an active directory or machine user account.
Procedure Creation – Correct Syntax, Wrong Database
A brief look at why a procedure is created even with a reference to an object that isn’t valid.
Database Restores – Zeroing Out Log Files
A look at what happens the log file when the database is restored.
Quick Script: Finding Columns
A T-SQL script that I wrote to hunt for certain columns based off their names.
SQL Saturday 381 – Richmond, VA
A brief look at the presentation I’ll be giving at SQL Saturday 381 in Richmond, VA.