3/2/2015 12:15:22 PM
Columnstore indexes represent an revolutionary new index type that was released initially with SQL Server 2012. With the release of SQL Server 2014 Microsoft reduced the blockers for columnstore's broad acceptance. In this session Victor Isakov (MCA, MCM, MCSM, MCT, MVP) will go through the architecture and pros/cons of columnstore indexes. Victor will also cover the use cases of where columnstore indexes can be used, and give some examples of where they have been implemented and what performance gains were achieved. Perhaps Victor's most important take away will be that columnstore indexes can be used in workloads other than traditional DW/DSS queries. Are you interested in improving performance by a few hundred-fold?
Speaker: Victor Isakov (SQL Server Solutions)
Victor Isakov is a Database Architect and Microsoft Certified Trainer who provides consulting and training services to various organizations in the public, private and NGO sectors globally, and been involved in different capacities at various international events and conferences. He has authored a number of books on SQL Server and worked closely with Microsoft to develop the new generation of SQL Server Certification and Microsoft Official Curriculum for both instructor led training (ILT) and e-Learning. He is one of the first IT professionals to get the Microsoft Certified Master and Microsoft Certified Architect certifications globally.
Venue: Sydney Mechanics' School Arts |
Duration 12:00 - 14:00 |
On: Wednesday, March 4, 2015