SQLSERVERLEARNER

SQL Server 2011 – Code Name “Denali”

SQL Server 2011 CTP is released.

Following are the new features added in Denali:

Database Engine:

• HADR – high-availability and disaster recovery solution
• Enhanced TSQL debugging
• Enhanced IntelliSense
• PowerShell – This is a prerequisite now for Denali
• Contained Databases – Helps in easyly moving databases from one instance to other.
• Access to contained databases with out logins
• Startup Parameters – Helps in setting up startup options
• Enhanced full-text index
• Simplified Metadata Discovery – SET FMTONLY
• Execute Statement – WITH RESULT SETS Option
• New Supplementary characters Family
• Spatial Types – circular arc segments Support
• Sequence object – Similar to identity but not just bound to tables
• New Permissions such as GRANT, REVOKE, and DENY on SEARCH PROPERTY LIST , CREATE SERVER ROLE and ALTER ANY SERVER ROLE
• User defined server roles
• Hashing Enhancements – HASHBYTES

Download CTP1 Link: Download

Books Online For Denali: Link

This information is for preview only and is subject to change.
Reference: Microsoft books online.