Skip to content

Jorg Klein's Blog

Azure Solutions Architect writing about Azure Data & Analytics and Power BI

  • Home
  • About
  • Contact
  • Jorg Klein IT

Tag: Design Pattern

2 February 2010 Architecture / Data Warehousing / Integration Services

SSIS – Package design pattern for loading a data warehouse – Part 2

Since my last blog post about a SSIS package design pattern I’ve received quite some positive reactions and feedback. Microsoft

Continue reading

2 January 2010 Architecture / Data Warehousing / Integration Services

SSIS – Package design pattern for loading a data warehouse

I recently had a chat with some BI developers about the design patterns they’re using in SSIS when building an

Continue reading

7 December 2009 Integration Services

SSIS – Blowing-out the grain of your fact table

Recently I had to create a fact table with a lower grain than the source database. My source database contained

Continue reading

2 October 2008 Integration Services

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

Replace the multiple “Lookup Error Output” Derived Columns and Union All’s with a single Derived Column and get a performance

Continue reading

Enter your email address to follow this blog and receive notifications of new posts by email.

Jorg Klein

Twitter

My Tweets

Search this blog

Categories

  • Analysis Services
  • Architecture
  • Azure Analysis Services
  • Azure Automation
  • Azure Blob Storage
  • Azure Data Factory
  • Azure Data Lake Analytics & Store
  • Azure Integration Services
  • Azure Key Vault
  • Azure Logic Apps
  • Azure SQL Database
  • Data Warehousing
  • Events
  • Integration Services
  • Microsoft Certification
  • Microsoft MVP
  • On-premises data gateway
  • Power BI
  • Replication Services
  • Reporting Services

Archives

  • November 2018
  • February 2018
  • January 2018
  • December 2017
  • November 2017
  • October 2017
  • September 2017
  • August 2017
  • July 2017
  • March 2017
  • February 2017
  • January 2017
  • November 2016
  • October 2016
  • September 2016
  • August 2016
  • July 2016
  • October 2015
  • August 2015
  • May 2015
  • March 2015
  • December 2014
  • February 2013
  • July 2011
  • June 2011
  • March 2011
  • February 2011
  • December 2010
  • October 2010
  • September 2010
  • August 2010
  • July 2010
  • June 2010
  • May 2010
  • March 2010
  • February 2010
  • January 2010
  • December 2009
  • November 2009
  • August 2009
  • April 2009
  • March 2009
  • February 2009
  • January 2009
  • October 2008
  • September 2008
  • August 2008
  • July 2008
  • June 2008
  • April 2008
  • March 2008
  • February 2008
  • January 2008
  • December 2007
  • November 2007
  • October 2007

RSS Feed RSS - Posts

Recent Posts

  • Pay less using scheduled autoscaling for Azure SQL Database & Azure Analysis Services
  • Process Azure Analysis Services objects using a Logic App part 2
  • Process Azure Analysis Services objects from Azure Data Factory v2 using a Logic App
  • Multi-Source partitioned Azure Analysis Services tables – cold data from Azure Data Lake Store, hot data from Azure SQL Database
  • PASS Summit 2017 Day 3
  • Follow Following
    • Jorg Klein's Blog
    • Join 126 other followers
    • Already have a WordPress.com account? Log in now.
    • Jorg Klein's Blog
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar