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):
- How does PaaS database high availability work? Azure SQL Database high availability
- How does PaaS database disaster recovery work? Azure SQL Database disaster recovery
- How can I monitor a PaaS database? Monitoring Azure SQL Database, Azure SQL Database monitoring
- What is the difference between SQL Database and SQL Data Warehouse? Azure SQL Database vs SQL Data Warehouse
- How do I handle multi-tenants in Azure? Multi-tenant databases in the cloud
- How does a NoSQL database like Cosmos DB compare to a relational database? Understanding Cosmos DB
- How does security work with SQL Database? Azure SQL Database security
- How do I scale SQL Database? Scaling Azure SQL Database, Azure SQL Database Read Scale-Out
- What are the migration options and tools available? Migrate from on-prem SQL server to Azure SQL Database, Azure Database Migration Service (DMS), Microsoft database migration tools
- How are database backups done? HA/DR for Azure SQL Database
- What are the storage options for SQL Server in an Azure VM (IaaS)? Storage options for SQL Server database files in Azure
- Can Azure handle large OLTP databases? Azure SQL Database Hyperscale
I have also put these questions under a new FAQ page.
