Have you put in your vote for which sessions you’d like to see at SQL Rally? If not then cast your vote here so you can get the most out of your time this May in Dallas. All it takes is to be a member of PASS and a few minutes.
I have a session on the ballot that’s called Using Columnstore Indexes in SQL Server 2012 and below is the session abstract for you to review. You might not be sure whether to vote for my session or you don’t know whether you need to attend session on columnstore indexes, so I’ll give you one really good reason.
The Reason for Learning about Columnstores
Columnstore Indexes are really important because in SQL Server 2012 they will have to be seriously considered by DBAs and BI Architects as a replacement for cubes (or as an alternative) and as the primary indexing scheme for star schemas, report subsytems, data warehouses and any other reporting and analysis scenario. Making the right decision will require you to have in-depth knowledge of how these indexes work. That’s what you’ll get if you attend my session.
Session Abstract: Using Columnstore Indexes in SQL Server 2012
Columnstore Indexes in SQL Server 2012 will allow you to significantly improve the processing time of common data warehousing queries without creating cubes, aggregated tables, or other techniques normally used to improve performance. This session will show how to implement this new type of index in SQL Server and demonstrate their advantages compared to traditional solutions. Carlos will also discuss the scenarios for which columnstore indexes should be implemented to provide powerful but flexible BI solutions.
Go to this blog post I wrote several weeks ago for more info on columnstore indexes.