SQL Server on Azure Virtual Machines: A hands-on guide to provisioning Microsoft SQL Server on Azure VMs

主要特點

• 了解在Azure中SQL Server的平台可用性


• 探索SQL IaaS提供的好處和部署選擇


• 熟悉在Linux開發生態系統上部署SQL Server

書籍描述

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

通過閱讀本書，您將能夠熟練管理Microsoft Azure上的SQL Server，並利用所需的部署工具。

您將學到什麼

• 為Azure虛擬機上的SQL Server選擇操作系統


• 使用Azure管理門戶來促進部署過程


• 驗證雲端連接性和網絡延遲


• 配置存儲以實現最佳性能和連接性


• 探索Azure中SQL Server的各種災難恢復選項


• 優化Linux上的SQL Server


• 瞭解如何將數據庫備份到URL

本書適合對象

如果您是開發人員、數據愛好者或任何想要將SQL Server數據庫遷移到Azure虛擬機的人，本書適合您。對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 年的工作經驗，曾在財富 500 強和較小的公司工作。他在數據庫平台和雲技術方面有豐富的經驗，專注於性能調優、基礎設施和災難恢復。

Louis Davidson 是 CBN 的數據架構師，遠程工作多年，從田納西州的克利夫蘭（聽起來並不像它聽起來那麼迷人）工作。Louis 在過去 20 年中撰寫和貢獻了許多關於 SQL Server 主題的書籍。他最著名的作品是他於 2016 年為 Apress 出版的《Pro SQL Server 關聯數據庫設計和實施》的五個版本，新版本將於 2020 年問世。Louis 曾在許多 SQL Saturday 活動中擔任講者，並協助組織了田納西州的納什維爾和查塔努加的活動。

SQLHA, LLC 的創始人、顧問、培訓師、作者和業務連續性、基礎設施和虛擬化專家 Allan Hirt 自 1992 年開始使用 SQL Server，當時它還是 Sybase 的產品，並且自 20 世紀 90 年代末的 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 和用戶組上發表演講。您還可以在 Twitter 上找到 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. SQL介紹


2. 在Azure虛擬機中開始使用SQL Server


3. SQL Server在Azure虛擬機上的英雄功能


4. 在Azure虛擬機上的Linux中運行SQL Server


5. 性能


6. 將工作負載遷移到Azure虛擬機中的SQL Server


7. 混合場景