Users who purchase one of the Microsoft SQL Server 2012 CALs gain access to a mature and powerful software solution. Through consistent further developments over the years, these editions of the relational database management system are free of all teething troubles and at the same time extremely user-friendly.
Microsoft SQL Server 2012 CALs: The central features of the software solution
- Close connection to Azure
- Performance optimizations in almost all areas
- Simplified operation
- Improvement of the programming interface T-SQL
- "Always On" as a solution for emergencies and high availability
- Extensive security features such as encryption capabilities
The Microsoft SQL Server 2012 CALs were codenamed "Denali" during the development phase and were finally introduced to the public in March 2012. It was clear from the start that numerous innovations were to be expected. Microsoft had built up its own cloud structure with Azure, which had already been introduced in the direct predecessor version "SQL Azure", but was not yet able to fully convince here. In addition, many functions still originated from SQL Server 2008 and were very dusty. The entire system had to be comprehensively modernized.
New editions for SQL Server 2012
This is what the developers did. Some of the modernizations can already be recognized visually by the names. For example, users who buy one of the Microsoft SQL Server 2012 CALs can no longer opt for a Datacenter edition. This one has been renamed "Enterprise" and is packed with features for everyday enterprise use. Moving into the middle position between "Standard" and "Enterprise" is the brand new "Business Intelligence" edition, which is aimed at small and medium-sized businesses and the self-employed.
The most important innovations
The Microsoft SQL Server 2012 CALs have been comprehensively dusted off and optimized in almost all areas. For example, the operation has been noticeably simplified. The developers adopted some design concepts from Windows and Office, which makes the software much more intuitive to use. The Azure cloud was connected much more closely than before. This made it possible to integrate the "Always On" system, which guarantees high availability of data and can recover lost information in an emergency.
There have also been significant improvements in security. For example, data records can be fully encrypted to prevent unauthorized access. Strong security measures can be at the expense of performance. To prevent this, Microsoft has developed the "xVelocity" program, which ensures maximum performance. This is particularly noticeable, for example, in interaction with the Office application Sharepoint.
Until SQL Server 2012, there was a programming interface in the form of T-SQL. However, this was treated somewhat stepmotherly. This has changed drastically: Users who purchase one of the Microsoft SQL Server 2012 CALs will find a host of new features for the interface. It also means that sophisticated development work can now finally be done.
Licensing of the Microsoft SQL Server 2012 CALs
Users who purchase one of the Microsoft SQL Server 2012 CALs usually purchase a license that depends on the processor cores they are using. This is advantageous, for example, for users who want to purchase multiple licenses and run them individually on virtual machines. The software solution is available in a version for 32-bit and 64-bit processors.