A secondary server sitting idle as a backup feels like a waste. In Notes from the Field #107, Kenneth Urena shows how to build a readable secondary in Standard Edition with transactional replication.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
Error 598: SQL Server Fails to Start After Patching
Error 598 can stop SQL Server from starting right after a patch. In this case the script level upgrade failed because the service account could not create a temporary database file. Giving that account permission on the instance folder let the restart succeed.
SQL SERVER – Server Side and Client Side Trace
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.
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.
NUMA in SQL Server: A Lunch Chat About Local and Remote Memory
NUMA in SQL Server came up in a lunch break chat at SQLPass, during my 42 tips session. An attendee asked what NUMA is and when SQL Server got it. Here is the answer I gave, with the history.
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 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.