Use dependency metadata, definition searches, and runtime evidence to find object usage while accounting for dynamic SQL and external callers.
SQL SERVER 2016 – IF EXISTS Function on SQL Azure Databases and More
Many SQL Server 2016 features reach Azure SQL Database first. Here is how I checked the IF EXISTS Function and other new features on SQL Azure databases.
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.
SQL SERVER – FIX: Msg 4335, Level 16, State 1 – The specified STOPAT time is too early
Preparing a point in time restore demo, I got Msg 4335: the specified STOPAT time is too early. Here is what the error means and how to get past it.
SQL SERVER – FIX: Msg 7395, Level 16, State 2 – Unable to start a nested transaction for OLE DB provider
A linked server update in a distributed transaction failed with Msg 7395, unable to start a nested transaction for OLE DB provider. Here is the cause and fix.
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 – 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.