Deploying Highly Available SQL Server 2012 BI Environments

2012

TL; DR

This training day will show how to deploy a highly available SQL Server 2012 Business Intelligence environment and discuss the features which make it possible to deliver services such as PowerPivot, PowerView, Reporting Services and Analysis Services

Session Details

Business Intelligence services today play a critical role in helping many organisations make effective business decisions leaving them highly dependent on the underlying technology being available. A failure of a Business Intelligence component is now often regarded as a severe incident throughout the whole business, not just IT departments, so to minimise the chance of an outage SQL Server 2012 can use several high availability technologies to make the environments it powers resilient. This pre-conference training day will show you how to deploy a highly available end to end SQL Server 2012 Business Intelligence environment and discuss the features which make it possible to deliver services such as PowerPivot, PowerView, SQL Server Reporting Services and SQL Server Analysis Services from a robust architecture.

Topics covered in this pre-conference session are:

·         Deploying a highly available SQL Server database engine using AlwaysOn
·         Deploying a highly available Analysis Services platform using failover clustering
·         Planning the SharePoint Farm.
·         Preparing for a SharePoint Web Farm deployment.
·         Installing the SharePoint Web Farm.
·         Configuring a highly available PowerPivot environment
·         Configuring a highly available Reporting Services environment
·         Configuring PowerView
·         Testing a highly available SQL Server 2012 Business Intelligence environment

3 things you'll get out of this session

Chris Testa-O'Neill's previous sessions

Orchestrating data with Azure Data Factory

See how Azure Data Factory orchestrates the movement of data in Azure, with a case study from a Microsoft partner.

Increasing Business and IT Collaboration with SQL Server

SQL Server provides the ability to deliver solutions for BI users with all experience levels. See the ease of collaboration of business intelligence reporting between business users and IT departments and demonstrate a real world use case.

Understanding Microsoft Certification in SQL Server

In this session, Pete Harris, Chris Testa-O’Neill and Christian Bolton will provide an overview of the certifications and training offered by Microsoft for SQL Server 2012.

We have control!-Controlling Resources in SQL Server

With SQL Server 2008, you can control environments using Policy based management and with the Resource Governor to ensure that your SQL Server are compliant to enterprise standards

Creating Compelling reports with Microsoft SQL Server 2008 R2

Explore the new features of SQL Server 2008 R2 Reporting Services

Understanding Microsoft Certification in SQL Server

An overview of the steps required to get certified with Microsoft Learning

Gavin Payne's previous sessions

An introduction to SQL Server for data scientists

A little bit of knowledge about how SQL Server works can go a long way towards making large data engineering queries run faster.

Designing quality SQL Server 2014 solutions

This session shows how you can use SQL Server 2014’s features to meet your solution’s non-functional requirements and ensure operational success.

The NUMA internals of SQL Server 2012

This session reviews the purpose of NUMA, how it changes the internal behaviours of Windows and SQL Server 2012 and NUMA related performance monitoring.

Through the virtual looking glass - monitoring virtualised SQL

Virtualisation changes the way you need to monitor the performance of a virtualised instance of SQL Server. In this session I will demonstrate a balanced and well-rounded approach to performance monitoring in the virtual world along with best practices to avoid poor virtualised performance.

Oracle for SQL Server DBAs

If you’ve only ever chosen to use Microsoft database products then there’s a chance you might hide a curiosity deep down about the Oracle database platform; or like me a few years ago be told that your next big production system will use it and now’s the time to upskill. This session introduces some key concepts and differences about the Oracle database platform to people like myself who are used to the UI-heavy Windows-based database world and hopefully make you curious enough to want to at least give it a try when you get back home.