The shaky bug in SSIS

You may or may not have noticed it after installing SQL Server 2012: the designer interface in Visual Studio 2010/2012...

Use the WordPress Revision Counter to Keep Shipping Posts

I haven’t been at this blogging thing an extremely long time, and I certainly haven’t been as consistent as I’ve...

Using New-TimeSpan to convert friendly time

The question was this:

This is just a quick/fast snippet in response to that question, but I can think of a...

Who is cjsommer?

I’ve been a problem solver as far back as I can remember, always looking for a new challenge. I love...

0 to Speaker

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

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

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

Getting out of the ground with TSQL Smells.

 
At SQLBits I had a number of conversations with a number of people over TSQL Smells, my open source project...

How to resolve Space issue in SQL server 2005 TIP #93

Hello friends,
Many times we face space issues with our database. To resolve this problem SQL Server 2005 provided one more...

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