Jorg Klein's Microsoft Business Intelligence Blog [Macaw]

Blog moved!

2009-12-13T21:02:00Z

For a number of reasons, I have moved my blog to http://sqlblog.com/blogs/jorg_klein/

Please change your bookmarks ;-)

RSS: http://sqlblog.com/blogs/jorg_klein/rss.aspx

Many thanks to Tony Rogerson and Simon Sabin for making this blog possible here at sqlblogcasts for the last two years!

SSIS - Let the Excel connection manager pick the right column data types from an Excel source

2009-11-18T20:45:00Z

This blog has been moved to: http://sqlblog.com/blogs/jorg_klein/

This blog post has been moved to: http://sqlblog.com/blogs/jorg_klein/archive/2009/11/18/ssis-let-the-excel-connection-manager-pick-the-right-column-data-types-from-an-excel-source.aspx

SSIS - Connect to Oracle on a 64-bit machine

2009-10-15T12:49:00Z

This blog has been moved to: http://sqlblog.com/blogs/jorg_klein/

This blog post has been moved to: http://sqlblog.com/blogs/jorg_klein/archive/2009/10/15/ssis-connect-to-oracle-on-a-64-bit-machine.aspx

SSIS – Unpack a ZIP file with the Script Task

2009-08-27T12:59:00Z

This blog has been moved to: http://sqlblog.com/blogs/jorg_klein/

This blog post has been moved to: http://sqlblog.com/blogs/jorg_klein/archive/2009/08/27/ssis-unpack-a-zip-file-with-the-script-task.aspx

SSAS - Clear SSAS cache with an SSIS package

2009-02-13T15:35:00Z

This blog has been moved to: http://sqlblog.com/blogs/jorg_klein/

This blog post has been moved to: http://sqlblog.com/blogs/jorg_klein/archive/2009/03/13/ssas-clear-ssas-cache-with-an-ssis-package.aspx

SSAS - Speed up dimensions using a NULL default cube measure

2009-02-06T12:07:00Z

This blog has been moved to: http://sqlblog.com/blogs/jorg_klein/

This blog post has been moved to: http://sqlblog.com/blogs/jorg_klein/archive/2009/02/06/ssas-speed-up-dimensions-using-a-null-default-cube-measure.aspx

Start / Stop SQL Server, SSIS, SSAS, SSRS and SQL Server Agent at once with a batch file

2009-01-06T19:02:00Z

This blog has been moved to: http://sqlblog.com/blogs/jorg_klein/

This blog post has been moved to: http://sqlblog.com/blogs/jorg_klein/archive/2009/01/06/start-stop-sql-server-ssis-ssas-ssrs-and-sql-server-agent-at-once-with-a-batch-file.aspx

SSIS - Decrease your fact table loading time up to 40%

2008-10-22T14:57:00Z

This blog has been moved to: http://sqlblog.com/blogs/jorg_klein/

This blog post has been moved to: http://sqlblog.com/blogs/jorg_klein/archive/2008/10/22/ssis-decrease-your-fact-table-loading-time-up-to-40.aspx

MCTS - I passed the 70-556 “Microsoft Office PerformancePoint Server 2007” exam!

2008-09-23T11:56:00Z

This blog has been moved to: http://sqlblog.com/blogs/jorg_klein/

This blog post has been moved to: http://sqlblog.com/blogs/jorg_klein/archive/2008/09/23/mcts-i-passed-the-70-556-microsoft-office-performancepoint-server-2007-exam.aspx

SSIS - Convert various String date formats to DateTime with the Script Task

2008-06-12T12:01:00Z

This blog has been moved to: http://sqlblog.com/blogs/jorg_klein/

This blog post has been moved to: http://sqlblog.com/blogs/jorg_klein/archive/2008/06/12/ssis-convert-various-string-date-formats-to-datetime-with-the-script-task.aspx

MCITP - I passed the 70-446 “PRO: Designing a Business Intelligence Infrastructure by Using Microsoft SQL Server 2005” exam!

2008-03-28T13:25:00Z

This blog has been moved to: http://sqlblog.com/blogs/jorg_klein/

This blog post has been moved to: http://sqlblog.com/blogs/jorg_klein/archive/2008/04/28/mcitp-i-passed-the-70-446-pro-designing-a-business-intelligence-infrastructure-by-using-microsoft-sql-server-2005-exam.aspx

SSAS – MOLAP, ROLAP and HOLAP storage types

2008-03-27T14:33:00Z

This blog has been moved to: http://sqlblog.com/blogs/jorg_klein/

This blog post has been moved to: http://sqlblog.com/blogs/jorg_klein/archive/2008/03/27/ssas-molap-rolap-and-holap-storage-types.aspx

SSIS – Non-blocking, Semi-blocking and Fully-blocking components

2008-02-27T15:59:00Z

This blog has been moved to: http://sqlblog.com/blogs/jorg_klein/

This blog post has been moved to: http://sqlblog.com/blogs/jorg_klein/archive/2008/02/12/ssis-lookup-transformation-is-case-sensitive.aspx

SSIS – Lookup Transformation is case sensitive

2008-02-12T15:34:00Z

This blog has been moved to: http://sqlblog.com/blogs/jorg_klein/

This blog post has been moved to: http://sqlblog.com/blogs/jorg_klein/archive/2009/04/14/ssis-lookup-is-case-sensitive.aspx

SSRS – Static column headers in a Matrix

2007-12-12T15:36:00Z

This blog has been moved to: http://sqlblog.com/blogs/jorg_klein/

This blog post has been moved to: http://sqlblog.com/blogs/jorg_klein/archive/2008/07/16/ssrs-static-column-headers-in-a-matrix.aspx