Database diagram support objects cannot be installed on a database upgraded from SQL Server 2005? This time the fix was the compatibility level.
Updatable Views: When INSERT and UPDATE Work Through a View
A view is only a doorway to the table behind it. I show which writes get through, which get rejected, and why CHECK OPTION earns its place.
SQL Server Pitfalls: Five Short Lessons With the Fix for Each
SQL Server pitfalls start with a small assumption. This page shows five of them, one for each topic: query hints, errors, permissions, XML and recursive queries. Each lesson shows the mistake first and the tested fix second. Every result comes from SQL Server 2025.
SQL SERVER – Fix : Error 3623 – An invalid floating point operation occurred
Error 3623, an invalid floating point operation, shows up when a math function gets a bad value. I explain it with simple examples like SQRT(-5) and LOG(-9).
XACT_ABORT: Why a Half-Done Transaction Can Survive an Error
Use XACT_ABORT to prevent partial writes, inspect transaction state after an error, and build a TRY CATCH pattern with reliable rollback.
An Error Handling Template for Stored Procedures With THROW
Build an error handling template with XACT_ABORT, XACT_STATE, durable error logging, and THROW, then test a forced procedure failure.
SQL SERVER – Fix: Error: 10920 Cannot drop user-defined function. It is being used as a resource governor classifier
Error 10920 stops you from dropping a user-defined function that is still the Resource Governor classifier. Here is why, and how to clean it up.