As already reported on several blogs, this week was launched publicly CTP1 SQL Server 11 with the Codename “Denali. ”
It is important to remember that SQL Server 11 does not mean SQL Server 2011 seconds Randal Paul himself said via twitter. SQL Server means that 11 is the 11th edition of SQL Server, and SQL Server 2005 is version 9 and SQL Server 2008 is version 10. Thus, it does not mean that he must be released in 2011, may be so or maybe not. I have not read anything about a possible release date.
Well, many of you, like me, should be wondering: … another version of SQL Server coming and I still have MUCH to learn SQL Server 2008 and SQL Server 2008 R2. No way guys, this is the life of an IT professional, we have to always update to not get overtaken in the market, we will live with a constant learning by the end of our careers.
Thou it how the new features work, such as:
SQL Server AlwaysOn
- The new SQL Server AlwaysOn will provide a set of capabilities to help businesses maximize uptime of their mission critical applications, simplify high availability deployments and provide better returns on hardware investments. AlwaysOn supports multi-site clustering and the new availability group option will help improve availability of databases by supporting multiple secondaries, increase utilization using active secondary and simplify HA management. In addition, Windows Server Core support will help significantly reduce planned downtime related to OS patching due to fewer patch requirements and reboots.
Column-based query accelerator
- 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.