Activity Monitor in SQL Server 2012: an Improved Embedded Optimisation Gizmo for the Thrifty DBA

Waaaay back in December ‘08, after having spoken briefly at SQL teach here in Montreal thanks to MVP Paul Nielsen...

Avoid Database Restore Issues (Errors 3219 or 3514) by a Simple Script Edit - the DB Restore Work-around

Starting with the 1000 foot view: During the process of applying changes to a production database - let's call it Change...

Rules of Thumb in Physical Database Design
I am starting my first post in my blog of tuning the physical database...

Re-blog – March 9 – March 15

Welcome to the Friday Re-Blog summary post.  The aim of these posts is to bring some old posts that newer readers may...

SQL Server 2012: New Certification Info

As a follow-up to my posts SQL Server “Denali”: New Certifications and SQL Server 2012: New Certifications, there are now final details coming...

SQL Skills IE3 #sqlskills

I attended my first SQL Skills event in December 2011.  Due to a big project at work I was able...

Gardens and Scarecrows

A few weeks ago I started clearing space for a small garden. Tedious work due to the area of the...

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

I’m Not a Bozo!

Something fun for Friday, this was a gift from the client I work with to lighten things up and do...

SQL Roundup – 03/16-2012

Howdy! I was flying last week, and for the first time i sat facing a flight attendant. You don’t actually...