SQL Server SELECT

In an earlier post I talked about  a generic SSIS package for staging data using SQL Bulk Copy . I have been using it extensively without fa...

I was recently asked to perform a technical phone screen of a data warehouse QA candidate. The project manager wanted to ensure that this pe...

Download script I recently worked on a project that was flat file and staging intensive. By intensive I mean we had essentially 1.5 ETL d...

Below are some questions I recently asked while interviewing for an SSIS developer. Thought they might be helpful to others looking to hire....

Here's a good one - Operand type clash: int is incompatible with date. It appears, although I have not fully confirmed, that SSIS does...

Embarrassingly enough this one eluded me for quite some time. I was surprised to stumble onto the fact that there is indeed table designer f...

I won't go into the details of how to create and use Visual Studio 2010 database projects here (since I am developing a thorough documen...