In last week’s episode, we saw how Foreach Loop Containers can be implemented to reuse code. However, that example hard coded values within the Foreach Loop Container to
Given that the options available for code reuse in SSIS are limited, it’s important to understand containers like the Foreach Loop Container. It’s frustrating that reusing code in
T-SQL is not ideal for doing string manipulation, but sometimes you just need to get something done quickly with the tool you’ve got. A lot of people that
Cheers to Rob Farley ( blog | @rob_farley ) for hosting June’s T-SQL Tuesday #43, and for asking us to talk about plan operators. I read his host post a week
We often want to modify many SSIS packages at once. We may want to change the password on all packages within a folder, or regenerate the unique identifier on
Rules of Engagement was written to help shed light on the usefulness of NoSQL in your applications, and get you thinking about where it could fit into your
This is space! Course, we’re just in the beginning part of space, we-we haven’t even got to *outer* space yet! – Armageddon (1998) In the movie Armageddon, Oscar
Thank you to Sebastian Meine ( @sqlity ) for hosting December’s T-SQL Tuesday #37. He is writing a series about JOINs this month and asked for others in the community to participate with