Microsoft's SQL server 2012 is out with many new features added. It is bundled with significant development milestones, enabling developers and organizations to utilize full value of relational database.
If you still haven’t got a chance to put your hands on SQL server 2012, the Release Candidate 0 is available for download here. Microsoft has incorporated all the feedback and suggestions from the users of SQL Server 2012 CTP, so that the Release Candidate will deliver high-quality performance.
What's new in SQL Server 2012 RC0?
- Data protection with ‘AlwaysOn’ feature deliver greater availability of on-time resources for organizations to extent data across cloud and take timely decisions.
- Fast performance by predictable resource allocation and greater CPU control.
- New reporting and data visualization tools like Power View for rapid data exploration and presentation.
- Supporting heterogeneous data in data warehouses through new changed data capture support for Oracle, thus leading to consistency in data.
- Enhancements like File tables, statistical semantic search etc adds a lot of scope in the programming perspective.
The new Release Candidate is a production quality one with access to migration tools like Upgrade Advisor, SSMA etc. Further details can be accessed from the tutorials for SQL Server 2012 Release Candidate (RC0).
SQL Server 2012 is available in 3 different editions like Standard, Business Intelligence (new) and Enterprise. All these editions have the AlwaysOn feature enabled. This gives the organizations and the developers a better control on the database resources when changes are made, log files are updated etc. Microsoft SQL Server 2012 RC 0 Release Notes will give you full details regarding the installation, pre-requisites, and all the technical documentation required to make you comfortable with Microsoft SQL Server 2012 RC0.
postscript: Just after a week since the release of Microsoft SQL Server 2012 RC0, the team also introduced a new set of Analytic functions in SQL server 2012 RC0!
The introduction of analytic functions in SQL server 2012 RC0 came like a big relief to the relational database users. Earlier, long T-SQL code was written to simulate the complex functions but now, the new Analytic functions delivers high performance as well as readability.
Here is the list of new Analytic functions:
Microsoft has done a great work by making the complex analytic functions available as native functions which can be easily used in SQL transactions. Get yourself updated about the future releases of SQL server 2012 @ http://www.microsoft.com/sqlserver/en/us/future-editions.aspx