Favorite BI Features in SQL Server 2008
June 11, 2007
If you haven’t heard yet, CTP 3, which is a public beta of SQL Server 2008 has now been released and can be downloaded at the Connect website. After a bit...
Read More
Automating SQL Express Backups
August 13, 2006
SQL Express allows you to distribute a free edition of SQL Server with your applications. There are an enormous amount of 3rd party applications that use it and MSDE (it's...
Read More
Looping through a ADO Resultset in SSIS
July 2, 2006
Sometimes there is a special case where you’d like to use the results of a query in SSIS and loop through it record by record to perform a series of...
Read More
SSIS 64 Bit Gotchas
May 12, 2006
I'm at a client engagement this week, which has been extremely fun in learning the more subtle issues isses with 64 bit with SSIS. The first gotcha I alread knew but...
Read More
Quickly Retrieving the Row Count for All Tables
March 17, 2006
My typical query I run for retrieving a list of tables and how many records in each table there are is to use the sp_msforeach stored procedure. The sproc loops...
Read More
Setting Variables in the Script Task in SSIS
February 8, 2006
One of the key reasons that you use the script task is to change the value of a variable at runtime. There is a lot of real-world scenarios that you...
Read More