A Script A Day - Day 7 - Memory Queries

Today's script is a collection of a few memory queries I've collected from various sources over the years.  These queries are by no...

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

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

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

A Script A Day - Day 3 - Live Change Data Edit Template

Today's script is a template I use for the occasions when a data edit is required to be run against...

A Script A Day - Day 2 - Database Mail Troubleshooting

Today's script is a collection of simple queries I have saved for a time when I need to troubleshoot database...

A Script A Day - Day 1 - Database File To Volume Mapping

Today is the 1st February 2012 and as promised here is the first of script in my "A Script A Day"...

Database 101

I had an interesting phone call this morning from our professional services team.  They are carrying out what I can...

Venting Frustration

We as DBA’s face an ever growing list of things to do and services to support.  We work in high...

A Script a Day

In February I will be starting a series of Blog Posts I'm calling a "A Script a Day".  Each day...