In this video, Ross discusses the new ColumnStore Indexes, FileStream, AlwaysOn Availability Groups, and other new and improved features.
There are some great stats in this video, citing the tremendous data warehouse query performance gains that can be achieved using ColumnStore Indexes (up to 100X), available directly within the database engine.
Big data data warehousing was the hot topic of the day. The video also includes segments by Microsoft MVPs Mark Ginnebaugh and Bill Graziano, plus Alex Viera and Britt Johnston of Microsoft. SQL Saturday Silicon Valley featured speakers on SQL Server 2012, DBA, Development, Business Intelligence, SQL Server 2012, and Azure. Many thanks to the sponsors, speakers, volunteers, and 450+ attendees.
If you haven’t had a chance to review the SQL Server 2012 feature set, this video will give you an idea of enhancements you should investigate.