- Professional Azure SQL Database Administration
- Table of Contents
- Professional Azure SQL Database Administration
- Contributors
- Preface
- 1. 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
- Activity: Provisioning Azure SQL Server and SQL Database using PowerShell
- Summary
- Azure SQL Database Architecture
- 2. 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
- Determining an Appropriate Service Tier
- Determining Compatibility Issues
- Determining the Migration Method
- Summary
- 3. Backing Up the Azure SQL Database
- 4. Restoring an Azure SQL Database
- 5. 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
- Using Active Directory – Password to Authenticate to an Azure SQL Database
- Azure SQL Database Authentication Structure
- Authorization
- Creating Contained Database Users for Azure AD Authentication
- Groups and Roles
- Row-Level Security
- Dynamic Data Masking
- Proactive Security
- Summary
- Access Control
- 6. Scaling Out Azure SQL Database
- 7. Elastic Pools
- 8. High Availability and Disaster Recovery
- High Availability
- Disaster Recovery
- Summary
- 9. Monitoring and Tuning Azure SQL Database
- Monitoring an Azure SQL Database using the Azure Portal
- Tuning an Azure SQL Database
- Summary
- Index
Migrating to an Azure SQL Database is an important task and should be planned to perfection. This chapter talked about a migration strategy that you should follow when migrating from an on-premises database to an Azure SQL Database:
- Find the migration benefits.
- Find the blockers.
- Select a service model.
- Select a service tier.
- Select the main and disaster recovery region.
- Select a migration tool.
This chapter also talked about how to choose a service tier and covered different migration tools to migrate the data and the schema from an On-Premies SQL Server Database to an Azure SQL Database.
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.