Azure SQL Revealed: The Next-Generation Cloud Database with AI and Microsoft Fabric

by Bob Ward

Overview

Access detailed content and examples on Azure SQL, a set of cloud services that allows for SQL Server to be deployed in the cloud. This book teaches the fundamentals of deployment, configuration, security, performance, and availability of Azure SQL from the perspective of these same tasks and capabilities in SQL Server. This distinct approach makes this book an ideal learning platform for readers familiar with SQL Server on-premises who want to migrate their skills toward providing cloud solutions to an enterprise market that is increasingly cloud-focused.

If you know SQL Server, you will love this book. You will be able to take your existing knowledge of SQL Server and translate that knowledge into the world of cloud services from the Microsoft Azure platform, and in particular into Azure SQL. This book provides information never seen before about the history and architecture of Azure SQL. Author Bob Ward is a leading expert with access to and support from the Microsoft engineering team that built Azure SQL and related database cloud services. He presents powerful, behind-the-scenes insights into the workings of one of the most popular database cloud services in the industry. This book also brings you the latest innovations for Azure SQL including Azure Arc, Hyperscale, generative AI applications, Microsoft Copilots, and integration with the Microsoft Fabric.

What You Will Learn

• Know the history of Azure SQL
• Deploy, configure, and connect to Azure SQL
• Choose the correct way to deploy SQL Server in Azure
• Migrate existing SQL Server instances to Azure SQL
• Monitor and tune Azure SQL’s performance to meet your needs
• Ensure your data and application are highly available
• Secure your data from attack and theft
• Learn the latest innovations for Azure SQL including Hyperscale
• Learn how to harness the power of AI for generative data-driven applications and Microsoft Copilots for assistance
• Learn how to integrate Azure SQL with the unified data platform, the Microsoft Fabric

Who This Book Is For

This book is designed to teach SQL Server in the Azure cloud to the SQL Server professional. Anyone who operates, manages, or develops applications for SQL Server will benefit from this book. Readers will be able to translate their current knowledge of SQL Server—especially of SQL Server 2019 and 2022—directly to Azure. This book is ideal for database professionals looking to remain relevant as their customer base moves into the cloud.

Product Details

ISBN-13:	9798868809736
Publisher:	Apress
Publication date:	10/11/2024
Edition description:	Second Edition
Pages:	534
Product dimensions:	7.01(w) x 10.00(h) x (d)

About the Author

Bob Ward is a Principal Architect for the Microsoft Azure Data team, which owns the development for Microsoft SQL Edge to Cloud. Bob has worked for Microsoft for 30+ years on every version of SQL Server shipped from OS/2 1.1 to SQL Server 2022, including Azure SQL. Bob is a well-known speaker on SQL Server and Azure SQL, often presenting talks on new releases, internals, and specialized topics at events such as SQLBits, Microsoft Build, Microsoft Ignite, PASS Summit, DevIntersection, and VS Live. You can also learn Azure SQL from him on the popular series aka.ms/azuresql4beginners. You can follow him at @bobwardms. Bob is the author of the books Pro SQL Server on Linux, SQL Server 2019 Revealed, Azure SQL Revealed 1st and 2nd Editions, and SQL Server 2022 Revealed (available from Apress Media).

Table of Contents

1. SQL Server Rises to the Clouds.- 2. What is Azure SQL?.- 3. SQL Server on Azure Virtual Machine.- 4. Deploying Azure SQL.- 5. Configuring Azure SQL.- 6. Securing Azure SQL.- 7. Monitoring and Tuning Performance for Azure SQL.- 8. Availability for Azure SQL.- 9. Using the power of AI with Azure SQL.- 10. Completing Your Knowledge of Azure SQL.- 11. Go Big with the Cloud.