Time Zones

Why don’t we have a function like the one in this article to convert from time zone to time zone?...

Book: Expert Performance Indexing for SQL Server 2012

After about a year of work and a month of waiting, the book I wrote with Ted Krueger (Blog | @Onpnt)...

SSIS 2012 Change Data Capture (CDC) Control Task

Change data capture was introduced in SQL Server 2008 and has been pretty popular ever since. The basic concept behind...

SQLSaturday #164, Cleveland

Date: August 18, 2012

Session 1
Title: So I started this blog…now what?
Abstract:
Ever thought about trying your hand at blogging? Or maybe...

SQLSaturday #122, Louisville

Date: July 21, 2012
Session: So I started this blog…now what?
Abstract:
Ever thought about trying your hand at blogging? Or maybe you’ve...

SQL Internals Reading Data Records Part 6: Variable Length Data

Welcome back Dear Reader to Part 6 on our series of how to read a Data Record.    In Part 1...

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