by http://webgeektutorials.blogspot.com

Monday, January 31, 2011

SQLServer code named 'Denali'?


What is SQL Server code name "Denali" ?? info : Microsoft.com

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 Denali Management Studio
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:
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. Learn more.
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.
New tools and capabilities will help developers build innovative applications with reduced time-to-market while IT professionals benefit from greater operational control and ease of use. The following highlights a few key enhancements for increased IT and Developer productivity.

IT administration enhancements

  • Security enhancements will help improve compliance by using auditing for all editions of SQL Server and more easily and effectively manage separation of duties using fine-grained server roles. Meanwhile supportability improvements will help simplify application testing and minimize errors with application changes and upgrades using Distributed Replay. In addition, Extended events dramatically streamline performance troubleshooting with new profiling information and a new user interface.

Expand the use of BI to business users
  • Business users will gain greater agility and empowerment with a new highly interactive, web-based data exploration and visualization solution. Introducing new and engaging ways to discover insights through a drag-and-drop interface, smart and powerful data querying and interactive storyboarding to allow users to quickly create and share visual presentations of large datasets.

No comments:

Post a Comment