Apr2020 MOD20 - Moving your database to Azure by Laurent Bugnion

Session Details and Video:
https://galasoft.ch/presentations/details/2020016
http://aka.ms/mod20

Northwind kept the bulk of its data in an on-premises data center, which hosted servers running both SQL Server and MongoDB. After the acquisition, Tailwind Traders worked with the Northwind team to move their data center to Azure. In this session, see how to migrate an on-premises MongoDB database to Azure Cosmos DB and SQL Server database to an Azure SQL Server. From there, walk through performing the migration and ensuring minimal downtime while you switch over to the cloud-hosted providers.

Bio:
Laurent works as Senior Cloud Developer Advocate for Microsoft Azure after almost 10 years spent working for IdentityMine and Valorem, two leading firms in Microsoft technologies. He codes in Azure, .NET, Windows, WPF, Xamarin (iOS and Android), ASP.NET (Core and Classic). In his free time, he writes for technical publications such as MSDN Magazine, publishes technical videos on YouTube and Microsoft Channel 9, and his blog is on blog.galasoft.ch. He is a frequent speaker at conferences such as Microsoft Ignite, Microsoft Build, TechEd, VS Live, Techorama and many other international events. Prior to joining Microsoft, he was a Microsoft Most Valuable Professional for Windows development from 2007 to 2017, a Microsoft Regional Director from 2013 and a Xamarin Most Valuable Professional from 2015. He is also the author of the well-known open-source framework MVVM Light for Windows, WPF, and Xamarin.

You can find him at http://galasoft.ch/

Transcript

3. Resources aka.ms/mymsignitethetour aka.ms/MOD20Repo aka.ms/MOD20
4. There has never been a better time to migrate to Azure
5. Migration drivers
6. Azure capabilities across apps, data, and infrastructure
7. Azure Database Migration Service
8. Azure Data Box Migrate large amounts of data quickly and securely Provides additional data migration options General Availability Create a link between your premises and Azure storage
9. Tailwind Traders
10. Tailwind Traders acquires Northwind REDMOND, WA Tailwind Traders, Inc announced that it has agreed to acquire Northwind Traders, the venerable "old guard" international foods company, in an effort to bolster its virtual hardware offerings with some international culinary flare.
11. A rich catalog…
12. Architecture before the move MONGODB SQL SERVER 2012 AZURE ON PREMISE
13. Architecture after the move MONGODB SQL SERVER 2012 AZURE ON PREMISE AZURE SQL DATABASE COSMODB MONGO API
14. NoSQL with CosmosDB
15. Azure Cosmos DB Globally distributed database service
16. Global distribution Elastic scale out Guaranteed low latency Comprehensive SLAs Azure Cosmos DB Key-Value Column-family Graph Documents A globally-distributed, multi-model database service … more coming soon Five consistency models SQL mongoDB
17. Demo
18. /MS Learn alert aka.ms/mod20-learn-nosql
19. Relational data with Azure SQL
20. How to easily migrate and get benefits of cloud?
22. Azure SQL Database momentum 5.8 million databases 70 PB total size 3 trillion batch requests per day 550K subscriptions 100 million queries analyzed per hour 37K databases migrated via Database Migration Service
23. Key takeaways SQL Managed Instance
24. How to easily migrate and get benefits of cloud? Enables rehosting or light refactoring for most apps Eliminates the need to rearchitect or rebuild your apps Enables optimization during or post migration (fully managed service) IaaS (virtual machines) fall short here
25. What is SQL Database Managed Instance? SQL Server compatibility • Fully-fledged SQL instance with nearly 100% compat with on-premise Fully-managed service • Built on the same infrastructure as SQL Database • Provides the same benefits (PaaS) Full isolation and security • Contained within your VNet • Private IP addresses • Express Route / VPN connectivity New deployment option enabling friction-free migration of SQL Server workloads to a fully-managed service SQL Database (PaaS) Elastic Pool Managed Instance Single database New purchasing options • Transparent • Frictionless • Competitive
26. Demo
27. /MS Learn alert aka.ms/mod20-learn-sql
28. Azure Database for open source DBs engines Simple and flexible pricing, Language and frameworks of your choice Fully managed services without changing your applications Automatic backups, patching, built-in monitoring, security
29. PostgreSQL The world’s most advanced open source relational database DBMS of the Year
30. /Docs alert aka.ms/mod20-docs-postgresql
31. There has never been a better time to migrate to Azure
32. Resources
33. /Microsoft Certification alert Get hired, stay ahead, and receive the recognition you deserve #MSIgniteTheTour aka.ms/DataEngineerCert
35. /MS Learn alert aka.ms/mod20-learn-securedata
36. Continuously optimize migrated resources
37. Build your case: Azure Total Cost of Ownership calculator aka.ms/mod20-tco
38. Azure Migrate A central hub for starting, executing, and tracking your Azure migration aka.ms/mod20-migrate
39. Resources aka.ms/mymsignitethetour aka.ms/MOD20Repo aka.ms/MOD20 #MSIgniteTheTour Get Certified Azure Data Engineer Associate: aka.ms/DataEngineerCert
40. /Upcoming Session alert