A loop that inserts one row at a time waits for the log on every row. Here is how to see it, and three ways to wait far less.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – Execute Operating System Commands in sqlcmd
Tired of leaving sqlcmd to check something in Windows? Here is a simple trick to execute operating system commands while you are still in the sqlcmd prompt.
Auditing Failed Logins With the Error Log and Extended Events
Investigate failed logins with the SQL Server error log and a focused Extended Events session, then group attempts and decide what to do.
Renaming the Windows Server Under SQL Server: Fixing @@SERVERNAME
After renaming the Windows server, repair SQL Server’s local name with sp_dropserver and sp_addserver, then verify dependent services.
Vector Search in SQL Server 2025 With VECTOR_DISTANCE
Use VECTOR_DISTANCE in SQL Server 2025 to rank small example vectors, compare cosine and euclidean distance, and plan larger searches.
SQL SERVER – Automatically Store Results of Query to File with sqlcmd
Want to store results of query to file automatically without SSMS? Here is how to do it with sqlcmd and its -o option, step by step.
SQL SERVER – Simple Puzzle with UNION Part 5
In Puzzle with UNION Part 5, the final part, two almost identical queries return the same answer, yet their execution plans are very different. Why?
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.