Enterprise TechSQL SQL Server 2016 Cloud Integration February 26, 2016782 views0 Share SQL Server 2016 Cloud Integration 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). 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. Hybrid solutions Stretch Database 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. Power BI with on-premises data 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. Hybrid Scenarios with SSIS You now get native Azure Data Factory (ADF) integration with SSIS (Integration Services) and can connect SSIS to a cloud data source. You can use ADF to orchestrate SSIS execution on-premises. Developers can move data from on-Premise to Azure BLOB’s using the Azure Storage Connector Developers can trigger Azure HDInsight jobs directly from SSIS in 2016 release. Enhanced Backup to Azure Faster restore times and 50% reduction in storage, support larger DBs with Block blobs and custom backup schedule with local staging capability is added. You now have Granular control of the backup scheduling. Local staging support for faster recovery and resilient to transient network issues. You can now take backup of system databases. Support simple recovery mode. Easy migration of on-premises SQL Server Simplified point and click migration to Azure Services. Simplified “Add Azure Replica Wizard” than SLQ 2014. Automatic listener configuration for AlwaysOn in Azure VMs, without any manual configuration. There are several smaller features that might not be in this post, you can visit the Microsoft Official Blog to know more. Disclaimer: The Questions and Answers provided on https://www.gigxp.com are for general information purposes only. We make no representations or warranties of any kind, express or implied, about the completeness, accuracy, reliability, suitability or availability with respect to the website or the information, products, services, or related graphics contained on the website for any purpose. Share What's your reaction? Excited 0 Happy 0 In Love 0 Not Sure 0 Silly 0 IG Website Twitter
TSQL How to Effectively split a string using STRING_SPLIT function in SQL server By DataGeekApril 15, 2019
Enterprise Tech How to use Azure Ad Join on Windows Server 2019? & Gateway Access Just like Microsoft Windows 10, the Microsoft Server 2019 also lets you make use of ...
Enterprise Tech What is VMware VMotion? Limitations & Requirements – Storage & Shared If you are in the IT industry, especially infrastructure professionals, you may have heard the ...
Cloud Computing Differences Between VMWare SRM Standard and Enterprise Licensing Disaster Management is one of the essential aspects of any virtualization technique. VMWare, being one ...
Enterprise Tech Cisco WebEx vs Skype for Business: Differences and Comparisons The workforce today has become completely mobile. With that change in the work strategy, the ...