SQL Server SELECT

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

Monday, March 28, 2011

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...
Tuesday, October 12, 2010

RS.exe and rss Scripts for Automation of SSRS 2008 Administrative Tasks

›
Download .rss script Most people that work with SSRS (2005, 2008, 20080 R2) are aware of two ways to deploy Reporting Services catalog ite...
21 comments:
‹
›
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.