SQL Server SELECT

SELECT [tips tricks and commentary] FROM [my experiences] WHERE subject IN ('database', 'data warehouse', 'business intelligence')

Monday, March 28, 2011

A One-Package, Generic SSIS Staging Process

›
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...
5 comments:

SSIS Interview Questions

›
Below are some questions I recently asked while interviewing for an SSIS developer. Thought they might be helpful to others looking to hire....
1 comment:
Wednesday, March 16, 2011

SSIS Error On OLE DB Command - Operand type clash: int is incompatible with date

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

VS Studio 2010 Table Designer

›
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...
Monday, January 31, 2011

Visual Studio 2010 Database Projects

›
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...
Wednesday, December 29, 2010

SSIS Foreach Loop Container: Continue on Error

›
I recently had a project that involved processing FTP log files. I chose to use SSIS for the task as it is great for this type of flat file ...
31 comments:
Thursday, November 4, 2010

SQL Azure - Very Cool - Very Big Deal Breakers

›
THIS POST REQUIRES AN UPDATE WITH CHANGES MADE TO SQL AZURE For anyone that doesn't know what SQL Azure is, it's essentially SQL S...
‹
›
Home
View web version

About Me

My photo
d.elish
Everywhere & Nowhere in My Airstream Trailer
Delivering bulletproof, data-centric software solutions to organizations such as Disney, PwC, Cymer, Boston Scientific, the Pittsburgh Steelers, Blue Cross Blue Shield of Massachusetts, Irving Oil, Bain Capital, LoJack, PETCO, and State Street Bank for over 14 years. Driven by a passion for problem solving, technology, and profitability.
View my complete profile
Powered by Blogger.