Book Image

Azure Integration Guide for Business

By : Joshua Garverick, Jack Lee, Mélony Qin, Trevoir Williams
Book Image

Azure Integration Guide for Business

By: Joshua Garverick, Jack Lee, Mélony Qin, Trevoir Williams

Overview of this book

Azure Integration Guide for Business is essential for decision makers planning to transform their business with Microsoft Azure. The Microsoft Azure cloud platform can improve the availability, scalability, and cost-efficiency of any business. The guidance in this book will help decision makers gain valuable insights into proactively managing their applications and infrastructure. You'll learn to apply best practices in Azure Virtual Network and Azure Storage design, ensuring an efficient and secure cloud infrastructure. You'll also discover how to automate Azure through Infrastructure as Code (IaC) and leverage various Azure services to support OLTP applications. Next, you’ll explore how to implement Azure offerings for event-driven architectural solutions and serverless applications. Additionally, you’ll gain in-depth knowledge on how to develop an automated, secure, and scalable solutions. Core elements of the Azure ecosystem will be discussed in the final chapters of the book, such as big data solutions, cost governance, and best practices to help you optimize your business. By the end of this book, you’ll understand what a well-architected Azure solution looks like and how to lead your organization toward a tailored Azure solution that meets your business needs.
Table of Contents (15 chapters)

OLTP in Azure

There are several Azure services that support OLTP applications, covering relational as well as non-relational data:

  • Azure SQL Database
  • Azure SQL Managed Instance
  • Azure Cosmos DB
  • Azure Database for PostgreSQL
  • Azure Database for MySQL

Azure SQL Database

Azure SQL Database provides a relational database engine hosted as PaaS. Customers can provision this service, bring their own database schema and data, and connect their applications to it. Azure SQL Database provides many of the features of SQL Server when deployed on a virtual machine. These services do not provide a user interface to create tables and schemas, nor do they provide any querying capabilities directly via the portal. SQL Server Management Studio, Azure Data Studio, or the SQL CLI and command-line tools should be used to connect to these services and directly work with them.

Azure SQL Database comes with three distinct deployment models:

  • Single instance: In this...