A DBA on Windows Server Core had no UI to read logs. Here is how to work with Event Viewer and PowerShell to read the events you need.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
Interview Question of the Week #053 – What is the Difference Between Deterministic Functions and Nondeterministic Functions?
What is the difference between deterministic functions and nondeterministic functions in SQL Server? A short interview answer with examples.
SQL SERVER – FIX Error 3169 – The database was backed up on a server running version
Restoring a SQL Server 2016 backup on a 2014 instance fails with Error 3169, backed up on a server running a newer version. Here is why and what you can do.
SQL SERVER – SSMA Error : System.Data.OracleClient requires Oracle client software version 8.1.7 or greater
I said I have no clue as to why this is happening and I asked if it was in any way related to SQL Server? Let us fix SSMA Error.
A Performance Counter Baseline Saved to a Table Every 15 Minutes
Save a performance counter baseline every 15 minutes, calculate interval rates, detect resets, and compare a defined week with last month.
Tracking sp_configure Changes Through Error Log Messages
Someone changed a setting and nobody admits it. Here is what the SQL Server error log keeps, and what it never records.
SQL SERVER – FIX: sp_rename error Msg 15225 – No item by the name of ‘%s’ could be found in the current database
Msg 15225 is a common sp_rename error: No item by the name could be found in the current database. Here is why it happens and the fix.
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.