This event has ended

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

Microsoft Business Intelligence and Big Data User Group of New York City

Monday, November 12, 2012 from 6:00 PM to 8:30 PM (EST)

New York, NY

Microsoft Business Intelligence and Big Data User...

Ticket Information

Type End Quantity
Attendee Ended Free  

Share 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

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

Have questions about 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? Contact Microsoft Business Intelligence and Big Data User Group of New York City

When & Where


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

Monday, November 12, 2012 from 6:00 PM to 8:30 PM (EST)


  Add to my calendar

Organizer

Microsoft Business Intelligence and Big Data User Group of New York City

A community dedicated to the development of expertise in Microsoft BI technologies and related third party products.

  Contact the Organizer

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.