Review: SQL Server 2012 stands tall


Become An Insider

Sign up now and get free access to hundreds of Insider articles, guides, reviews, interviews, blogs, and other premium content from the best tech brands on the Internet: CIO, CSO, Computerworld, InfoWorld, IT World and Network World Learn more.

Huge HA and indexing improvements top the list of great new features in Microsoft's latest database release

As we've come to expect from new SQL Server releases, SQL Server 2012 has so many new features that it's impossible even to mention them all. Nearly everyone is well served, from the BI-hungry users of Reporting Services to the IT folks who oversee query performance and uptime. SQL Server 2012 brings improvements across the board, with only a few disappointing exceptions.

Reporting Services adds a Web front end for data exploration and visualization called Power View. Analysis Services introduces a new semantic model, giving BI specialists more flexibility in building solutions. New column store indexing shifts query performance into high gear, while new Data Quality Services and improvements to Master Data Services round out the tools for taking care of company data.

[ Windows 8 is coming, and InfoWorld can help you get ready with the Windows 8 Deep Dive PDF special report, which explains Microsoft's bold new direction for Windows, the new Metro interface for tablet and desktop apps, the transition from Windows 7, and more. | Stay abreast of key Microsoft technologies in our Technology: Microsoft newsletter. ]

To continue reading, please begin the free registration process or sign in to your Insider account by entering your email address:
Free Course: JavaScript: The Good Parts
View Comments
You Might Like
Join the discussion
Be the first to comment on this article. Our Commenting Policies