I've been asked from time to time about a safe youtube downloader in order to archive and make use of important content. After testing various java-based web tools and free applications...
Read More
Ever sent a message and received in return a reply similar to this: >>> DATA<<< 550 5.7.1 SPF unauthorized mail is prohibited. 554 5.0.0 Service unavailable Likely, you placed a call to your...
Read More
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
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
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
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
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
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