Purging MSDB Backup and Restore History Tables

Today while checking our database growth reports, I noticed that size of msdb database on most of our SQL Server...

Identify and Alert for Long-Running Agent Jobs

Being a DBA is like being a train conductor. One of the biggest responsibilities is making sure all jobs are...

Blueprint for consulting riches

As a business intelligence architect consultant, I have met many people out there who are as good or better than...

Back Across the Pond

This coming weekend is SQL in the City – London 2012. Friday, July 13, and Saturday, July 14, I’ll be at...

SQL Audit 101 – Creating a basic audit

SQL Audit was introduced in SQL 2008, and for the first time auditing was treated as a “first-class” object in...

First SQL Server UG Meeting in Harrisburg, PA

If you work with SQL Server and live in the Harrisburg area I have some great news for you. The...

Group Think (or Groupthink)

I’ve thought about writing on this topic a couple times and was reminded of it again when I read a...

Speaker Selection for SQLSaturday Orlando-Group #5

Three more added to the stellar slate of speakers for SQLSaturday Orlando, we look forward to seeing you soon!

Ira Whiteside

Devin...

Parallel Data Warehouse (PDW) Lesson 1: – Basic Architecture Overview

I’ll begin my coverage of Microsoft’s Parallel Data Warehouse (PDW) architecture / appliance with a brief overview of the Massively Parallel...

Writing About SQL Server

I.              Introduction I recently submitted my entry for a writing competition as part of my continuing education.  While I was...