Notable SQL Server 2012 Enhancements
SQL 2012 has added many areas to its ecosystem. This includes new appliances, integration with “Big Data,” and connectors that leverage this technology as sources and destinations for analytics. Reference architectures have been improved and are released with improvements for SQL 2012. New features that add incredible performance boosts make these architectures a major weapon in return on investment (ROI) for many organizations.
Many of the important features that have been added to SQL Server 2012 fall into several categories, including the following:
- Availability Enhancements
- AlwaysOn Failover Cluster instances
- AlwaysOn Availability Groups
- Online operations
- Manageability Enhancements
- SQL Server Management Studio enhancements
- Contained databases
- Data-Tier Applications
- Windows PowerShell
- Database Tuning Advisor enhancements
- New Dynamic Management Views and Functions
- Programmability Enhancements
- FileTables
- Statistical Semantic Search functionality
- Full-Text Search improvements
- New and improved Spatial features
- Metadata discovery and Execute Statement metadata support
- Sequence Objects
- THROW statement
- 14 new T-SQL functions
- Extended Events enhancements and more
- Security Enhancements
- Enhanced Provisioning during setup
- New permissions levels
- New role management
- Significant SQL Audit enhancements
- Improved Hashing algorithms
- Scalability and Performance Enhancements
- ColumnStore Indexes and Velocity
- Online Index operation support for x(max) ...
Get Microsoft SQL Server 2012 Bible 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.
