SQL Server code-named “Denali”
Microsoft SQL Server code-named â€œDenaliâ€ empowers organizations to be more agile in todayâ€™s competitive market. Customers can efficiently deliver mission-critical solutions through a highly scalable and available platform. Industry-leading tools help developers quickly build innovative applications while data integration and management tools help deliver credible data reliably to the right users and new user experiences expand the reach of BI to enable meaningful insights. With SQL Server code-named â€œDenaliâ€ customers will benefit from the following added investments:
- Enhanced Mission-Critical Platform: an enhanced highly available and scalable platform.
- Developer and IT Productivity: new innovative productivity tools and features.
- Pervasive Insight: expanding the reach of BI to business users and end-to-end data integration and management.
SQL Server code-named â€œDenaliâ€ provides a highly available and scalable platform with greater flexibility, ease of use, lower TCO, and the performance required by the most mission-critical applications. The following highlights a few key enhancements for a mission-critical platform.
SQL Server AlwaysOn
- The new SQL Server AlwaysOn will provide a set of capabilities to help businesses maximize uptime of their mission critical applications, simplify high availability deployments and provide better returns on hardware investments. AlwaysOn supports multi-site clustering and the new availability group option will help improve availability of databases by supporting multiple secondaries, increase utilization using active secondary and simplify HA management. In addition, Windows Server Core support will help reduce unplanned downtime related to OS patching with ~50-60% few OS reboots.
Column-based query accelerator
- Column-Based Query Accelerator will help dramatically increase query performance ~10x and reduce performance tuning through interactive experiences with data for near instant response times and streamlined setup which removes the need to build summary aggregates.