Category: SQL

As you might have expected, since I chose Rube Goldberg Machines as the topic for this month’s T-SQL Tuesday, I have my own story to share. It was

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

That’s so crazy, it just might work How many times have you implemented solutions that somehow manage to fit a square peg into a round hole? It’s the

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