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 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 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 25 - Performance Counters

Today’s script is based on performance counters and in particular the sys.dm_performance_counters DMV.  There are many ways in which to...