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 theproject.

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

Kevin Kline is a noted database expert and software industry veteran. A long-time Microsoft Data Platform MVP and noted community leader in the IT industry, Kevin is a founder and former president of the Professional Association for SQL Server, as well as the author of popular IT books such as SQL in a Nutshell. Kevin is a top-rated speaker at industry trade shows worldwide and has a monthly column at Database Trends magazine. He tweets at @kekline and blogs regularly. Kevin is a Principal Program Manager at SentryOne, a leading vendor of database tools for the Microsoft data platform.

Denis McDowell has been designing and implementing technology solutions with Microsoft Data Platform technologies for over 20 years. Denis' 10 years leading the Application Management practice for a managed services provider and subsequent experience consulting in financial technologies led him to develop broad and deep expertise architecting requirements-driven cloud solutions to meet the business objectives of his customers. Denis is a certified Microsoft Azure Data Platform Engineer and speaks regularly at industry events and conferences around the world. Denis tweets at @McDowell_IS and is the Principal Solution Architect for SentryOne, a leading vendor of database tools for the Microsoft data platform.

Dustin Dorsey has been architecting and managing SQL Server solutions for healthcare companies for well over a decade. While he has built his career in database administration, he has also spent significant time working in development and business intelligence. During this time, Dustin has gained a keen interest and specialization in cost management around the data platform both on-premise and in the cloud that he has used to save organizations millions of dollars. Dustin is an international speaker and can be seen writing articles on popular SQL websites as well as on his own blog at DustinDorsey.com. He is also active in the community both as a local user group leader and co-organizer of his local SQLSaturday. Dustin tweets at @sql_dd and currently serves in a Director role for one of the largest healthcare organizations in the US.

1. An Azure SQL Database Migration Example

2. Planning Considerations and Analysis

3. Budgeting for an Azure Migration

4. Azure Cost Management

5. Service and Systems Monitoring

6. Migration and Code

7. Team Success factors

8. Security, Compliance, Privacy, and the Law

9. Documenting Data Sources and Metadata in a Data Dictionary

10. Moving Your Data to the Cloud

11. Data Validation Testing

12. Post-Migration Procedures

13. Post Mortem