- Professional Azure SQL Database Administration
- Ahmad Osama
- 412字
- 2021-04-02 20:22:57
What This Book Covers
Chapter 1, Microsoft Azure SQL Database Primer, covers the fundamental architecture of Microsoft Azure SQL Database. We will provision an Azure SQL Database and learn to connect and query it. We will also discuss the differences between the on-premises SQL Server and Azure SQL Database.
Chapter 2, Migrating a SQL Server Database to an Azure SQL Database, discusses the features of the various Azure SQL Database service tiers that are available and the need for migration. We will talk about selecting the most suitable service tier, finding and fixing compatibility issues originating as a result of data migration, and selecting the most appropriate migration tool or method based on the scenario.
Chapter 3, Backing Up the Azure SQL Database, explains how to perform automatic and manual backups for Azure SQL Databases and discusses the benefits and strategies for each.
Chapter 4, Restoring an Azure SQL Database, covers the various restore options available on the Azure SQL Database. We will understand the features of each restore type, when and where they can be used, and how they are performed.
Chapter 5, Securing an Azure SQL Database, discusses various security mechanisms employable on the Azure SQL Database. We will talk about access control measures such as Firewall and Authentication and also cover proactive security measures, including Dynamic Data Masking, Auditing, and Threat Detection.
Chapter 6, Scaling Out Azure SQL Database, explains how to scale Azure SQL Databases, either vertically or horizontally, and how to shard a database. The lesson further talks about how to run cross-database queries.
Chapter 7, Elastic Pools, introduces the Elastic Pool and its benefits. We will understand how to effectively size an Elastic Pool, and will talk about the uses of Elastic Jobs, their architecture, workflow, and how to create them.
Chapter 8, High Availability and Disaster Recovery, covers the built-in High Availability feature in Azure SQL Database. This lesson also teaches you how to implement a Disaster Recovery solution using Standard and Active Geo-replication. We will also learn how to automate auto-failover groups using PowerShell.
Chapter 9, Monitoring and Tuning Azure SQL Database, describes different techniques for monitoring and tuning an Azure SQL database. We will learn how to monitor an Azure SQL Database using the Azure portal, Dynamic Management Views, and Extended Events. We will also talk about Query performance insight and about tuning an Azure SQL Database using Automatic tuning. Finally, we will learn to implement in-memory features to improve workload performance.
- Excel 數據處理與分析實例教程(第2版)
- AI圖像處理:Photoshop+Firefly后期處理技術基礎與實戰
- RESTful PHP Web Services
- Adobe創意大學Photoshop CS5 產品專家認證標準教材
- 從零開始:AutoCAD 2010中文版建筑制圖基礎培訓教程(第2版)
- 用Multisim玩轉電路仿真
- Photoshop CC入門與提高(超值版)
- Refactoring with Microsoft Visual Studio 2010
- Photoshop海報設計技巧與實戰
- Adobe創意大學Premiere Pro影視剪輯師標準實訓教材(CS6修訂版)
- Photoshop+Firefly從入門到精通
- Cinema 4D R20完全學習手冊
- 零基礎學后期:Lightroom 6-CC數碼照片處理從新手到高手
- 電磁場數值計算及基于FreeFEM的編程實現
- 中文版AutoCAD 2021完全自學教程