SQL Server on Azure Virtual Machines: A hands-on guide to provisioning Microsoft SQL Server on Azure VMs
暫譯: 在 Azure 虛擬機上使用 SQL Server：Microsoft SQL Server 在 Azure 虛擬機上配置的實作指南

#### 主要特點

- 了解 Azure 中 SQL Server 的平台可用性
- 探索 SQL IaaS 提供的好處和部署選擇
- 熟悉在 Linux 開發生態系統中部署 SQL Server

#### 書籍描述

在 Azure 虛擬機上部署 SQL Server 使您能夠在雲端使用完整版本的 SQL Server，而無需維護本地硬體。本書首先介紹 Azure 中的 SQL 產品組合，然後帶您了解 SQL Server IaaS 的場景，接著解釋在 Azure 虛擬機中選擇 SQL Server 作業系統時需要考慮的因素。隨著您逐步深入本書，您將探索不同的虛擬機選項和 IaaS 的部署選擇，並了解平台可用性、遷移工具和 Azure 中的最佳實踐。在後面的章節中，您將學習如何配置存儲以實現最佳性能。最後，您將熟悉 Azure Hybrid Benefit 的概念，並了解如何利用它來最大化您現有本地 SQL Server 的價值。

在本書結束時，您將能夠熟練管理 Microsoft Azure 上的 SQL Server，並利用所需的工具進行部署。

#### 您將學到的內容

- 為 Azure 虛擬機選擇作業系統
- 使用 Azure 管理入口網站來促進部署過程
- 驗證雲端中的連接性和網路延遲
- 配置存儲以實現最佳性能和連接性
- 探索 Azure 中 SQL Server 的各種災難恢復選項
- 優化 Linux 上的 SQL Server
- 發現如何將資料庫備份到 URL

#### 本書適合誰

如果您是開發人員、數據愛好者或任何希望將 SQL Server 資料庫遷移到 Azure 虛擬機的人，則 SQL Server on Azure VMs 將非常適合您。對 SQL Server 和 Azure 資源的受管理身份有基本的了解將是加分項。

Joseph D'Antoni is a Principal Consultant at Denny Cherry and Associates Consulting. He is recognized as a VMWare vExpert and a Microsoft Data Platform MVP and has over 20 years of experience working in both Fortune 500 and smaller firms. He has worked extensively on database platforms and cloud technologies and has specific expertise in performance tuning, infrastructure, and disaster recovery.

Louis Davidson is a data architect for CBN in Virginia Beach, VA; telecommuting for many years from Cleveland, TN (which is not even as glamourous as it sounds.) Louis has written and contributed to many books on SQL Server topics over the past 20 years. His most prominent work has been five editions of his book entitled: ""Pro SQL Server Relational Database Design and Implementation"" for Apress in 2016, with a new version forthcoming in 2020. Louis has been a speaker at many SQL Saturday events, and has helped organize events in Nashville and Chattanooga, TN.

SQLHA, LLC founder, consultant, trainer, author, and business continuity, infrastructure, and virtualization expert Allan Hirt has been working with SQL Server since 1992 when it was still a Sybase product as well as clustering in Windows Server since the late 1990s when it was known as Wolfpack. Currently a dual Microsoft MVP (Data Platform; Cloud and Datacenter Management) as well as a VMware vExpert, Allan works with all sizes of customers no matter if they are on premises or in the public cloud and delivers training and speaks at events over the world.

John is an experienced data platform professional having spent over a decade working with the Microsoft data and cloud platform technologies. In this time John has learned how to get the most out of these platforms as well as the key pitfalls that should be avoided.

Anthony Nocentino is the Founder and President of Centino Systems as well as a Pluralsight author and a Microsoft Data Platform MVP, Linux Expert, and Corporate Problem Solver. Anthony designs solutions, deploys the technology, and provides expertise on system performance, architecture, and security. Anthony has a Bachelors and Masters in Computer Science with research publications in high performance/low latency data access algorithms and spatial database systems. You can find him on Twitter @nocentino.

Tim is a Data Platform MVP. He has presented at PASS, SQLintersection, Microsoft Ignite, SQL Saturdays, user groups and numerous webinars. In addition, Tim runs the Columbus GA SQL Users Group, is a PASS Regional Mentor and was named a PASS Outstanding Volunteer. He's married with three children and has a passion for electronics. He also farms chickens, crops, and tilapias in his spare time.

