SQL Rally 2012 Vote For Me!

Hello Dear Reader!  Last year I tossed my hat in the ring on the world of Presenting.  This was a...

RYO Maintenance Plan – Database Backups, Part 3

4 out of 5 DBAs agree
I’ve covered creating my backup directories and the actual backup of the database(s). The last...

Meme Monday: Deadlines

Tom LaRock (blog|twitter) has assigned an interesting topic for Meme Monday this month, working with deadlines.
Some people hate deadlines. Some...

Meme Monday - Working with Deadlines.....

 Hi, all!  It's been a while, since I posted a blog entry, and is directly related to today's Meme Monday...

A Script A Day - Day 6 - Drop and Create Database Snapshots

Today's Script will drop all database snapshots and create a database snapshot for all online read writeable user databases. I...

List failed SQL server Jobs with Powershell

This post explains how to list failed SQL Server Jobs , on multiple SQL Server Instances and output the results to...

A Script A Day - Day 5 - Database Owner Permissions

Today's script will list all principals with membership in the db_owner fixed database role.

/*      -----------------------------------------------------------------       Database Owner Permissions      -----------------------------------------------------------------            For more SQL resources, check...

Thread Synchronization/Locking In .Net

When you are creating multiple threads that need to access a shared resource then you need to implement some form...

SQL Express and the Curse of the Perfmon Counters

On a dark and spooky night in the land of SQL Server make-believe, a young warrior was asked to slay...

A Script A Day - Day 4 - Estimated Time Left

Today's script allows you to keep track of how long left a statement has before it completes.  I find this useful...