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 MoreTag: SQL Server
Shrink a SQL Database
A couple of weeks ago, I had an Azure SQL Database size explode. You can’t run reports that come with SQL…
Read MoreMy Notes: Levenshtein distance and/or Metaphone
aka things that sound alike Levenshtein distance and Metaphone 3 are two different algorithms primarily used in the context of text…
Read MoreFind Orphaned DTA Service Instances with SQL Query
I was trying to find what messages were being orphaned, so I started doing a little digging to figure out how…
Read MoreEnable User without Login
This is a little tricky in the syntax. ?If you have a SQL User without Login that is showing disabled, you…
Read MoreDisable/Enable all triggers in SQL Server Database
This script will create a script to disable and enable all the trigger within a SQL Server Database. You will want…
Read More