SQL SERVER - DENALI

GUYS,


SQL SERVER next version DENALI's CTP is out. Here are the details:

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’ continues to magnify the each of  BI through highly interactive web-based visualization and storyboarding providing breakthrough performance, common models and IT manageability. With end-to-end data integration and management tools, IT can help deliver consistent, credible data to the right users at the right time. The following highlights a few key enhancements for pervasive insight.

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.

Experience breakthrough performance with in-memory analytics, and drive alignment across the organization

• Provide breakthrough analytics performance from the desktop to data center through the Vertipaq in-memory column store technology. Also benefit from next-generation semantic model for both reporting and analytics that span your business from personal BI solutions to the most demanding organizational BI needs.

Enterprise data integration management

• SQL Server code-named “Denali” will introduce a holistic data integration and management solution that will help organizations ensure the right data is delivered to the right users at the right time. New to “Denali” are two key components to data management, Data Quality Services for knowledge-driven data cleansing and Impact Analysis and Lineage.
  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.

  Beyond relational enhancements

  • Build more flexible, innovative applications with rich capabilities and data patterns with faster performance for FileStream and Full-Text Search, 2D spatial support, and FileTable.

  Unified developer experience, SQL Server Tools code-named “Juneau”

  • Accelerate time-to-market for developers with a single environment for developing database, BI and web solutions. New capabilities include a unified environment for SQL Server development, Declarative Database Definition, Dynamically Edit Existing Databases, Round-Trip Code Refactoring, and Targeted Database Deployment.
    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.

      
      

      Click here to Download the CTP.
      

      
      

      Enjoy