SQL Server 2012 Business Intelligence delivers a comprehensive platform empowering organizations to build and deploy secure, scalable and manageable BI solutions.
Empower users to access and mash-up data from virtually any source and easily collaborate and share insight using familiar tools with PowerPivot.
Provide a consistent view across heterogeneous data sources and easily transform end user created apps into corporate BI solutions.
Discover new insights with Power View, an interactive browser-based data visualization and presentation experience for users of all levels.
Maintain master data across the organization structures used for object mapping, reference data, and metadata management.
Help improve data quality by using organizational knowledge and 3rd party reference data providers to reliably profile, cleanse, and match data.
xVelocity in-memory analytics engine provides a generational leap in performance while allowing an interaction with an unprecedented amount of data.
Discover new insights at the speed of thought with Power View, a highly interactive, familiar browser-based data exploration, visualization, and presentation experience for users of all levels. Additionally, Power Pivot helps empower users to access and mash-up data from virtually any source, including Big Data sources using familiar tools.
Balance the need to monitor, manage, and govern the data and analytics end users create with IT dashboards controls across SQL Server and Microsoft SharePoint that help IT monitor end user activity, data source usage, and gather performance metrics from servers. New to SQL Server 2012, IT can also transform end user-created BI applications in Power Pivot into corporate-grade solutions managed by IT.
Build and deploy advanced scalable, secure and manageable BI corporate solutions with advanced analytics and reporting, tabular BI Semantic Model and xVelocity in-memory analytics engine. Business users gain advanced predictive analytics with the simplicity and familiarity of Microsoft Excel with SQL Server 2012 Data Mining Add-ins for Microsoft Office.
With SQL Server 2012, IT can better control and manage data through a new BI Semantic Model and enhancements to SQL Server Integration Services. Meanwhile, new Data Quality Services uses organizational knowledge and 3rd party reference data providers to reliably cleanse data and a new Master Data Services Add-in for Excel makes it easy for end users to manage and maintain central data.
Reduce OS patching by as much as 50-60% with new support for Windows Server Core.¹ Meanwhile, SQL Server Management Studio introduces Database Recovery Advisor to help simplify the ways DBAs restore databases, PowerShell 2.0 support, and enhancements to Sys Prep to help IT more efficiently create VMs. Security enhancements help IT more easily manage permissions around data access with User-Defined Server Roles to support separation of duties. Increase manageability and decrease complexity of database schema through new Default Schema for Groups that allows a default database schema for Windows group user accounts.
¹ The percentage reduction in patching varies and can be less based on the server roles that are enabled and the type of patches that are applied.
SQL Server 2012 editions are now offered in a consistent, tiered model which creates greater consistency across editions, features, and licensing.
SQL Server 2012 delivers an ROI of up to 189% with a 1 year payback period¹.
¹Total Economic Impact Of SQL Server 2012 Upgrade, a commissioned study conducted by Forrester Consulting on behalf of Microsoft, March 2012
Join the SQL Server Community to access resources, connect with peers, and learn from Microsoft experts.