When I’m interviewing a SQL Server DBA, I have three questions that I always ask. My favourite interview question is this: “What is the difference between a clustered and a non-clustered index?” My second favourite… Interview Questions for a SQL Server DBA
I’ve been toying with the idea of automating a set of diagnostic scripts that I run on customer sites, when doing my checkup. It mirrors the automation that a lot of consulting shops do, but… Automation is the new Black
In a recent episode of a Netflix show called Grace & Frankie, a vitriolic and profanity-ridden email with very damaging statements was accidentally sent to a mailing list. Fortunately for the characters involved, Siri auto-corrected… Career Limiting Moves – Reply All
I worked for a vendor implementation partner in the early part of my career, and oftentimes that meant having to set up a training lab, from unpacking rented PCs and plugging them in to getting… Career Limiting Moves – Assigning Blame
IT departments get a lot of flak because members are accused of saying no to what staff think are perfectly reasonable requests. In this second post of my series about career limiting moves, I’m going… Career Limiting Moves – Saying No
In this new series, I will share some things that took place early in my career that could have resulted in my looking for new workâbut didn’t! This post is also evidence that I haven’t… Career Limiting Moves – Dropping a Table
Working from home, consulting with companies all over the world, has changed how I interact with customers. The last time I was physically on site was seven months ago. We deal almost exclusively with each… Professionalism doesn’t mean a collared shirt and tie
I worked on four films in 2015, three shorts and one feature-length movie, all shot in Calgary where I live. That has resulted in seven IMDb credits for me, someone who earns a living as… Filmmaking as a Metaphor for the DBA
This is the first post in a series of four, where Ed Leighton-Dick, via Brent Ozar, is proposing that we SQL Server folks participate in the #SQLNewBlogger Challenge. I write a fair number of words… The Intersection of Art and Science
On SuperUser.com, a question came up about how to do a proper Linux backup, including the applications installed, and associated configurations. In light of a previous post I wrote about backups and run books, I… Where Do I Start With A Run Book?