Microsoft Business Intelligence and Big Data User Group of New York City presents: SQL Server 2012 Columnstore index – What it means for Data Warehouse and Business Intelligence Applications

New York, NY

Bummer! Sales have ended.

Unfortunately, tickets for this event are no longer on sale.

View upcoming events Create an event

Event Details

 SQL Server 2012 Columnstore index – What it means for Data Warehouse and Business Intelligence Applications

It might seem far-fetched that a company would upgrade to SQL Server 2012 “just” for a database index. But after you see the performance enhancements gained from the new columnstore index in SQL Server 2012, you’ll see why many are calling this one of the most important features in the history of SQL Server. In this presentation, I’ll talk 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. I’ll show performance benchmarks between columnstore indexes in SQL Server 2012, and compare them to index strategies prior to SQL Server 2012. I'll also show how the new Batch execution mode can improve performance as well.  Finally, I’ll talk about the new xVelocity (formerly “Vertipaq”) engine in Analysis Services 2012, its relationship to the Columnstore index,  and the benefits.

Presenter: Kevin S. Goff

Kevin S. Goff (http://www.kevinsgoff.net) is a Microsoft SQL Server MVP, SQL Server/Business Intelligence Practice Manager for SetFocus LLC, author of 2 books, regular columnist for CoDe Magazine on .NET, SQL Server, and Business Intelligence topics, and a frequent speaker at community events in the Mid-Atlantic region.

Contact URLhttp://www.KevinSGoff.net

Date/Time:

11-12-2012 6:00 P.M. – 8:30 P.M.

Location:  

Microsoft NYC offices, 1290 Avenue of the Americas, 6th Floor, New York, NY, 10104