Category: Database
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 MoreTypes PostgreSQL Views
As I move more into PostgreSQL from MS SQL Server, I am going through different aspects of PostgreSQL in relative to…
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 MorePostgreSQL: Terminating all active connections and dropping the database
Drop all active connections. Run this script to drop all active connections. Drop Database.
Read More