Silicon Valley Code Camp : October 5th and 6th 2013

Joel Champagne

CodeX Enterprises LLC
About Joel
My 25 years in the industry have been largely spent in consulting, helping clients deliver large business solutions, mostly using .NET technologies, SQL Server, SSAS and SSRS. My specialty is in the SQL space, in particular data modeling and BI, although I've been very involved with application frameworks and architecture as well.
{speaker.firstName} {speaker.lastName}

Speaking Sessions

  • A SQL Server performance warehouse using the SSAS tabular model

    9:15 AM Sunday   Room: PSEC4502
    What if you could take performance data related to SQL Server (and we'll touch on non-SQL Server sources as well) and collect it into a data warehouse that's implemented using the SQL 2012 SSAS Tabular Model? You'd be able to build virtually an infinite number of reports using tools such as Excel 2010+. You'd be able to consolidate different kinds of metrics and define your own KPI's. In this session I'll show you the work I've done to accomplish this, codified in the SQL-Hero product. You'll understand the concepts involved so you can roll your own solutions, or you'll see enough to get up-and-running quickly if you choose to use SQL-Hero. Along the way, you'll also learn about SSAS, PowerPivot and DAX; plus we'll touch on SQL Server Extended Events and some handy DMV queries.