Nov 10 2010
If you’re reading this then you know about SQL Server and probably already know what Denali is, but if you’re not familiar with Microsoft’s code names then this is next release after SQL Server 2008 R2. Most people think that the new release will eventually be called SQL Server 2011 with the rumour being that it will be released in the last quarter of that year.
A tentative approach at a new version of Books Online is now available and you can view it online here: Denali Books Online. This link is definitely worth bookmarking, however be warned it is by no means complete with lots of sections saying “Information_still_to_come” even with this caveat it will prove to be very exciting.
If you’re not a fan of wading through lots of reading material then click on the following link which will take you to all the exciting new stuff: Denali – What’s new
Here are a few of the things that I’ll be looking forward to in the next release:
- “HADR” which people seem to be calling HADRON is “a high-availability and disaster recovery solution introduced in SQL Server Code-Named “Denali” to enable you to maximize availability for one or more of your user databases”
- The concept of “Contained databases” this could potentially be a huge leap forward and is definitely something that I will be researching as soon as I can free up a test server. Understanding Contained Databases
- The Column-based Query Accelerator, the following is a quote from Microsoft:
”Column-Based Query Accelerator will help dramatically increase query performance ~10x and reduce performance tuning through interactive experiences with data for near instant response times and streamlined setup which removes the need to build summary aggregates.”
Sounds great can’t wait to play with this one!
- New unified developer tools (codenamed Juneau) which has undockable windows and supports dragging them onto multiple monitors, Brent Ozar (Blog|Twitter) has some great screenshots of this in his Denali post SQL Server (2011) Code Name Denali – Release Date Nov 9 2010
- New Data Management components “Data Quality Services” and “Impact Analysis and Lineage”
Remember to keep looking for more exciting news on Microsoft’s SQL Server Future Editions page here.