My Adventures with the SQL 2005 Security Cache

Introduction
For that past couple of months I have been chasing performance issues with one of the most high profile servers...

Why Do My SQL 2008 Compressed Backups Shrink?

Introduction
Recently a coworker was doing some research with SQL 2008 Backup Compression on a very large database. During the testing...

Why Do I Need All These Servers?

Introduction
I am frequently getting requests for a new server to do this or that. Running through the usual questions to...

Stored Procedure to Sequentially Run SQL Agent Jobs

Introduction
Here is another one of my utility scripts. Lately it seems like all I am blogging about is utility scripts,...

Stored Procedure to Get SQL Job Execution Status

Introduction
Ever need a programmatic way to figure out if a SQL Agent job is running? I did. After spending a...

Using sp_ExecuteSql to Run Dynamic SQL

Introduction
Lately it seems like I am being bombarded by Dynamic SQL and people who insist it is the only way...

Stored Procedures to Store and Get Database Users with All Permissions

Introduction

Traditionally when doing a restore, moving a database, etc. a DBA would simply go into Management Studio and use the...

Script Individual User Rights in a Database with PowerShell

Introduction
Tonight on Twitter the call went out on #SqlHelp looking for a way to script just database permissions for a...

A Busy/Accidental DBA’s Guide to Managing VLFs

Introduction
Properly managing VLFs can make or break the performance of your databases. There is a ton of information out there...

How to Shrink TempDB in SQL 2005

Introduction
From time to time you find yourself needing to shrink some space out of TempDB. Shrinking database files is never...