Presenting at PASS Summit 2012

I am pleased to announce that I will be speaking at the PASS Summit again after a four-year “break”.  I get the privilege to present on some awesome new technologies released in SQL Server 2012.

Here are my sessions for this year’s Summit:

A Window into Your Data:  Using SQL Window Functions

Application & Database Development Track

Window functions are an underused feature in T-SQL that have been greatly expanded in SQL Server 2012. These functions can help you solve complex business problems such as running totals and ranking. 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 this demo-filled session on how and when to use SQL window functions.

Building a Tabular Model Database

BI Platform, Architecture, Development & Administration Track

Come learn about the tabular model in SQL Server 2012 Analysis Services and watch a model built from “Create Project” to deployment. Microsoft introduced the tabular model in SSAS 2012. Its supporting technology is based on the xVelocity query processor, which was introduced in PowerPivot. In this session, we will create a tabular model database in SSAS using SQL Server Data Tools. We will add data from various types of data sources and build relationships between them, then extend the solution by adding calculations, measures, and hierarchies. Finally, we will cover some of the management techniques required to support a tabular model in an enterprise solution.

Check out the other sessions that have been announced and get signed up soon to take advantage of the current price $1,395 which is good until June 30, 2012, at  I will look forward to seeing you there and at other community events this year.