Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in


Steve Hughes is a Principal Consultant at Magenic. His area of expertise is in data and business intelligence architecture on the Microsoft SQL Server platform. He was also the data architect for a SaaS company which delivered a transportation management solution for fleets across the United States. Steve has co-authored two books and delivered more than 30 presentations on SQL Server and data architecture over the past six years. He also provides insights from the field on his blog at

Countdown to PASS Summit 2012 – 2 to Go – I’m Presenting Again

I assume at this point some of you are already in Seattle and even getting ready to attend Preconference Sessions. If you are, enjoy them. Many are now in the process of traveling to the conference including myself. So, if you are still looking at the schedule, consider hitting one of my sessions, including a session in the last slot on Friday. Here is the info on my sessions, maybe I will see you there.

Building a Tabular Model
4:45 PM – 6:00 PM

Room: 613-614

[BIA-208] Building a Tabular Model Database

Come learn about the tabular model in SQL Server 2012 Analysis Services and watch a model being 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.

A Window into Your Data: Using T-SQL Window Functions
4:15 PM – 5:30 PM

Room: 305-TCC

[AD-319] A Window into Your Data: Using SQL Window Functions

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 this demo-filled session on how and when to use SQL window functions.


Leave a comment on the original post [, opens in a new window]

Loading comments...