From Your Couch to the Cloud: When and Why to Choose the Azure Portal
summary
Focuses on when the Azure Portal is the right tool: provisioning logical servers, networking and firewall rules, configuring failover groups, creating and tuning elastic pools (demo moves WideWorldImporters to a new pool to reduce contention), and grabbing connection strings from the blade. Describes the query editor preview (AAD or SQL auth, edit data, up to 10 files, no execution plans, five minute timeout) and recommends Azure Data Studio or SSMS for heavy DDL or long-running schema changes.
AI-written summary · about
chapters (16)
- 0:00Introduction to the Azure Portal session
- 1:03Why this talk about the Azure Portal
- 3:39Portal overview and key features
- 6:47Operational tasks in the Azure Portal
- 9:58When to use the Azure Portal
- 12:02Unique portal capabilities for SQL Server
- 13:29Managing logical SQL servers in the portal
- 15:16Elastic pools and cost-effective scaling
- 17:48Demo of elastic pools configuration
- 25:15Query editor in the Azure Portal
- 27:24Demo of the query editor interface
- 33:11When to use Azure Data Studio over SSMS
- 36:22Portal feedback and Q&A session
- 41:30Azure Data Studio versus Management Studio
- 45:05User experience insights and comparisons
- 49:59Summary and closing remarks
related talks
01h 05mHow to Get the Best Out of Your SQL Server on Azure
22mFlight of Innovation: Enhancing On-Prem and Multi-Cloud SQL Instances with a Cloud Cockpit
43mLearn Azure SQL Database through Demos
48mThe Kingdom of AdventureWorks Calls for Aid- 22mFlight of Innovation: Enhancing On-Prem and Multi-Cloud SQL Instances with a Cloud Cockpit
50mSQL Server to Azure SQL: Performance and Availability
18mHow to reduce your SQL Database costs on Azure
47mAzure SQL - more or/and less than SQL Server