Full Description
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.
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.
