How to Find the Last Time a Table was Updated in SQL Server
Tracking when a table was last updated is a common requirement in database management. It can help with monitoring data activity…
Read More
Tracking when a table was last updated is a common requirement in database management. It can help with monitoring data activity…
Read More
A couple of weeks ago, I had an Azure SQL Database size explode. You can’t run reports that come with SQL…
Read More
aka things that sound alike Levenshtein distance and Metaphone 3 are two different algorithms primarily used in the context of text…
Read More
I was trying to find what messages were being orphaned, so I started doing a little digging to figure out how…
Read More
This is a little tricky in the syntax. ?If you have a SQL User without Login that is showing disabled, you…
Read More
This script will create a script to disable and enable all the trigger within a SQL Server Database. You will want…
Read More