Summary

Many SQL Server practitioners work exclusively with the product’s relational engine, and many users in the BI market continue to pay significant sums to license stand-alone BI products and suites from other vendors. Meanwhile, Microsoft includes with SQL Server one of the most capable and complete BI stacks in the industry.

The 2008 R2 stack was already impressive, as it included Master Data Management, reporting, ETL, multidimensional OLAP, complex event processing, and in-memory column store analytics embedded into Office and SharePoint. But SQL Server 2012 makes the stack significantly more capable by adding Alerting, Data Quality, stand-alone column store analytics, relational Columnstore indexes, and advanced self-service analysis ...

Get Programming Microsoft® SQL Server® 2012 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.