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.
Community
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.
Community
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.
Community
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.
Community
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.
Community
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.
Community
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.
Community
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.
Community
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.
Community
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.
Community

End of content

Rejoining the server...

Rejoin failed... trying again in seconds.

Failed to rejoin.
Please retry or reload the page.

The session has been paused by the server.

Failed to resume the session.
Please reload the page.