Category: SQL Server
SQL Server Table Sizes
With Azure SQL, you can’t run the table size reports, so I use this script (as a view) to see the…
Read MoreSQL Server: Convert a date with time to a specific timezone offset
I needed to insert a record into a table with the datetimeoffset with a specific timezone’s offset.
Read MoreHow 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 MoreShrink 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 More