sql server 2011 released

Posted on : 01-07-2011 | By : Devi Prasad | In : Denali

1



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.




Reference : Devi Prasad (sqlserverlearner.com)

Do you like my blog?

If you liked reading this blog, please help spread the word by sharing this blog with your friends.



Need Help On SQL Server?

Cannot Find Solution to your problem (or) If you are looking for some help on SQL Server. Dont worry Click Here to Post your question and solve your issue.




Your Ad Here


Tags: , , , , , ,