Selected as a PernixPro

Today I’d like to announce that I have been selected as a PernixPro for 2015! It’s a program similar to...

Exam Prep 70-463: Executing packages in SSIS 2012

This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing...

0 to Speaker

Recently the last day to submit a session for the 2015 Pass Summit rolled around. I mention this because I...

Fix Inconsistent Line Terminators in SSIS

There is a flat file processing issue I’ve run into a number of times over the years, and it’s come...

Speaking at SQLSaturday 376 Budapest

On April 18 2015 I will be speaking at SQLSaturday #376 in Budapest!

I will be speaking about one of my...

New SQL Server Blog Author Challenge

My good friend Ed Leighton-Dick has created a great new challenge, adapted from a challenge issued by Seth Godin back...

Announcing the SQL New Blogger Challenge!

TL;DR – In April, I’m challenging myself to write (and publish!) here regularly, and I’m extending an open challenge to other new...

Announcing: SQL Saturday Baton Rouge 2015

SQL Saturday Baton Rouge 2015 is coming up on August 2 at LSU, register today!

Email or instant message your friends, post...

Parsing XML Child Nodes and Converting to DateTime with PowerShell

As part of my organiser role for SQLSaturday Exeter (Training Day Information here and Saturday Information here) I needed to...

Outlier Detection with SQL Server, part 4: Peirce’s Criterion

By Steve Bolton
…………In the last couple of installments of this amateur series of self-tutorials on outlier identification with SQL Server,...