Monday, October 31, 2011

SQL Server Default Backup Location

›
SQL Server makes it easy to set a server's default data and log locations. In SQL Server Management Studio, simply right click on the ...
Friday, October 21, 2011

The Future of Visual Studio Database Projects

›
It is with great sadness that I relay the decision by Microsoft to do away with the Visual Studio Database Project type that I love so much....
Wednesday, October 12, 2011

SSIS Configuration File (.dtsconfig) Behavior (relative path issue)

›
Let me start by saying that I prefer SQL Server configurations over all other configuration types in SSIS for the majority of configurable v...
4 comments:
Monday, September 12, 2011

OLE DB Destination or SQL Server Destination

›
SSIS offers a number of Data Flow destination components. When working with SQL Server databases as a destination there are two obvious choi...
Wednesday, June 22, 2011

SQL Bulk Copy

›
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...
Tuesday, June 14, 2011

Data Warehouse QA Technical Screen Questions

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