Query Table Metadata
There will inevitably come a day when you want to take a look at the metadata of the tables inside a database. This can be accomplished one of many ways, the quickest and easiest is to expand the columns node...
Most recent posts
SSIS Configurations: When and How
Configurations in SSIS are a lovely tool that when implemented correctly can greatly reduce package maintenance. It is very possible to over configure a package, so be sure that you only do what you need to in order to make...
SSIS Webinar Recording Is Up
I want to say a huge thank you to everyone who attended the webinar from Pragmatic Works (website) that I did on Tuesday. If you missed it the topic was Dynamic SSIS: Configurations, Expressions and Variables. I got a lot...
Free Dynamic SSIS Webinar Today
If you were able to make it out to SQL Saturday in Pensacola this past weekend I want to say a big thank you! We had a great time at a very successful event. I was able to help out...
SQL Saturday Pensacola
I know it has been almost a month since I posted last and this is not really a “real” post, but I assure you that new content is on the way. I have a couple things in the works that...
SQL Saturday #74 Session Recap
Hopefully if you came to my session this year at SQL Saturday in Jacksonville, FL you came away with some small piece of knowledge you didn’t have when you walked into the room. If nothing else you now know that...
Search Stored Procedure Text
There will come a day, if it has not already come and gone, when you will want to search through your stored procedures because you don’t remember which one did what you want to do. Did that make sense? Because...
A Caution About Checkpoints
Checkpoints in SSIS are a great tool and they definitely have their place. The downside to them is that they are not so good when you start talking about parallel processes or containers. What follows is a little bit of...
Missing Perfmon Counters
Perfmon is a great tool to get a closer look at what is going on in your environment as queries and packages run. There are a ton of counters ranging from OS to third party. In our case we are...