Some philosophical thoughts around how even an operational database administrator should also understand the development side of things.
SQL Saturday 392 – Atlanta, GA
A brief look at the session that I’ll be delivering in Atlanta at SQL Saturday #392.
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.