Running Profiler on the server does not make it a server side trace. I explain the real difference between server side and client side trace in SQL Server.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
Extracting the Folder and File Name From a Full Path in T-SQL
Split a path at the last backslash and handle the odd inputs. Bare names, empty values, trailing spaces and NULL all behave.
Interview Question of the Week #049 – Taking Database Offline
Taking database offline is one line of T-SQL with ROLLBACK IMMEDIATE. But what if your boss wants to wait 30 seconds first? Here is that script too.
SQL SERVER – Discussion on understanding NUMA
An attendee at my 42 tips session at SQLPass asked me a simple question. Our chat turned into a friendly lesson on understanding NUMA in SQL Server.
SQL SERVER – Connecting to Azure SQL DB
Connecting to Azure SQL DB from SSMS gave me an error at first. Here is where to find the connection string and how to allow your IP address in the portal.
SQL SERVER – Getting Started with Project Versions in the SSIS Catalog – Notes from the Field #106
Tim Mitchell shows a handy but overlooked feature: project versions in the SSIS catalog, which keep earlier deployments you can browse in SSMS.
In-Memory OLTP in Azure SQL Database: Tiers, Limits and a Local Test
In-Memory OLTP in Azure SQL Database needs the right service tier and fits inside a memory cap. This post lists today’s tiers and limits from the documentation, then tests memory-optimized tables, a native procedure and a pre-scaling check on SQL Server 2025.
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.