Pro Database Migration to Azure: Data Modernization for the Enterprise

✍ Scribed by Kevin Kline, Denis McDowell, Dustin Dorsey, Matt Gordon

• Publisher: Apress
• Year: 2022
• Tongue: English
• Leaves: 345
• Category: Library

✦ Synopsis

Migrate your existing, on-premises applications into the Microsoft Azure cloud platform. This book covers the best practices to plan, implement, and operationalize the migration of a database application from your organization’s data center to Microsoft’s Azure cloud platform.
Data modernization and migration is a technologically complex endeavor that can also be taxing from a leadership and operational standpoint. This book covers not only the technology, but also the most important aspects of organization culture, communication, and politics that so frequently derail such projects. You will learn the most important steps to ensuring a successful migration and see battle-tested wisdom from industry veterans. From executive sponsorship, to executing the migration, to the important steps following migration, you will learn how to effectively conduct future migrations and ensure that your team and your database application delivers on the expected business value of the project.
This book is unlike any other currently in the market. It takes you through the most critical business and technical considerations and workflows for moving your data and databases into the cloud, with special attention paid to those who are deploying to the Microsoft Data Platform in Azure, especially SQL Server. Although this book focuses on migrating on-premises SQL Server enterprises to hybrid or fully cloud-based Azure SQL Database and Azure SQL Managed Instances, it also cover topics involving migrating non-SQL Server database platforms such as Oracle, MySQL, and PostgreSQL applications to Microsoft Azure.
What You Will Learn

• Plan a database migration that ensures smooth project progress, optimal performance, low operating cost, and minimal downtime
• Properly analyze and manage non-technical considerations, such as legal compliance, privacy, and team execution
• Perform athorough architectural analysis to select the best Azure services, performance tiers, and cost-containment features
• Avoid pitfalls and common reasons for failure relating to corporate culture, intra-office politics, and poor communications
• Secure the proper executive champions who can execute the business planning needed for success
• Apply proven criteria to determine your future-state architecture and your migration method
• Execute your migration using a process proven by the authors over years of successful projects

Who This Book Is For

IT leadership, strategic IT decision makers, project owners and managers, and enterprise and application architects. For anyone looking toward cloud migration projects as the next stage of growth in their careers. Also useful for enterprise DBAs and consultants who might be involved in such projects. Readers should have experience and be competent in designing, coding, implementing, and supporting database applications in an on-premises environment.

✦ Table of Contents

