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 – 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.
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 – Someone was trying to hack my SQL Server Logins in Azure!
I noticed failed login errors on my Azure VM. Someone was trying to hack my SQL Server logins in Azure. Here is what I found and fixed.
SQL SERVER – Script: Finding Cumulative IO Per Database File
A simple script to find cumulative IO per database file in SQL Server, and the real scenarios where this number helps you.