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 MoreCategory: 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 MoreExploring AWS RDS for SQL Server vs Azure SQL
I’m looking at moving to AWS RDS for SQL from Azure SQL. The biggest downside is the licensing. Currently, I’m using…
Read MoreFix Ssms.exe 2014 on 4K monitors
I was having problems with Sql?Management Studio 2014 running on 4K monitors. This post tells you have to fix the issue:…
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 More