Table of Contents
About the Authors
About the Technical Reviewer
Acknowledgments
Foreword
Chapter 1: The Azure SQL Data Platform
Azure Core Services and Concepts
Migration and Modernization
Migration and Modernization Strategies Made Simple
The Five Disciplines of Cloud Governance
Cautionary Tales
When the C-Suite Falls for the Hype
When Cost Is the Only Consideration
When Middle Managers Are Set Adrift
Vague Is As Vague Does
Fear: The Ultimate Motivator
Lessons from Market Research
The Benefits of Cloud Computing
Repatriation
Pilot Projects: Which to Choose or Avoid
The Skyscraper with No Architect
Worth Every Penny
Summary
Chapter 2: Planning Considerations and Analysis
Topics Covered in This Chapter
Scope Definition
Planning
Phase 1: Discovery
Discovery of the Database
Discovery of the Business and Its Requirements
Discovery of the Workload
Discovery Wrap-Up
Phase 2: Landing Zone Testing and Validation
Analysis and Testing
Availability and Uptime
Phase 3: Choose the Migration Strategy
Identifying and Configuring the Migration Landing Zone
Data Migration Assistant
Sizing the Cloud Systems
Azure SQL Database DTU Calculator
vCores Licensing Model
Database Migration Assistant
IaaS VMs
Azure Storage
Adopting a Cloud Mindset
Analyzing Workloads
Workload Replay Options
WorkloadTools
OStress
Workload Replay Process
Monitoring for Workload Analysis
Validating the Data
Platform Capability Validation
High Availability Configurations
Disaster Recovery Scenarios
Backup Retention and Recovery Scenarios
Geo-replication and Multiregion Deployments
Migration Dry Run
Summary
Chapter 3: Budgeting for an Azure Migration
Why Should You Care?
Does the Cloud Save You Money?
Getting Started Building a Budget
Ask for Help
Introducing the FLAT Method
Familiarity
Location
Architecture
Translation
Total Cost of Ownership Calculator
Azure Pricing Calculator
Important Calculator Considerations
Getting the Most from the Calculator
Big Scary Egress
Networking Cost Considerations
Reducing Your Azure Costs
Azure Hybrid Benefit and “Bring Your Own License”
Reconsider Architectural Decisions
Scheduled Shutdown and Startup
Autoscaling: Provision Only What You Need
Utilize Dev/Test Pricing
Azure Reservations
The Non-Azure Factors
Building an ROI
Summary
Chapter 4: Azure Cost Management
Azure Cost Management and Billing
Cost Management Concepts
Planning
Visibility
Accountability
Optimizations
Azure Billing Entity Hierarchy
Azure Cost Management in the Portal
Cost Analysis
Getting the Most from Your Analysis
Proactive Performance Tuning
Budgets
Action Groups
Azure Advisor
Multicloud Tool
Connecting External Sources
Lowering Costs
Summary
Chapter 5: Service and Systems Monitoring
Monitoring and Observability
Observability Platforms
What to Collect
Metrics, Logs, and Traces
From Servers to Services
Baselines
Baselines vs. Thresholds
Using Baselines to Build Smart Thresholds
Using Baselines to Right-Size Your Cloud Platform
Data Platform Monitoring in Microsoft Azure
Azure Monitor
Continuous Monitoring
Data Platform Monitoring Tools
SQL Server Health Check
Azure SQL Analytics
Summary
Chapter 6: Migrating Data and Code
Migrate Meaningful Data
Archive the Unneeded
Understand Business Requirements
Understand Usage Patterns
Considerations on Database Design
Migrate Meaningful Code
Data Migration Assistant
Finding Issues in Your Database Pre-migration
Baseline Testing
Remediation
Summary
Chapter 7: Team Success Factors
Business Value
Business Sponsorship
Support of the Team
Early Involvement
Encourage Growth
Dealing with Negative Energy
Promote Collaboration
Good Communication
Training for the Team
Asking for Help
Celebrate the Wins Along the Way
Have Fun
Summary
Chapter 8: Security, Privacy, and Compliance with the Law
Topics Covered in This Chapter
The Threat Environment
Use a Framework When New to Cybersecurity
Defend in Depth
Access Control in a Nutshell
Network Address Translation (NAT)
Azure Virtual Networking
Allowing Access to Services and Resources
Virtual Network (VNet) Firewall Rules and Azure Private Endpoints
Azure Private Link
Setting Up a Private Endpoint
Restrict Public Access
More Secure Routing
Private Endpoint Tips and Tricks
Azure Service Endpoints
Creating and Using Service Endpoints
Choosing Between Private Endpoints and Service Endpoints
Authentication for Azure SQL
Required Administrator Accounts
Best Practices for Azure Users and Groups
Connecting to Azure SQL
Connection Tips and Tricks
Azure SQL Database Firewall
When Undesirable Clients Attempt to Connect
What Do Firewalls Do?
Best Practices for Firewall Rules
Viewing Azure SQL Database Firewall Rules
Use Azure Portal to View Firewall Rules
Use PowerShell to View Firewall Rules
Use Transact-SQL to View Firewall Rules
Implementing Data Protection
Fine-Grained Data Access Using Row-Level Security
Prevent Internal Snooping on Sensitive Data Using Dynamic Data Masking
Protecting Data with Encryption
Encrypting Data in Transit Using Transport Layer Security
Encrypting Data at Rest Using Transparent Data Encryption
Encrypting Data in Use with Always Encrypted
How Does Always Encrypted Work?
Advanced Data Security
Advanced Threat Detection
Data Discovery and Classification
Vulnerability Assessment
Summary
Chapter 9: Documenting Data Sources and Metadata in a Data Dictionary
Creating Your Data Dictionary
Planning Your Data Dictionary
Extended Properties
Data Classification and Labels
Creating the Data Dictionary
Data Dictionary Metadata Sources
Completing the Picture
Linked Servers
Object Dependencies
Azure Service Mapping
Data Lineage
Azure Data Catalog
Azure Purview
Using the Azure Purview Data Dictionary
Summary
Chapter 10: Moving Your Data to the Cloud
Chapter 11: Data Validation Testing
Topics Covered in This Chapter
Why Validate the Data
Scope Definition
Data Validation Output
Summary
Which Service(s) Do You Need?
Considerations on Moving Your Data
Internet Throughput
Internet Connections
All-in-One Tools
Database Migration Service
Backup and Restore
BACPAC
Log Shipping
Physical Transfer
User Interfaces
Handling Schema and Data Separately
Command-Line Methods
Azure Data Factory
Data Synchronization/Replication
Third-Party Tools and Resources
Importance of Testing
Hybrid Scenarios
Summary
Chapter 12: Postmigration Tasks
Decommissioning Legacy Resources
Validation and Optimization
Performance Issues
Business Impact Analysis
Right-Sizing Your Data Platform
Technical Debt
Summary
Chapter 13: Post Mortem
The Benefits
The Process
Post-Mortem Questionnaire
Elect a Moderator
Post-Mortem Workshop
Meeting Rules and Guidelines
Actionable Change
The Other Items
Show Appreciation
Onto the Next Project
Summary
Index