Monthly Archive: October 2013

Oct 27

Correcting Excel Data Types in the Import Wizard

020 - Data List 2

A common task that business intelligence professionals have to perform is to import data from Microsoft Excel into SQL Server.  This is usually a unnecessarily challenging project with many pitfalls.  One of the pitfalls is getting the SQL Import Export Wizard to correctly determine the data types. One pattern that you occasionally see in data …

Continue reading »

Oct 27

Experience at SQL Saturday Fargo

SQL Saturday is a free conference organized by PASS organizations around the country and the world.  Fargo, ND hosted their first SQL Saturday on April 27, 2013.  The day was full of learning, socializing and a surprise celebrity appearance. SQL Saturday was originally organized by PASS to give beginning presenters a venue to speak at.  …

Continue reading »