Randolph West, founder of Born SQL, is an independent IT consultant, speaker, Calgary PASS user group leader, Microsoft Data Platform MVP, and lead author of the book SQL Server 2019 Administration Inside Out. Randolph specializes in SQL Server performance tuning, disaster recovery, and migrations from really old versions, with an emphasis on implementing best practices. Randolph has presented at PASS Summit, SQLBits, SQL Saturdays, and user groups. You can also find Randolph acting and directing on screen or the stage, or annoying people on Twitter. Do not trust Randolph around chocolate.

Joseph D'Antoni 是 Denny Cherry and Associates Consulting 的首席顧問。他被認可為 VMWare vExpert 和 Microsoft Data Platform MVP，擁有超過 20 年在 Fortune 500 及小型企業工作的經驗。他在資料庫平台和雲端技術方面有廣泛的工作經驗，並在性能調優、基礎設施和災難恢復方面具有專業知識。

Louis Davidson 是位於維吉尼亞海灘的 CBN 的資料架構師；多年來從田納西州克里夫蘭遠端工作（其實並沒有聽起來那麼光鮮亮麗）。在過去的 20 年中，Louis 撰寫並貢獻了許多有關 SQL Server 主題的書籍。他最著名的作品是 2016 年為 Apress 出版的《Pro SQL Server Relational Database Design and Implementation》的五個版本，並計劃在 2020 年推出新版本。Louis 曾在許多 SQL Saturday 活動中擔任演講者，並協助在田納西州納什維爾和查塔努加組織活動。

SQLHA, LLC 的創始人、顧問、培訓師、作者以及業務連續性、基礎設施和虛擬化專家 Allan Hirt 自 1992 年以來一直在使用 SQL Server，當時它仍然是 Sybase 的產品，並且自 1990 年代末以來在 Windows Server 中進行叢集，當時稱為 Wolfpack。目前，Allan 是雙重 Microsoft MVP（資料平台；雲端和資料中心管理）以及 VMware vExpert，無論客戶的規模如何，他都與所有客戶合作，無論是在本地還是在公共雲中，並在全球各地提供培訓和演講。

John 是一位經驗豐富的資料平台專業人士，擁有超過十年的 Microsoft 資料和雲端平台技術工作經驗。在這段時間裡，John 學會了如何充分利用這些平台以及應避免的關鍵陷阱。

Anthony Nocentino 是 Centino Systems 的創始人和總裁，也是 Pluralsight 的作者和 Microsoft Data Platform MVP、Linux 專家及企業問題解決者。Anthony 設計解決方案、部署技術，並提供系統性能、架構和安全性的專業知識。Anthony 擁有計算機科學的學士和碩士學位，並在高性能/低延遲資料存取演算法和空間資料庫系統方面有研究出版物。您可以在 Twitter 上找到他 @nocentino。

Tim 是一位資料平台 MVP。他曾在 PASS、SQLintersection、Microsoft Ignite、SQL Saturdays、用戶組和許多網路研討會上發表演講。此外，Tim 還運營哥倫布 GA SQL 用戶組，是 PASS 區域導師，並被評為 PASS 傑出志工。他已婚，有三個孩子，對電子產品充滿熱情。在空閒時間，他還養雞、種作物和養殖非洲鯛。

Randolph West 是 Born SQL 的創始人，是一位獨立 IT 顧問、演講者、卡爾加里 PASS 用戶組領導者、Microsoft Data Platform MVP，以及書籍《SQL Server 2019 Administration Inside Out》的主編。Randolph 專注於 SQL Server 性能調優、災難恢復和從非常舊的版本進行遷移，強調實施最佳實踐。Randolph 曾在 PASS Summit、SQLBits、SQL Saturdays 和用戶組中發表演講。您還可以在螢幕或舞台上看到 Randolph 演出和導演，或者在 Twitter 上惹人厭。不要在巧克力附近相信 Randolph。

1. Introduction to SQL
2. Getting started with SQL Server in Azure VMs
3. Hero capabilities for SQL Server on Azure VMs
4. SQL Server on Linux in Azure VMs
5. Performance
6. Moving workloads to SQL Server in Azure VMs
7. Hybrid scenarios

1. Introduction to SQL


2. Getting started with SQL Server in Azure VMs


3. Hero capabilities for SQL Server on Azure VMs


4. SQL Server on Linux in Azure VMs


5. Performance


6. Moving workloads to SQL Server in Azure VMs


7. Hybrid scenarios