Pro Database Migration to Azure: Data Modernization for the Enterprise
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 a thorough 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 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 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 11: Data Validation Testing Topics Covered in This Chapter Why Validate the Data Scope Definition Data Validation Output 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
How to download source code?
1. Go to:
2. In the Find a repository… box, search the book title:
Pro Database Migration to Azure: Data Modernization for the Enterprise, sometime you may not get the results, please search the main title.
3. Click the book title in the search results.
3. Click Code to download.
1. Disable the AdBlock plugin. Otherwise, you may not get any links.
2. Solve the CAPTCHA.
3. Click download link.
4. Lead to download server to download.