While the latest version SQL Server 2016 is out in the market, there are some who still use SQL Server 2014. It offers a number of improvements over SQL server 2012, including better in-memory capabilities, smooth cloud integration, and improved availability and scalability. The most talked about feature of this version was undoubtedly its OLTP engine for in-memory enhancements. In this blog, we will discuss this and some more features of SQL Server 2014.
Best Features of SQL Server 2014
SQL Server 2014 enhances memory-related capabilities in many ways. One, it doesn’t require any specialized software or hardware, smoothly works with existing transactional processes. Two, it lets you extend the buffer pool to a SSD (solid-state drive). It enables quicker paging, while minimizing risk to data since only clean pages get stored on the solid state drive. It helps OLTP operations supporting heavy loads.
SQL Server 2014 works as a hybrid cloud platform by easily integrating with Windows Azure. SQL Server 2014 also follows the concept of Smart Backups, where it determines whether differential or full backups are required and when to perform these. Users can also store data and log files of the database in Azure’s storage.
Availability & Scalability
SQL Server 2012 has some great high availability features. It now supports eight (earlier four) secondary replicas. Also, these replicas allow smooth running of read workloads even during network fails. SQL Server 2014 also offers enhanced information on diagnostics, with simplified error messages, and ease of searching and correlating details.
Along with higher availability, SQL Server 2014 also delivers greater scalability by integrating with Windows Server 2012 R2. Users can scale up 4 TB memory and 640 logical processors in a physical environment. While it comes to 1 TB of memory and 64 virtual processors in a virtual environment, which is still quite significant. Users can utilize the features of network virtualization and storage virtualization to optimize their SQL Server 2014 deployments.
All these features are explored in detail in Koenig’s Microsoft SQL Server 2014 course, which enhances knowledge and skills about the best capabilities of SQL Server 2014.