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 More
As I move more into PostgreSQL from MS SQL Server, I am going through different aspects of PostgreSQL in relative to…
Read More
Tracking when a table was last updated is a common requirement in database management. It can help with monitoring data activity…
Read More
A couple of weeks ago, I had an Azure SQL Database size explode. You can’t run reports that come with SQL…
Read More
aka things that sound alike Levenshtein distance and Metaphone 3 are two different algorithms primarily used in the context of text…
Read More
Drop all active connections. Run this script to drop all active connections. Drop Database.
Read More
I’m looking at moving to AWS RDS for SQL from Azure SQL. The biggest downside is the licensing. Currently, I’m using…
Read More
I was having problems with Sql?Management Studio 2014 running on 4K monitors. This post tells you have to fix the issue:…
Read More