Retrieving password policy settings for SQL login accounts

Today, I wrote the following query for our internal audit report for SAS70. This query provides all the necessary details...

Baton Rouge SQLSaturday #150 & Tech Day .Net 1 track

August 4th of this year will be the forth annual Baton Rouge SQL Saturday and Tech Day. LSU has offered...

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