What is SQL Server "Denali"? What's new?
The new features include :
- Multi-Subnet Failover Clustering
- Programming Enhancements including sequences, ad-hoc query paging and full-text search tweaks
- BI and Web Development Environment Improvements
- Web-based Visualization
- Data Quality Services enhanced
You can view the detailed review here : New Features Of Denali
"Denali" is a code name. Here is the list of the code name of other versions of SQL Server:
- 1993 – SQL Server 4.21 for Windows NT
- 1995 – SQL Server 6.0, codenamed SQL95
- 1996 – SQL Server 6.5, codenamed Hydra
- 1999 – SQL Server 7.0, codenamed Sphinx
- 1999 – SQL Server 7.0 OLAP, codenamed Plato
- 2000 – SQL Server 2000 32-bit, codenamed Shiloh (version 8.0)
- 2003 – SQL Server 2000 64-bit, codenamed Liberty
- 2005 – SQL Server 2005, codenamed Yukon (version 9.0)
- 2008 – SQL Server 2008, codenamed Katmai (version 10.0)
- 2010 – SQL Server 2008 R2, Codenamed Kilimanjaro (aka KJ)
- 2011 – SQL Server 2012, Codenamed Denali
AlwaysOn High Availability and Disaster Recovery
If you're interested in the extra disaster recovery stuff that is included with Denali, there was a useful series of articles on Microsoft's CSS blog:
http://blogs.msdn.com/b/psssql/archive/tags/alwayson/
Additional resources:
- SQL Server AlwaysOn Team Blog
- Brent Ozar's introduction to AlwaysOn
LAG and LEAD (Blog article) and the other OVER clause (MSDN) stuff.
And these blog articles cover most of them