SQL Server 2016 integration with Microsoft’s own Azure Service is essential these days. SQL Server 2016 introduces Simplicity with new tools that make SQL Server migration to Microsoft Azure and hybrid scenarios even easier. It also aims to provide users a consistent experience while switching from on-premises to Microsoft Azure IaaS (Infrastructure as a Service) & PaaS (Platform as a Service).
Note: If you buy something from our links, we might earn a commission. See our disclosure statement.
In my previous blog posts, I have already spoken about Security Features, Performance Enhancements, Business Intelligence Features and SQL High Availability enhancements which you can read about.
As the name says, you can Stretch operational tables in a secure manner into Azure for lower TCO and a cost effective historic data availability. You can also make use of the new security features like Always Encrypted and Row Level Security.
The Power BI Team provides you connectors which uses the REST API to do interactive query with an On-Premises Analysis Services. You do not need to open additional settings and the customer data can still stay behind your firewall.
With the introduction of the Enterprise Gateway, you can connect to both Tabular & Multi-Dimensional Data Models.
You now get native Azure Data Factory (ADF) integration with SSIS (Integration Services) and can connect SSIS to a cloud data source.
Faster restore times and 50% reduction in storage, support larger DBs with Block blobs and custom backup schedule with local staging capability is added.
There are several smaller features that might not be in this post, you can visit the Microsoft Official Blog to know more.
Comments are closed.