James Nix Blog

Fast T-SQL Row Number Generator

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): T-SQL Stored Proc experience Windowed Function experience Basic Join understanding Row Number Generation There are a number of ways to generate row numbers in T-SQL. Read more →

SSIS Performance Framework Part 3

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): Simple SSIS Dataflow work That you have read and understood/implemented parts 1 and 2 Performance Tuning for SSIS Packages. Read more →

Error Handling Template

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): Error Logging experience UDF (User Defined Function) creation experience Creating a template Package that handles errors. Read more →

I'm not dead YET!!

I apologize for the long pause in posting. I have been extremely busy with my Masters program. I took my finals on Monday for this semester, so I finally have some free time! Read more →

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. Read more →

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. Read more →

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. Read more →

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. Read more →

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! Read more →