Azure SQL Database
7 articles tagged Azure SQL Database.
Azure SQL Database Backups: Point-in-Time Restore, LTR and Geo-Restore
Set PITR retention and backup redundancy, add a long-term retention policy, and run point-in-time, deleted-database, LTR and geo-restores for Azure SQL Database and Managed Instance.
Azure SQL Database vs Managed Instance vs SQL Server VM: How to Choose
Compare Azure SQL Database, Azure SQL Managed Instance and SQL Server on Azure VMs on compatibility, high availability, limits, cost model and management, then pick one with a repeatable assessment.
Azure SQL Entra Authentication: Entra-Only Mode and Managed Identity
Replace SQL logins on Azure SQL Database and Managed Instance with Microsoft Entra ID: set the Entra admin, create users for groups and managed identities, then enable Entra-only authentication.
Azure SQL Failover Groups: Configure Geo-Failover for Database and MI
Create Azure SQL failover groups for SQL Database and Managed Instance, point apps at the listener endpoints, choose a failover policy and run planned and forced failover drills.
SaaS Data Isolation on Azure: Database per Tenant vs Shared Schema
Choose a tenancy model for a SaaS product on Azure: shared schema with row-level security, database per tenant in elastic pools, sharding, or Cosmos DB partition and account isolation.
SQL Server Error 1205 Deadlock Victim: Capture, Read and Fix Deadlocks
Capture deadlock graphs with Extended Events in SQL Server and Azure SQL Database, read the victim, process and resource lists, and stop error 1205 with indexing, access order, row versioning and retries.
SQL Server Query Store: Find Plan Regressions and Force a Good Plan
Use Query Store in SQL Server and Azure SQL Database to find queries that got slower after a plan change, force the last good plan, check that forcing works, and automate it with automatic plan correction.