How do you order column values by how close they are to any integer, such as -5? Here is a script that works the same way on SQL Server and MySQL.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – SQL Server Configuration Checking – A Must Do for Every DBA – Notes from the Field #004
Still running on default settings? Mike Walsh explains why configuration checking is a must do for every DBA and how to fit SQL Server to your business.
SQL SERVER – Export Data AS CSV from Database Using SQLCMD
We often import CSV into SQL Server, but how do you export data as CSV with SQLCMD? Two simple commands, one with column headers and one without.
Elevator Etiquette: Small Rules for a Very Small Room
Elevator etiquette comes down to a few small habits: let people off first, give others room, keep the talk light and stay calm when you miss a door. Here are the rules I follow on conference trips, in office towers and on the way to an interview.
SQL SERVER – FIX : Error 3154: The backup set holds a backup of a database other than the existing database – SSMS
Error 3154 says the backup set holds a backup of a different database. Here is how to fix it in SSMS, plus the T-SQL RESTORE WITH REPLACE option.
XQuery Comparisons: General Equality Is Not Singleton Equality
XQuery Comparisons use different rules for general sequence operators and singleton value operators. I make equality and inequality visible side by side. A general unequal-pair result is not always the inverse of an equal-pair result.
SQL SERVER – vCPUs – How Many Are Too Many CPU for SQL Server Virtualization ? – Notes from the Field #003
Do not blame virtualization for slow servers. David Klee explains how many vCPUs are too many for SQL Server virtualization and how to set them up right.
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.