This is just a short, sweet primer that details exactly how you can deal with Development and Production configuration files
Category: Database
Cannot Restore Database from SQL Server Backup
This is one of those, very short, very focused blogs that actually first got me into blogging. It was a
Generating Large XML Data Files
Just recently I needed some large example XML data files to prepare for some blog content. Now, I thought it
SAP Data Services – Importing Image Data
Quite recently I was working on an SAP Data Services project which involved importing a great deal of data
ETL: How to consume result sets in DTS
So… about a month ago I was involved in a very complex DTS package. Amongst other things it involved looping through result sets of data, assigning the
Man of Distinct(ion)
Its not often that I learn something new about the fundamentals of SQL. Sure they add to the syntax all
Grouping multiline SQL data using XML
A friend of mine recently asked for help with a bit of SQL he was working on. True, he was
Improve Readability using ROW_NUMBER()
What did I ever do without the TSQL Row_Number() functionality. I do remember way back in days of yore (when
How to keep your SSIS package ‘DRY’
So, you all know the deal… When it comes to coding there is one rule that all half decent programmers
Where have you been all my life?
Every once in a while a technology comes along that once you have become accustomed to it you wonder how