When did you last time patch your SQL Server? I often discuss this question with my clients, I get many different kinds of answers.
SQL SERVER – Check for Update in SSMS
DBAs and Devs had many interesting questions during the Comprehensive Database Performance Health Check. How to check the update in SSMS?
SQL SERVER – Upgrade Error: Microsoft NET Framework 4.0 Installation Has Failed With Exit Code – 2146498511
The solution of error Microsoft .NET Framework 4.0 installation has failed with exit code -2146498511 which was faced during SQL Server upgrade
SQL SERVER – Fix Error – Login failed for user. Reason: Server is in script upgrade mode. Only administrator can connect at this time. (Microsoft SQL Server, Error: 18401)
I recently had a very simple and interesting error received while I was performing an upgrade mode with Docker and Persistence Storage for my upcoming workshop.
SQL SERVER – How to Fix High CPU Consumption on SQL Server 2017 and 2016
After a big upgrade, a client’s SQL Server showed high CPU Consumption, and they called me in twice. Here is what we found and the simple fix.
Checking That a Patch Really Installed
Checking That a Patch Really Installed means comparing full versions, reading Setup summary logs, and confirming the startup error log.
GDR or CU: Choosing Your Update Branch
Choose GDR or CU for SQL Server by understanding security and cumulative branches, checking the exact build, and testing a branch change.