Monthly Archives: April 2015

SQL Saturday 392 – Atlanta, GA

A brief look at the session that I’ll be delivering in Atlanta at SQL Saturday #392. Continue reading

Posted in Presenting, SQL Saturday | Tagged , | Leave a comment

Quick Script: Finding Database Owners & Security Admins

A quick script to identify where you might have permission issues at the database level. Continue reading

Posted in T-SQL | Tagged | Leave a comment

2015 Program Committee

Why I volunteered for the 2015 PASS Summit Program Committee. Continue reading

Posted in Community, Philosophical | Tagged , , | 2 Comments

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. Continue reading

Posted in Administration, TSQL Tuesday | Tagged , , | 4 Comments

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. Continue reading

Posted in Administration, Internals | Tagged , | 5 Comments

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. Continue reading

Posted in Administration, Internals, T-SQL | Tagged , | Leave a comment