Importing binary files with SSIS

I have gotten a number of emails over the past few days asking about how I import binary files into...

Book Review: The Yankee Years

The Yankee Years by Joe Torre ($12 @ Amazon) was a gift, and I enjoyed it more than expected. When it...

The Truth about SQLPS and PowerShell V2

With the release of SQL Server 2008 R2 there have been claims that sqlps is really PowerShell V1 under the...

When did SQL Server start and how long is the downtime window?

 
This is an old topic, and there have been quite a few blogs (and following comments) that illustrate how to...

BI Conference Grocery Shopping Demo

Help enter demonstration data for the Microsoft BI Conference.

Go to the shopping
demo web form and enter some transactions.

No...

Challenge 19 – An Explanation of a Query

I have received a number of requests for an explanation of my winning query of TSQL Challenge 19. This involved...

SQLSaturday #49 Planning Update

Planning for SQLSaturday #49 – Orlando is on-going and going well especially since we have a good head start.  We have...

Adding Space to a Home Server

I got new drives for my Windows Home Server the other day and decided to add some space to the...

The SSIS Data Flow is Like... an Automotive Assembly Line

When I describe (or rather, attempt to describe) technical subjects to people that aren't familiar with them, I tend to...

Follow Up On My Keynote Survey

Here are the results of the survey, 75% in favor of a non-technical keynote, with a less than stellar sampling...