On a recent project that I was working on we came across an issue where we needed to replicate several databases on a new server. Much of the ETL had places where tables were truncated and reloaded. Normally this is not an issue at all, simply TRUNCATE TABLE and away you go. This does however …
Monthly Archive: July 2010
Jul 16
CREATE SCHEMA Syntax Error
Recently while creating a script to migrate the new holding tables over to the stage and production machines I ran into a little issue. The holding table we are using in this case houses several different sets of data for our migration project. Tables that are used only for going from the old system to …
Books I’ve Worked On
The SharePoint 2010 Business Intelligence 24-hour Trainer will take you from beginner to intermediate level though simple, easy to follow lessons.
Loading tweets...