Learn new skills that are in strong demand in the BI/BA world and actually understand what you learn.

This full day session will bring you up to speed on Microsoft’s implementation of a cloud based database solution known as Windows Azure SQL Database and the many facets that this data tier encompasses.

This session will discuss how MDS fits in the overall EIM architecture within your organization including real-world strategies for integrating (cleansing, matching and loading) Master Data into MDS and for making it available organization-wide.

In this session, you will learn the 12 steps of SQL Server performance tuning.

In this session Steve will explain what OData is and what tools are involved.

Join Chad as he shares how to achieve consistency and minimize overhead using Central Management Server.

In this session, we will be looking at what it takes to get DQS up and running in your environment, how to set up Knowledge Bases, and how to utilize the system with tools like SSIS and Master Data Services.

In this session, you will learn how to use SQL Server wait statistics to troubleshoot performance problems.

In this session, Chad will explain everything you need to know about designing and managing SQL Server replication.

If you have never used these functions or are looking to solve ranking and aggregate types of calculations without using GROUP BY, join us for a demo filled session on SQL window functions.

In this session, you'll explore the internals of SQL Audit, along with how to plan, create, and monitor instance and database level audits.

Join Kevin as he shows you all the new features in SQL Server Integration Services 2012.

This session will explain how to build the right SQL Server AlwaysOn Availability Group topology that will address your high availability and disaster recovery requirements.

In this session, you will learn about the physical aspects of columnstore index in SQL Server 2012, how to create it, and what environments (mainly data warehousing environments) and queries can make use of it.

In this session, you'll learn how to use T-SQL to natively encrypt data in a SQL Server database.

Join Don as he shares how you can safely tune performance of a database (that doesn't belong to you).

In this session, we will look at the underlying concepts behind AlwaysOn Availability Groups – how it works under-the-covers and how you can leverage this information to efficiently design a highly available database.

In this session, you will learn everything you need to know abou the SQL Server Transaction Log and how it affects High Availability and Disaster Recovery.

In this session, you will learn some tips and tricks when virtualizing SQL Server.

This session uses field-tested techniques to demonstrate how you can use familiar tools to dig into Analysis Services processing and query handling to identify bottlenecks, isolate issues while understanding how and why they occur and what needs to be done to resolve or fix them.

This session is for the Windows Azure SQL Database beginner. Kevin will explain how to create an Azure account and how to create/manage Azure databases.

Learn how developers with relational database skills can make the jump into this exciting and opportunity-filled area.

In this session you will learn how to plan and configure SQL and SharePoint 2013 Business Intelligence.

In this session, Pinal will show you some advanced tips/tricks for performance tuning and troubleshooting.

In this session you will learn how to troubleshoot issues and monitor query performance.

The ability to do serious, sophisticated analytics in Excel is here, right now - come learn more.

In this session, you'll learn how to implement a Tabular Data Model with Microsoft PowerPivot and Analysis Services.

Join Bradley as he shows you how to make your queries run faster using the Query Optimizer.

In this session you will explore Data using Data Explorer.

In this session you will learn when to migrate applications to Windows Azure SQL Database, the options you have available and how to troubleshoot common errors.

In this session you'll learn the necessary integration/configuration steps for integrating SSRS 2008R2/SSRS 2012 with SharePoint 2010/2013, as well as deploying reports to a SharePoint location.

This session will dive into the new FileTable and Statistical Semantic Search features.

In this session, Pinal will share some tips/tricks on how to optimize your server's performance using practically no SQL coding at all.

In this session, Bill will provide an overview of the steps required to "upgrade" an Excel PowerPivot model to a SSAS 2012 Tabular model using SQL Server Data Tools (SSDT).

In this session, we will break down the basics of sharding within SQL Azure Federations, explain what needs to be taken into consideration in terms of database design, what developers need to know, and show you real world solutions using SQL Azure Federations to overcome difficult scenarios.

In this session, you'll learn how to automate the SQL Server install and configure/deploy standard objects using PowerShell.

This session will provide an overview of the primary features of PowerPivot.

This session explains how developers can resolve issues using tools available for tracing and information on how to access those tools.

In this session, David will cover how you can identify errors that occur within SSIS 2012 and how to handle them dynamically and proactively.

In this demo-oriented session, you will see some common T-SQL mistakes and how to avoid them.

In this session, Michael will show you how to maximize your efficiency using PowerShell for process automation.

In this session you'll learn the different methods of securing data in your cube.

In this session, Bradley will dive-deep on project "Hekaton" and explain all everything you need to know about this new technology.

In this session, Lenni will guide you through the T-SQL enhancements in the latest release of SQL Server.

This session explains what aggregations are and how they work.

Join Jason as he shows you how to use SQL Server to monitor and track user activity.

In this session, Bradley will guide you through the new features of SQL Server 2014.

In this session, Don explains everything you need to know about SQL Server indexes.

In this session you will learn the new features of SQL Server Enterprise and how/why you should use them.

In this session, you will learn the how to use the new SQL Server Data Tools (SSDT).

This session goes through the process of optimizing cube creation through the proper design of dimensions, measure groups, aggregations, calculations, perspectives, security, and more.

This full-day workshop will get you up to speed on powerful new features in SQL Server 2008, SQL Server 2008 R2, and SQL Server 2012.

This full-day session walks through the entire process of data warehousing.

Gain the background information you'll need to really leverage other courses at the conference!