posts - 10, comments - 49, trackbacks - 0

February 2008 Blog Posts

Row Numbers in a DataFlow

You can expect: This is a low intensity post (you should be able to do this in your sleep). I Expect (that you have the following experience): Basic SSIS usage Basic VB.Net usage  Row Numbers in a DataFlow. I try to post often in the Forums here at SQLTeam.com for a few reasons.  First, I get to help people in an interactive way which is very rewarding to me.  Second, I get to learn from others who post answers.  I appreciate the forums very much and the few tricks I...

posted @ Wednesday, February 13, 2008 10:31 AM | Feedback (11) | Filed Under [ SSIS Madness ]

SSIS Performance Framework Part 2

You can expect: This is a medium intensity post (you should not get a migraine, but I make no promises). I Expect (that you have the following experience): Excel experience Complex SQL queries  Performance Reporting for SSIS Packages. Part 1 helped us set up the logging for SSIS so that we could retrieve the data we need to make the pretty charts that help us in tuning our packages.  This information is VITAL for engaging in REAL performance tuning.  You need PROOF and not anecdotes about how X is faster...

posted @ Monday, February 11, 2008 4:24 PM | Feedback (4) | Filed Under [ SSIS Madness ]

SSIS Performance Framework Part 1

You can expect: This is a medium intensity post (you should not get a migraine, but I make no promises) I Expect (that you have the following experience): The ability to POINT and CLICK on your OWN (I won't hold your hand like a little girl. Get over it.) at lease SOME SSIS experience SSIS Logging Stored Procedure writing  Performance Measuring in SSIS SSIS Logging lets you see what the heck is going on during run-time of your packages. You can see where failures occur and that is what...

posted @ Monday, February 11, 2008 10:34 AM | Feedback (3) | Filed Under [ SSIS Madness ]

Introduction Part 2

I have always viewed "social" movements on the Internet with somewhat of a mocking look. Think of a cross between Spock's eyebrow raise and the gleeful mocking smile and laugh that you crack when you see someone run a red light right into the waiting arms of the cop on the other side of the intersection. I lump many "fantastic things" into this category such as MySpace, Facebook, Blogs, etc. There is not enough to keep our quickly declining intelligences busy, so let us fill them with more useless things! "OMG you didn't say HI!!1! on my MySpace page! I...

posted @ Monday, February 11, 2008 9:56 AM | Feedback (0) |

Introduction Part 1

I started a Blog a few weeks ago to share my knowledge of SSIS with people.  I didn't think it would really get anyone's attention, I just felt like I needed to get information out there because so many people do horrible things with this technology!  In any case, through my blog (all 2 posts :P) and some interaction with a system I had built at a previous employer I drew the attention of Bill here at SQLTeam.com.  He has asked me to blog here, so I am moving the contents of my old Blog (it was Blogger and the...

posted @ Monday, February 11, 2008 9:56 AM | Feedback (3) |

Powered by:
Powered By Subtext Powered By ASP.NET