Content by Mohamed_Baioumy_MSFT (10)
Mohamed_Baioumy_MSFT explains how to build practical vector search in Azure SQL using exact queries and DiskANN indexes. The guide covers distance metrics, tenant filtering, changing data, index versions, and benchmarking recall against latency, including limitations that affect whether approximate search is the right choice.
Mohamed_Baioumy_MSFT explains how to enable zone redundancy on an existing Azure SQL Database while preparing for a brief disconnect. The checklist covers tier and regional support, application retry testing, change windows, portal and command-line configuration, verification and rollback, with separate migration considerations for Hyperscale databases.
Mohamed_Baioumy_MSFT explains how to diagnose Azure SQL Query Editor connection failures by separating browser, network, firewall, authentication, and database issues. The guide covers port 443 checks, corporate proxy interference, Private Link DNS, Microsoft Entra database users, serverless resume behavior, and limitations that require a different query tool.
Mohamed_Baioumy_MSFT explains how to identify whether a slow Azure SQL Database BACPAC import is limited by the client, network, target database, or import settings. The guide covers SqlPackage diagnostics, resource queries, same-region VM testing, parallelism tuning, and post-import checks before committing to a migration window.
Mohamed_Baioumy_MSFT explains how to choose a replacement before SQL Data Sync retires on 30 September 2027. The guide compares options against synchronization direction, writable destinations and latency requirements, then outlines incremental copying, parallel validation and cleanup, highlighting why bidirectional workloads need redesign or custom conflict handling.
Mohamed_Baioumy_MSFT explains how to investigate Azure SQL Database scaling operations alongside CDC delays and transaction-log growth without confusing correlation with causation. The guide uses diagnostic queries, repeated measurements, and operation timelines to identify workload pressure, evaluate safe mitigations, and prepare evidence for escalation.
Mohamed_Baioumy_MSFT explains how to investigate growing Change Tracking metadata in Azure SQL Database without modifying internal tables. The playbook covers configuration checks, version and storage trends, synchronization consumer validation, workload correlation, and evidence-based escalation, helping distinguish normal retention behavior from cleanup that is falling behind.
Mohamed_Baioumy_MSFT explains why brief Azure SQL disconnects can cause prolonged application outages. The guide separates database connectivity from application recovery, shows how to correlate SQL evidence with client telemetry, and covers bounded .NET retries, transaction safety, idempotency, and techniques for avoiding synchronized retry storms.
Mohamed_Baioumy_MSFT explains how to diagnose slow Synapse and Data Factory calls to Azure SQL Database by connecting pipeline invocations with database requests. The guide uses wait statistics, memory grants, live execution plans, and Query Store history to distinguish expensive execution from resource waits and test potential causes safely.
Mohamed_Baioumy_MSFT explains how to distinguish expensive execution, excessive compilation, and waiting workers in Azure SQL Database before adding vCores. The guide combines Query Store, live diagnostic views, and resource timelines to identify bottlenecks, test targeted fixes, and validate whether the workload genuinely needs additional compute.
End of content