There are a lot of benefits to migrating an on-premises database to Amazon Relational Database Service (RDS). I’ve found that RDS is much easier to operate than MySQL or PostgreSQL. …

Continue reading “8 Tips for Surviving a Live Database Migration to Amazon RDS”

Those looking for a solution to alleviate performance and resource issues with their data tier should consider Amazon RDS’ Aurora a viable option. While the benefits laid out from the …

Continue reading “The Ease of Migrating to Aurora”

This article introduces the very basics of writing stored procedures with PostgreSQL (aka Postgres), an open-source database system. It is intended for both Postgres newbies and MS SQL Server/MySQL stored …

Continue reading “A Basic Introduction to Postgres Stored Procedures”