Blueprint for consulting riches

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

Dynamic Multi-Threaded SSIS using C#

Here is a snippet of code that will assist in the dynamic ‘spin-up’ of duplicate SSIS packages.  To put it...

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

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

Lost in Translation – Deprecated System Tables – sysdatabases

This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...

Moving xml child elements to its parent using XQuery

I haven’t been able to do much XQuery development recently which is a shame as I love developing with the...

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

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

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