You are here:Home » tsql » What's new with SQL Server Code-Named "Denali".

What's new with SQL Server Code-Named "Denali".

Every readers want to know the new features and enhancements of new version of SQL Server.I am also, and also eager to blog the new features. New version is available for the preview for community which is called as SQL Server Code-Named - Denali. It is also known as SQL Server 2011.

You can download this CTP at http://www.microsoft.com/downloads/en/details.aspx?FamilyID=6a04f16f-f6be-4f92-9c92-f7e5677d91f9.

I have downloaded the SQL Server Code-Named "Denali" Community Technical Preview (CTP) and started to learn new features of the Denali.

Some of the new features are listed below.
  • SQL Server AlwaysOn.
  • T-SQL Enhancements.
  • Changed Startup Option.
  • Availability Groups(HADR).
  • Contained Databases.
  • Sequence.
  • Fulltext Search Enhancement.
  • New Collation Support.
  • Data Integration Management.
  • BI Enhancement.
  • Juneau.
  • Analytic Enhancement.
  • IT Administration.
  • Column  Based Query Accelerator.
  • Ad-Hoc Query Paging.
  • Code Snippets Manager.
  • Task List.
  • Zoom or Magnify.
  • High Availability and Disaster Recovery.
  • SSIS Enhancements.
  • Spatial data Type Enhancement.
  • Multi Subnet Fail-over Clustering.
  • Migration and Deployment.
  • Beyond Relational.
  • Security Enhancement.
  • Metadata Discovery.
  • Extended Order By Clause Functionality.
  • FileStream Enhancement.
  • Multi Monitor.
  • Replication Enhancement.
  • Service Broker.
  • Error Handling Enhancement.
  • Installation Enhancement.
You can find What's new of  "Denali" here, http://msdn.microsoft.com/en-us/library/bb500435(v=sql.110).aspx.

All New features together at SQL Server MVP Jacob's site here, http://beyondrelational.com/whatisnew/sqlserver/denali/.

Please comment me if missed any new features of SQL Server 2011(Denali). I will future post of these new features and enhancements.