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.

Download SQL Server code-named “Denali”

Post By Gishore J Kallarackal (2,121 Posts)

Gishore J Kallarackal is the founder of techgurulive. The purpose of this site is to share information about free resources that techies can use for reference. You can follow me on the social web, subscribe to the RSS Feed or sign up for the email newsletter for your daily dose of tech tips & tutorials. You can content me via @twitter or e-mail.

Website: → Techgurulive