Top SQL Server migration questions

,

Below are the top 12 questions I am seeing from customers looking to migrate on-prem SQL Server to Azure, and the blogs that I have wrote that try to answer each question (I have updated most of these blogs):

  1. How does PaaS database high availability work? Azure SQL Database high availability
  2. How does PaaS database disaster recovery work? Azure SQL Database disaster recovery
  3. How can I monitor a PaaS database? Monitoring Azure SQL DatabaseAzure SQL Database monitoring
  4. What is the difference between SQL Database and SQL Data Warehouse? Azure SQL Database vs SQL Data Warehouse
  5. How do I handle multi-tenants in Azure? Multi-tenant databases in the cloud
  6. How does a NoSQL database like Cosmos DB compare to a relational database? Understanding Cosmos DB
  7. How does security work with SQL Database? Azure SQL Database security
  8. How do I scale SQL Database? Scaling Azure SQL DatabaseAzure SQL Database Read Scale-Out
  9. What are the migration options and tools available? Migrate from on-prem SQL server to Azure SQL DatabaseAzure Database Migration Service (DMS)Microsoft database migration tools
  10. How are database backups done? HA/DR for Azure SQL Database
  11. What are the storage options for SQL Server in an Azure VM (IaaS)? Storage options for SQL Server database files in Azure
  12. Can Azure handle large OLTP databases? Azure SQL Database Hyperscale

I have also put these questions under a new FAQ page.

Original post (opens in new tab)
View comments in original post (opens in new tab)

Rate

Share

Share

Rate