Azure
Articles in the Azure category (36).
Articles in the Azure category (36).
- A database move plan that respects failover group pairing — Moving a geo-replicated database between pools: secondary first, capacity checks on both sides, geo-link health, pausing consumers, verification and rollback.
- Automating Azure SQL long-term backup retention (LTR) with scheduled PowerShell — Apply the LTR policy idempotently, produce a verification report and test restores automatically.
- Automating go-to-production for an Azure SQL database with a request queue — A request queue, creation in the right elastic pool, failover group, users, tags, inventory and a report, built from idempotent, resumable steps.
- Azure Batch for a DBA: running scheduled PowerShell/SQL jobs — Azure Batch architecture as a DBA job platform: pool, job, task, package, managed identity, Key Vault, logs, and why Batch rather than SQL Agent, Automation or Functions.
- Azure Batch pool autoscale formula — Azure Batch autoscale formula that sets the number of dedicated nodes from pending tasks, with fixed time windows.
- Azure Batch: zip created with 7-Zip failing as an application package — Observation on an Azure Batch application package: 7-Zip zip failing, Windows zip working, and how to compare archives.
- Azure Firewall: deploy and configure from the portal — Memo pointing to the official tutorial for deploying Azure Firewall through the Azure portal.
- Azure SQL failover groups explained for a DBA — Read-write and read-only listeners, failover policy, grace period, what moves with the group, elastic pools on both sides and limits.
- Azure SQL failover groups: pitfalls and lessons learned — Database left out of the group, undersized secondary pool, wrong listener, lagging inventory, primary-only jobs and differences with SQL Managed Instance.
- Azure SQL geo-replication: setup, lag monitoring and failover drill — Failover groups, state and lag monitoring, a planned failover drill and pitfalls to avoid.
- Azure SQL Managed Instance for a DBA: when to choose it, roles and differences — When to pick Managed Instance over Azure SQL Database or SQL Server, the roles and permissions model with Entra, differences and pitfalls.
- Azure SQL Managed Instance: on-demand native backups and TDE — Memo and references on on-demand COPY_ONLY backups to Blob Storage and customer-managed TDE.
- Azure SQL: query with a managed identity token — PowerShell script that gets a token from IMDS for a managed identity and queries an Azure SQL database (version, collation, size).
- Building an Azure SQL failover group with PowerShell and az CLI — Creating the group, adding databases from elastic pools, watching seeding, listener connection strings, logins, SIDs and Entra authentication on the secondary.
- Building an inventory (CMDB) of an Azure SQL estate with Resource Graph — Resource Graph for servers, pools, databases and failover groups, per-database SQL collection, a central database and how to handle inventory lag.
- Cloud: service models (IaaS, PaaS, FaaS, SaaS) and AWS / Azure / Google equivalents — Responsibility split by cloud service model and service mapping between AWS, Azure and Google Cloud.
- Collecting per-database metrics to drive elastic pool placement — What to measure, where to read it (DMVs, Azure Monitor, Log Analytics), how to store history, score a database and handle seasonality.
- Copying an Azure SQL database between servers and environments: permissions, renaming, cleaning — Azure SQL database copy with PowerShell or T-SQL, required permissions, temporary name, sensitive data masking and post-copy steps.
- Decommissioning an Azure SQL database safely: checks, approvals and audit — Check connections, backup and long-term copy, leave the failover group, drop, keep an audit trail, all driven by an approval-based queue.
- Defender for Cloud: fix a plan by turning it off and on again — Where to find the Defender plans of an Azure subscription and how to toggle them Off then On to fix an issue.
- Distributing databases across Azure SQL elastic pools: analysis, plan and safe moves — Analyse load per database, build a move plan, rebalance online, choose the timing and verify the result.
- Entra ID authentication to Azure SQL from PowerShell — Access tokens, managed identities and service principals: which identity for which job, and least privilege in the database.
- Exporting thousands of Azure SQL databases to files with bcp and Azure Batch — One Batch task per database, bcp options (native vs character, terminators, UTF-8, packet size), Entra authentication, compression, blob upload, row-count checks, targeted retries and cleanup.
- Microsoft Fabric from a DBA's point of view: the good ideas and the sticking points — My opinion after the Fabric courses: bronze, silver, gold layers and Spark, yes; drag and drop, AI everywhere and workspace-level security, less so.
- Migrate Azure SQL databases between elastic pools and failover groups with KEDA pause — Generic runbook: geo-replication checks, batch exclusion, KEDA pause, migration, location registry update and resume.
- Migrating SQL Server on-premises to Azure SQL Managed Instance: options, cut-over and pitfalls — Backup/restore from URL, Log Replay Service, MI link and DMS: how to choose, steps, cut-over and pitfalls to avoid.
- Monitoring Azure SQL elastic pools: metrics, alerts and a daily report — CPU, workers, sessions and storage per pool and per database, alert thresholds and a daily check script that mails an HTML report.
- Moving Azure SQL to Microsoft Entra-only authentication — Prerequisites, T-SQL inventory of remaining SQL accounts, detecting orphaned users and users tied to deleted Entra groups, enabling it (portal, PowerShell, az), rollback and pitfalls.
- Packaging a PowerShell application for Azure Batch — Versioned ZIP, task wrapper script, environment variables, per-environment config merged at build time, retries and one-task-per-database fan-out.
- Planned vs forced failover of an Azure SQL failover group: a runbook — Failover runbook, checks before and after, application impact, failback, finding the current primary from PowerShell or T-SQL, and a drill checklist.
- Private endpoints and DNS for Azure SQL: works from the portal, fails from the job — Private endpoint vs service endpoint vs public access, the privatelink zone, hub-and-spoke and on-premises DNS forwarding, then a troubleshooting checklist: Resolve-DnsName, Test-NetConnection, Redirect vs Proxy and port ranges.
- Rebalancing a large Azure SQL estate: presenting results, tolerances, avoiding ping-pong and lessons learned — Before/after views, choosing tolerances, avoiding ping-pong moves, move windows, what went wrong and the role of human review.
- Reducing the Azure SQL bill as a DBA — Elastic pools vs single databases, vCore vs DTU, serverless auto-pause, right-sizing from metrics, reservations and Hybrid Benefit, backups, idle databases, Log Analytics ingestion and a monthly routine (no prices).
- SqlPackage with Azure SQL Database: Entra ID authentication, export and deployment — Using SqlPackage with Azure SQL Database: access tokens, service principal, universal authentication, BACPAC export, DACPAC comparison and publish.
- Testing Azure SQL access with a managed identity in PowerShell — Az PowerShell test sequence with a managed identity to troubleshoot an Azure Batch job, plus a script syntax check.
- Troubleshooting a managed identity that cannot log in to Azure SQL from Azure Batch — Runbook: symptoms, error messages and checks (identity assigned to the pool, CREATE USER FROM EXTERNAL PROVIDER, token audience, firewall, private endpoint, caches).