Traditionally I have used SSIS for OLTP data movements, however lately I’ve been loading a Data Warehouse which has slightly different requirements. I just wanted to drop a quick note to highlight the great resources that already exist out there (and thanks to Dan English for pointing me to most of them). These have been [...]
Don’t you just love alliteration? I’ve now dealt with few migrations from SQL 2000 to SQL 2005; SQL 2005 to SQL 2008 and SQL 2000 to SQL 2008. However there still seems to be a lot of confusion around what is supported on which version and whether something is deprecated, depreciated or discontinued. So first [...]