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. This version 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.
• Query Editor changes
• Execution With Result Sets
• Surround With Snippets
• Performance Review and Stored Procedure execution with ResultSets
• Cycle Clipboard Ring

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 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.