Page 2 of 2
In SQL Server 2008 R2 Microsoft introduced PowerPivot, a tool that allowed users to create their own data models for developing Excel-like reports without help from IT department developers. SQL Server 2012 offers Power View (developed under the code name Crescent), a tool that takes the database's self-service business intelligence capabilities even further.
Along with new data exploration and visualization features, Power View works with SharePoint to help users save and share data models -- empowering information workers to build their own reports without waiting for help from IT.
The new database also offers a single business intelligence semantic model for users with multiple ways of building business intelligence applications. "This gives us more choices in how we can design a BI solution," Perficient's Schafer said. "[Customers] now essentially have all the business intelligence functionality they need."
Tallan, which holds Microsoft Gold competencies in business intelligence, application integration and application life-cycle management, has been developing proof-of-concept systems around early releases of SQL Server 2012. The solution provider, which builds data warehouse systems and reports for customers, has been holding seminars on the new product for clients and developers.
SQL Server 2012 incorporates in-memory column store technology (code-named Apollo) and new development tools (code-named Juneau) for developing database, business intelligence and Web applications for SQL Server and SQL Azure.
Such capabilities expand the range of problems users can address with the database and help partners such as Tallan complete projects more quickly while spending less time building database infrastructure. "The flexibility is tremendous," Tallan's Worobec said.
SQL Server 2012's integration with the SharePoint Active Directory will become increasingly important as more users access the database through the cloud, said Ronnie Parisella, IT director at Power Consulting Group, a New York-based IT consulting and managed services company that partners with Microsoft. "And the new Hyper-V integration is going to be killer," he said, noting SQL Server 2012's new virtualization abilities.
Completely new to SQL Server is the addition of data quality services for profiling, cleansing, validating and matching data. The new capabilities are in addition to enhancements to the master data management capabilities that were introduced in SQL Server 2008 R2.
The data quality services tools, along with enhancements to the master data management features, mean that Microsoft SQL Server now has a complete lineup of enterprise information management technologies -- a point that Schafer said is prominently mentioned in the SQL Server 2012 marketing materials. "The entire EIM stack is maturing," he said.
SQL Server 2012 also offers a range of improvements in clustering, high-availability, failover and disaster recovery. Most important are the new SQL Server AlwaysOn tools including AlwaysOn Failover Cluster Instances, AlwaysOn Availability Groups, AlwaysOn Connection Director Capabilities and AlwaysOn Active Secondaries.
The new Availability Groups enhance the database system's data mirroring capabiliites, for example, while Active Secondaries allow backup databases to be used to run reporting queries and other tasks instead of sitting idle.
Other enhancements include improvements to the database's full-text search capabilities, improved SQL Server auditing tools, and a new distributed, multithreaded replay utility for simulating production workloads for testing after system upgrades or configuration changes.