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.
SQL SERVER – Script Level Upgrade for Database ‘master’ Failed Because Upgrade Step ‘sqlagent100_msdb_upgrade.sql’ – Error: 5041: MODIFY FILE Failed
One more cause of the script level upgrade failure for ‘sqlagent100_msdb_upgrade.sql’: Error 5041, MODIFY FILE failed. Here is how I fixed it.
SQL SERVER – Why Edition Upgrade is Not Upgrading Edition of SQL Server?
A DBA friend ran Edition Upgrade from Standard to Enterprise, setup finished with no errors, yet SQL Server still showed Standard Edition. Here is why.
SQL SERVER – How to Change Database Compatibility Level?
After watching my free webinar the most popular question, which I receive is about Database Compatibility Level.
SQL SERVER – Edition Upgrade – Invoke or BeginInvoke Cannot be Called on a Control Until the Window Handle has Been Created
An old client met me at the airport with an edition upgrade error: Invoke or BeginInvoke cannot be called on a control. Here is the workaround.
SQL SERVER – Script level upgrade for database ‘master’ failed because upgrade step ‘sqlagent100_msdb_upgrade.sql’
After a patch, my SQL Server would not start because upgrade step ‘sqlagent100_msdb_upgrade.sql’ failed with error 537. Here is how I fixed it.
Converting Deprecated TEXT, NTEXT and IMAGE Columns Safely
Inventory deprecated TEXT, NTEXT and IMAGE columns, convert to MAX types, move small values in row, and measure logging and space costs.