Types PostgreSQL Views
As I move more into PostgreSQL from MS SQL Server, I am going through different aspects of PostgreSQL in relative to…
Read MoreCategory: Database
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 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 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