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

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

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