Professional Azure SQL Database Administration

Professional Azure SQL Database Administration

by Gethyn Ellis
Released September 2018
Publisher(s): Packt Publishing
ISBN: 9781789535495

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Video description

Azure SQL Database is the cloud version of SQL Server. It differs in terms of management, maintenance and administration. It’s important to know how to administer SQL Database so that you can get the most out of the features that it provides. You will learn different management aspects of an Azure SQL Database, such as migration, backup and restoration, pricing, security, scalability, monitoring and performance optimization, high availability and disaster recovery. You’ll start by understanding the architecture of the Azure SQL Database and its service tiers. Through a narrative of a DBA, who is migrating from a traditional on-premises system to Azure SQL Database, this course will explain the concepts by using different scenarios you might come across while working with Azure SQL Database. If you are interested in developing new or migrating existing applications with Azure SQL Database, then this course is for you.

What You Will Learn

  • Build a new Azure SQL Database or migrate to it from an on-premise SQL Database
  • Backup, restore, secure, and scale an Azure SQL Database[*] Monitor and tune an Azure SQL Database
  • Implement the high availability and disaster recovery features
  • Automate common management tasks with PowerShell
  • Develop a scalable cloud solution with SQL Database

Audience

This course is designed for database administrators, database developers, and application developers, who want to develop applications with Azure SQL Database, or migrate from their old applications. To gain maximum benefits from this course, you should have prior experience of working on an on-premises SQL Server and you know PowerShell and C#.

About The Author

Gethyn Ellis: Gethyn Ellis has over eighteen years of experience with SQL Server and for past ten years he has been working on Azure. He is an Microsoft certified trainer. He also trains and is a consultant for SQL Server. Prior to this he has worked with Packt and written books on "Getting Started SQL Server 2014 Administration" , "Microsoft Azure laaS Essentials", and Professional Azure SQL Database Administration.

Table of contents

  1. Chapter 1 : Functional Programming and Lazy Operations
    1. Introduction
    2. Installation and Setup
    3. Course Overview
    4. Microsoft Azure SQL Database Primer
    5. Azure SQL Database Architecture
    6. Database Request Flow and Provisioning
    7. Creating, Connecting and Querying the Database from the Azure Portal
    8. Deleting Resources
    9. Differences between Azure SQL Database and SQL Server
    10. Unsupported Features
    11. Summary
  2. Chapter 2 : Migrating a SQL Server Database to an Azure SQL Database
    1. Lesson Overview
    2. Migration Methodology
    3. Azure SQL Database Service Tiers
    4. Determining an Appropriate Service Tier
    5. Determining Compatibility Issues
    6. Determining the Migration Method
    7. Summary
  3. Chapter 3 : Backing up the Azure SQL Database
    1. Lesson Overview
    2. Automatic Backups
    3. Manual Backups
    4. DACPAC and BACPAC
    5. Summary
  4. Chapter 4 : Restoring an Azure SQL Database
    1. Lesson Introduction
    2. Restore Types
    3. Restore Databases
    4. Summary
  5. Chapter 5 : Securing an Azure SQL Database
    1. Lesson Introduction
    2. Access Control
    3. Restore Databases
    4. SQL Authentication and Azure Active Directory
    5. Row Level Security
    6. Dynamic Data Masking
    7. Proactive Security
    8. Summary
  6. Chapter 6 : Scaling out Azure SQL Database
    1. Lesson Introduction
    2. Vertical Scaling
    3. Horizontal Scaling
    4. Data Dependent Routing
    5. Creating Shards part 1
    6. Creating Shards part 2
    7. Creating Shards part 3
    8. Summary
  7. Chapter 7 : Elastic Pools
    1. Lesson Introduction
    2. Elastic Pools
    3. Elastic Database Transaction Units
    4. Sizing Best Practices
    5. Elastic Jobs
    6. Elastic Job Workflow
    7. Summary
  8. Chapter 8 : High Availability and Disaster Recovery
    1. Lesson Introduction
    2. High Availability
    3. Disaster Recovery
    4. Auto Failover Groups
    5. Configuring Active Geo-Replication
    6. Configuring Auto Failover Group
    7. Summary
  9. Chapter 9 : Monitoring and Tuning Azure SQL Database
    1. Lesson Introduction
    2. Monitoring an Azure SQL Database Using the Azure Portal
    3. Database Size
    4. Using DMVs
    5. Monitoring Connections and Query Performance
    6. Monitoring Blocking
    7. Tuning an Azure SQL Database
    8. In-Memory Technologies
    9. Summary

Product information

  • Title: Professional Azure SQL Database Administration
  • Author(s): Gethyn Ellis
  • Release date: September 2018
  • Publisher(s): Packt Publishing
  • ISBN: 9781789535495