Read a network trace of a SQL Server connection by separating TCP, pre-login, TLS, login, and first-query delays before tuning queries.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
JSON_ARRAY: Choose Whether NULL Elements Are Included
JSON_ARRAY constructs typed array text. Choose whether missing inputs disappear or remain JSON null placeholders before relying on positions.
SQL SERVER – Mirroring Configured Without Domain – The server network address TCP://SQLServerName:5023 can not be reached or does not exist
My friend kept getting the server network address cannot be reached error while testing mirroring configured without domain on his laptop. Here is why.
SQL SERVER – Difference Between ROLLBACK IMMEDIATE and WITH NO_WAIT during ALTER DATABASE
We are going to discuss something very simple topic. Difference Between ROLLBACK IMMEDIATE and WITH NO_WAIT during ALTER DATABASE.
XML value: Select One Typed Scalar
XML value extracts one typed scalar. Use a singleton path, review conversion, and distinguish first-item selection from uniqueness.
SQL SERVER – MAXDOP Settings to Limit Query to Run on Specific CPU
The MAXDOP query hint limits how many CPUs a query can use, though not which ones. With OPTION (MAXDOP 1), the parallelism operator leaves the plan.
Loading Large Files Fast With BULK INSERT
BULK INSERT loads large SQL Server files through a tested format, accessible path, staging table, measured batches, and final validation.
SQL Server slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.