Professional azure SQL database administration : equip yourself with the skills you need to manage and maintain your SQL databases on the microsoft cloud / Ahmad Osama.

Format:

Book

Author/Creator:

Osama, Ahmad, author.

Language:

English

Subjects (All):

SQL server.

Database management.

Physical Description:

1 online resource (398 pages) : illustrations

Edition:

1st edition

Place of Publication:

Birmingham ; Mumbai : Packt, 2018.

System Details:

text file

Biography/History:

Osama Ahmad: Ahmad Osama works for Pitney Bowes Pvt. Ltd. as a technical architect and is a former Microsoft Data Platform MVP. In his day job, he works on developing and maintaining high performant, on-premises and cloud SQL Server OLTP environments as well as deployment and automating tasks using PowerShell. When not working, Ahmad blogs at DataPlatformLabs and can be found glued to his Xbox.

Summary:

Discover how you can migrate a traditional on-premise SQL server database to a cloud-based solution with Microsoft Azure. Built with database administrators in mind, this book emulates different scenarios you might come across while working with large, complex SQL database migrations and provides solutions for effectively managing the migrated databases. Key Features Implement backup, restore, and recovery of Azure SQL databases Create shards and elastic pools to scale Azure SQL databases Automate common management tasks with PowerShell Implement over 40 practical activities and exercises across 24 topics to reinforce your learning Book Description As the cloud version of SQL Server, Azure SQL Database differs in key ways when it comes to management, maintenance, and administration. It's important to know how to administer SQL Database to fully benefit from all of the features and functionality that it provides. This book addresses important aspects of an Azure SQL Database instance such as migration, backup restorations, pricing policies, security, scalability, monitoring, performance optimization, high availability, and disaster recovery. It is a complete guide for database administrators, and ideal for those who are planning to migrate from on premise SQL Server database to an Azure SQL Server database. What you will learn Learn how to provision a new database or migrate an existing on-premise solution Understand how to backup, restore, secure, and scale your own Azure SQL Database Optimize the performance by monitoring and tuning your cloud-based SQL instance Implement high availability and disaster recovery procedures with SQL Database Develop a roadmap for your own scalable cloud solution with Azure SQL Database Who this book is for This book is ideal for database administrators, database developers, or application developers who are interested in developing or migrating existing applications with Azure SQL Database. Prior experience of working with an on-premise SQL Server deployment and brief knowledge of PowerShell and C# are recommended prerequisites.

Contents:

Intro

Preface

Microsoft Azure SQL Database Primer

Azure SQL Database Architecture

Azure SQL Database Request Flow

Provisioning an Azure SQL Database

Connecting and Querying the SQL Database from the Azure Portal

Connecting and Querying the SQL Database from SQL Server Management Studio

Deleting Resources

Differences between Azure SQL Database and SQL Server

Unsupported Features

Activity: Provisioning Azure SQL Server and SQL Database using PowerShell

Summary

Migrating a SQL Server Database to an Azure SQL Database

Finding the Migration Benefits

Finding the Blockers

Selecting a Service Model

Selecting a Service Tier

Selecting the Main and Disaster Recovery Region

Selecting a Migration Tool

Azure SQL Database Service Tiers

Basic Service Tier

Standard Service Tier

Premium Service Tier

Premium RS Service Tier

Database Transaction Units

Scaling up the Azure SQL Database Service Tier

Changing a Service Tier

Determining an Appropriate Service Tier

Azure SQL Database DTU Calculator

Finding an Initial Service Tier for the Database to be Migrated using the DTU Calculator

Determining Compatibility Issues

Data Migration Assistant

SQL Server Data Tools for Visual Studio

SQL Server Management Studio

SQLPackage.exe

SQL Azure Migration Wizard

Determining the Migration Method

Migrating the On-Premises SQL Server Database to Azure SQL Database

Activity: Using Data Migration Assistant

Activity: Performing Transactional Replication

Backing Up the Azure SQL Database

Automatic Backups

Backup Storage

Backup Retention Period

Configuring Long-Term Backup Retention for Azure SQL Database

Manual Backups

Backing up the Azure SQL Database using SSMS

DACPAC and BACPAC

Manual versus Automated Backups.

Activity: Perform Back-ups

Restoring an Azure SQL Database

Restore Types

Point-In-Time Restore

Long-Term Database Restore

Restoring Deleted Databases

Geo-Restore Database

Importing a Database

Activity: Perform PITR

Activity: Perform Geo-Restore

Securing an Azure SQL Database

Access Control

Firewall Rules

Managing the Server-Level Firewall Rules using the Azure Portal

Managing the Server-Level Firewall Rules using Transact-SQL

Managing Database-Level Firewall Rules using Transact-SQL

Authentication

SQL Authentication

Azure Active Directory Authentication

Using Active Directory - Password to Authenticate to an Azure SQL Database

Azure SQL Database Authentication Structure

Azure SQL Database Authentication Considerations

Authorization

Creating Contained Database Users for Azure AD Authentication

Groups and Roles

Row-Level Security

Dynamic Data Masking

Proactive Security

Auditing

Configure Auditing for Azure SQL Server

Threat Detection

Configure Threat Detection for Azure SQL Server

Activity: Implement Row-Level Security

Activity: Implement Dynamic Data Masking

Scaling Out Azure SQL Database

Vertical Scaling

Scale Up or Scale Down Service Tiers

Using T-SQL to Change the Service Tier

Vertical Partitioning

Horizontal Scaling

Shard Map Manager

Data Dependent Routing

Multi-Tenant Data Models

Single Tenant (database-per-tenant)

Shared Database - Sharded

Activity: Creating Alerts

Activity: Creating Shards

Activity: Split Data between Shard

Activity: Using Elastic Queries

Elastic Pools

Introducing Elastic Pools

When Should You Consider Elastic Pools?

Sizing an Elastic Pool

Comparing the Pricing

Sizing Best Practices.

Create an Elastic Pool and Add Toystore Store Shards to the Elastic Pool

Elastic Jobs

Use Cases

Architecture

Elastic Job Workflow

Create an Elastic Job using the Azure Portal

Activity: Exploring Elastic Pools

High Availability and Disaster Recovery

High Availability

Disaster Recovery

Standard Geo-Replication

Database Failover

Active Geo-Replication

Synchronous Replication

Auto-Failover Groups

Auto-Failover Group Terms

Configuring Active Geo-Replication and Performing a Manual Failover

Configuring the Auto-Failover Group

Activity: Configure Active Geo-Replication

Activity: Configure Auto-Failover Groups

Monitoring and Tuning Azure SQL Database

Monitoring an Azure SQL Database using the Azure Portal

Monitoring Database Metrics

Alert Rules, Database Size, and Diagnostic Settings

Alert Rules

Database Size

Diagnostic Settings

Query Performance Insight

Monitor Queries using the Query Performance Insight Blade

Monitoring an Azure SQL Database using DMVs

Monitoring Connections

Monitoring Query Performance

Monitoring Blocking

Extended Events

Examining Queries

Tuning an Azure SQL Database

Automatic Tuning

Create Index

Drop Indexes

Force Last Good Plan

In-Memory Technologies

In-Memory OLTP

Columnstore Indexes

Activity: Explore the In-Memory OLTP Feature

Index.

Notes:

Includes index.

Description based on print version record.

ISBN:

9781789535679

1789535670

OCLC:

1048801205