eBooks/eGuides

An-easier-path-to-the-cloud-for-your-legacy-SQL-Server-data

Issue link: https://insights.oneneck.com/i/1171388

Contents of this Issue

Navigation

Page 3 of 14

02 Microsoft Azure provides the ideal cloud destination for data modernization. You can use the latest SQL Server engine and the power of Azure to help ensure reliability, security, and high performance. Upgrading to Azure brings advanced features and functionality to make your life a lot easier, including: Enhanced performance, availability, and security Cloud readiness and scalability Management and programmability Business intelligence, advanced analytics, and artificial intelligence (AI) Various options are available on Azure for modernizing on-premises SQL Server databases across organizational requirements and use cases: Azure SQL Database with a single database, Azure SQL Database with elastic pools, SQL Server on Azure Virtual Machines (infrastructure as a service, or IaaS), and Azure SQL Database Managed Instance. Table 1 describes our focus in more detail. Chapter 02 Why Azure? 02 Why Azure? 02 Table 1: Azure SQL Database Managed Instance platform usage scenario Target platform Do not own the application code, or expensive to modify Require high level of compatibility Use feature(s) of SQL Server not yet supported by Azure SQL Database Rich instance-centric programming model Nearly 100 percent compatibility Resource guaranteed/SLA at the instance level Azure VNet isolation Fully managed services while retaining high level of compatibility with SQL Server Support for SQL features such as cross-database queries, which are unavailable in Azure SQL Database Reduced OPEX/CAPEX Dynamic scale Advanced security Intelligent database self-tuning Azure SQL Database Managed Instance Use cases Platform delivers Value Unique benefits

Articles in this issue

Archives of this issue

view archives of eBooks/eGuides - An-easier-path-to-the-cloud-for-your-legacy-SQL-Server-data