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.

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

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

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 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.

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.

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

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.

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

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 demo-oriented session, you will see some common T-SQL mistakes and how to avoid them.

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.

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.