17th - 19th July 2014

The International Centre, Telford

Platinum Sponsor

28 Weeks later - How to scale-out your MS Business Intelligence environment

This session will demonstrate possibilities to scale-out your existing Microsoft BI environment. We will explore the ways how to use link dimensions, link measure groups and remote-partitions in Analysis Services. With the approach of synchronization and load balancing to increase the high availability of the service. We also take a close look on the Shared Scalable Database feature and how to use your SAN environment wisely. You will see how to use Analysis Management Objects (AMO) to manage our scalable environment and see how ETL Jobs also need assistance to scale out and build an alternative decentralized SSIS scheduling system. This approach is also cloud ready! with many samples and source code to demonstrate the approaches.
Presented by Sascha Lorenz at SQLBits VIII
  • Downloads
  • SpeakerBIO
    sascha_lorenz.jpg
    Sascha is co-founder of PSG GmbH and works since 1996 as a Principal Consultant focusing on the Microsoft Data Platform. He is also active in the SQL community as a leader of the Hamburg PASS Chapter and as a speaker on SQL Server related events.
    http://saschalorenz.blogspot.com http://saschalorenz.blogspot.com/feeds/posts/default
  • Video
  • Session Files Explorer
    The network name cannot be found.