Table of Contents
Note: If you buy something from our links, we might earn a commission. See our disclosure statement.
I have already written about SQL Internals improvements on a different post. With SQL Server 2016, Microsoft has continued to invest in three major areas. They have continued to evolve the product on mission critical performance, with SQL Server 2014. Microsoft began to take the lead away from Tier 1 vendors & (Like Oracle, SAP) competitors with in-memory technology built-in. This release (SQL 2016) has further added new innovations across many mission critical components. With investments on data insights, significant investment both on premises and complimentary services via Azure has added to help you gain deeper insights across your data. Finally Microsoft is adding new hybrid capabilities that will compliment your on-prem investments and give you the ability to take advantage of Microsoft’s hyperscale Azure cloud.
You can now Load balance Always On availability groups for Mission Critical Operational Workloads typically configured for High Availability.You can offload analytics to readable secondary replica
You can now Load balance Always On availability groups for Mission Critical Operational Workloads typically configured for High Availability.
You can offload analytics to readable secondary replica
Setup MARS connection for memory optimized tables using the MultipleActiveResultsSets=True in your connection string
Management Data Warehouse (MDW) is now depreciated and now has been replaced with lightweight reports available in SSMS without setting up MDW.
With Query Store you can:
Here is the management dashboard
Query back in time
You can query point in time:SELECT * FROM Department FOR SYSTEM_TIMEAS OF ‘2006.01.01’
You can query point in time:
SELECT * FROM Department FOR SYSTEM_TIME
AS OF ‘2006.01.01’
In the next post, I will talk about the security enhancements in SQL Server 2016.
Comments are closed.