Plan refreshing a test database with isolated restores, safe paths, user repairs, data replacement, disabled outbound actions, and a log.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
MySQL – LEAST and GREATEST Comparison Operators
Comparing values across many columns is a common chore. Here is how the MySQL LEAST and GREATEST comparison operators find the smallest and largest value.
SQL SERVER – Unable to Open Maintenance Plan in Management Studio
SSMS refused to open a maintenance plan and showed an error instead. Here is what I did when I was unable to open Maintenance Plan in Management Studio.
SELECT One by Two – Why Does SELECT 1/2 Returns 0 – Interview Question of the Week #067
Why does SELECT 1/2 return 0 in SQL Server and not 0.5? Beginners often think it is a bug. Here is the SELECT One by Two answer, explained simply.
SQL SERVER – Identifying Page Types
During a consulting session on SQL Server building blocks, a DBA asked me about pages. Here is how to identify Page Types in your database, back to basics.
MySQL – FOUND_ROWS() Function for Total Number of Rows Affected
In SQL Server you get the number of rows affected with @@ROWCOUNT. In MySQL, you can find the total number of rows with FOUND_ROWS().
Error 112 Not Enough Space: Compressed Backup Fails at Random
Error 112 not enough space on the disk failed a client’s backups at random, even though free space looked fine. The cause was how compressed backups pre-allocate the file. Trace flag 3042 fixed it, and a simple free-space rule of thumb helps.
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.