High Availability Lingo

You have got to love the way the SQL Server team change the lingo in all of their high availability...

Cost Savings and Backup Compression

Let me set the scene, one of our internal IT SQL Servers which stores a whole host of performance metrics...

Database Tables

Today I was asked for "a list of all tables in all databases" on a particular instance of SQL Server. ...

Rebuilding System Databases

Today’s post is something I thought I would share as there is an awful lot of incorrect commands I have...

Why I don’t like maintenance plans

If you create a maintenance plan (SQL 9.0.3042) to backup databases and select All databases as below;

Then at some point...

How Resilient Is Your Recovery Plan?

In this modern age of technology DBA’s face an ever increasing demand from businesses; our databases must perform, be secure,...

A Script A Day Finished!

Well that's it, my "A Script A Day" series is finished.  I hope you found the scripts I provided useful, I've used...

A Script A Day - Day 29 - The Importance of Being Idle

Today’s script is also one I used in my migration on Wednesday.  It again uses string manipulation to generate a...

A Script A Day - Day 28 - String Manipulation

Today’s script is one that I used earlier this week.  On Thursday I migrated a server from SQL Server 200...

A Script A Day - Day 27 - Missing Database Backups

Today’s script is one I have used many times in the past to check for missing backups.  The script will...