PostgreSQL

Comprehensive Guide: Setting Up PostgreSQL 17 on Ubuntu 24.04

10/14/2024 / By / PostgreSQL / 2 Comments

PostgreSQL is a robust, open-source relational database system that’s widely used in both small and large-scale production environments. Installing and configuring PostgreSQL, especially when dealing with custom directories or network-based access, can seem complex at first. In this guide, we will walk through the process of installing PostgreSQL 17 on Ubuntu 24.04, setting up a …

Comprehensive Guide: Setting Up PostgreSQL 17 on Ubuntu 24.04 + read more

The Top 5 Key Differences Between SQL Server and PostgreSQL

10/09/2024 / By / PostgreSQL / 4 Comments

As some of you may already know, I started working with PostgreSQL a few months ago to gain a better understanding of other relational database engines. Additionally, several of my customers are currently migrating to PostgreSQL. Therefore, it’s time for me today to share my top 5 key differences between SQL Server and PostgreSQL. When …

The Top 5 Key Differences Between SQL Server and PostgreSQL + read more

SQLpassion Performance Tuning Training Plan – Signup

Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.