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 accomplish that goal. Many people cringe when they hear hard coded, and this post should address their concerns. As a reminder, here is a representative example of […]
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 SSIS tends be more complicated than in other programming paradigms. But, that doesn’t mean that we should stop trying. Here is a representative example of copy/paste code […]
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 use T-SQL also have a programming background. So, if you ask them for a string method that can be used to find the last instance of a […]
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 ago and was excited, because I immediately knew that I wanted to write about Key Lookups and explain the rationale for my choice. The Key Lookup is My Interviewing […]
Google has become a verb by capturing roughly two-thirds of all search traffic. Understanding Google+ is just as important to the person ‘Googling’, as the bloggers that want to be found by these searches. I have just recently started digging into Google+ to learn the ins and outs. Use Google+ To Find Information Faster Google […]
I’ve been working on some new ideas for presentations, because the Polyglot Persistence session I’ve been doing recently highlights one of my weaknesses (lecture style sessions). My favorite idea so far is a SQLSaturday presentation about SQLSaturday. It would be very informative and fun for the audience, which is much more my style. Here is […]
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 each SSIS package to make sure that it’s unique across multiple copies of the package. This is a case where a little scripting knowledge can save you […]
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 overall architecture. I was originally going to use this space to read your mind and go through a list of some of the top reservations that you […]
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 (played by Owen Wilson) is very anxious and excited at the same time and says this as he is flying to stop the asteroid from hitting earth. […]
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 strangest thing too: you have a certain sense of pride that you were able to get SQL to do that thing that it really can’t do. At […]
Subscribe Via E-Mail
- T-SQL Tuesday Topics | Voice of the DBA says: […] T-SQL Tuesday #46 – Rube Goldberg Machine (wrap up) […]...
- Code Reuse with Foreach Loop Containers - Part II - DataOgre says: […] last week’s episode, we saw how Foreach Loop Containers can...
- Dan H says: Here's my link, looks like I'm a little late, but only...
- T-SQL Tuesday #46–The Rube Goldberg Machine | Voice of the DBA says: […] again. This is the monthly blog party where we all...
- sqlchow says: I am in!! >> http://sqlchow.wordpress.com/2013/09/11/t-sql-tuesday-46-you-did-what-creative-hacks-to-common-problems/