Monthly Archives: March 2009

32-Bit To 64-Bit Upgrade

By | March 13, 2009

I’ve been busy upgrading and moving a MSSQL server and all of the associated applications from a 32-bit Windows 2000 server to a 64-bit Windows 2003 server. The process has been a lot of trial and error. Below are some tips to use when moving from 32-bit to 64-bit. Try to find a 64-bit equivalent… Read More »

Agile and Cowboy Coding

By | March 12, 2009

All too often I meet people who claim they are agile developers. After a short discussion I realize they are not using any software development methodologies and are instead cowboy coding. Agile development is not a plan free environment. In fact, being an agile developer requires more developer discipline than even the dreaded waterfall. Agile… Read More »

1 TB Loaded in 30 Minutes!

By | March 9, 2009

This is a great new white paper out of Microsoft. In it they explain how to move a lot of data from flat files into MSSQL using SSIS. Some key take aways from the paper and my personal experiences loading data into MSSQL. If at all possible get your source systems to provide flat files… Read More »