Oreilly - Introducing Azure SQL Database: From Deployment over Migration to Monitoring
by Peter De Tender | Released August 2019 | ISBN: 9781484252765
Discover everything you need to know to get started with Azure SQL Database, from deployment, to key features to migration and monitoring! This video introduces Azure SQL Database, a general-purpose relational database-as-a-service (DBaaS). Beginning from a base deployment of an Azure SQL instance, you will be introduced to the cloud-native features of the service and discover how to run highly available and production-ready database back-ends on Azure, without the underlying database server virtual machines. After the base deployment walkthrough, you'll learn how to replicate business-critical databases across multiple regions, as well as how to migrate a database from on-premises or VM-based scenarios to Azure SQL Database. What You Will LearnUnderstand Azure Database Services and Azure SQL DatabaseDeploy an Azure SQL Database instanceScale Azure SQL Database using elastic pools Migrate a database from on-premises to AzureTroubleshoot Azure SQL DatabaseWho This Video Is For Data professionals who want to learn about migrating, deploying, and monitoring Azure SQL Database. Viewers should have an Azure subscription (trial, MSDN, AzurePass, CSP, EA, pay as you go). Show and hide more
- Introduction 00:03:13
- Why Run Databases in the Cloud? 00:08:13
- Azure SQL Database Deployment using the Azure Portal 00:06:42
- Azure SQL Database Deployment using Azure PowerShell 00:05:23
- Azure SQL Database Deployment using Azure CLI 00:03:55
- Running Azure SQL 00:07:24
- Azure SQL Database Migration Assistant 00:08:33
- Azure SQL Database Migration Using SMSS 00:03:33
- SQL Database Migration Using Export/Import of BacPac File 00:04:45
- Optimizing Azure SQL 00:07:45
- Azure SQL High Availability 00:05:55
- Conclusion 00:02:54
Show and hide more