SQLBits 2011
28 Weeks later - How to scale-out your MS Business Intelligence environment
The SQL Server provides much functionality that increases the scalability and flexibility of your solution by distributing data and jobs among low-priced commodity servers.
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.
Speakers
Sascha Lorenz's previous sessions
First Dates: AI & DBAs. Any Chance to be a perfect match?
In this session, we will discover how to utilize common machine learning approaches for daily SQL Server DBA tasks.
The Developer Side of SQL Server Monitoring and Diagnostics
The Microsoft SQL Server comes with many features to take a look behind the scenes of the powerful engines. This session will explain how to use the power of these tools to write your own monitoring and diagnostics environment in Powershell and C#.
The Developer Side of Master Data Services
The Master Data Services offers an easy to use toolset to work with Master Data. In this session we will explore the hidden power of MDS to integrate this service in our solutions. Take your MDS Project on a higher level.
28 Weeks later - How to scale-out your MS Business Intelligence environment
The SQL Server provides much functionality that increases the scalability and flexibility of your solution by distributing data and jobs among low-priced commodity servers.
The Developer Side of the Microsoft Business Intelligence stack
The Microsoft SQL Server provides a complete library of programmatically accessed objects for all Business Intelligence relevant services. With this set of functions almost any customer challenge can be solved without the need to purchase additional products. This possibility is often underestimated in projects. The session will explain the hidden power of using the Microsoft APIs to build BI middleware solutions for enterprise customers.