SQLpassion BLOG

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 Live Trainings about SQL Server on Microsoft Azure & Availability Groups

07/22/2024 / By / AlwaysOn, Indexing, SQLServer / Leave a Comment

On November 27 – 28, 2024 and on December 4, 2024 I will run two SQLpassion Live Trainings about SQL Server on Microsoft Azure and SQL Server Availability Groups. SQL Server on Microsoft Azure – Course Overview:Learn expert strategies for crafting robust SQL Server architectures in the Azure environment. Explore best practices for scalability, security, and …

SQLpassion Live Trainings about SQL Server on Microsoft Azure & Availability Groups + read more

SQLpassion Live Training about running SQL Server in Microsoft Azure

03/04/2024 / By / Azure, SQLServer / Leave a Comment

From April 24 – 25, 2024 I will run a brand-new SQLpassion Live Training about Design, Deploy, and Optimize SQL Server on Microsoft Azure. Unlock the power of Microsoft Azure and master the art of designing, deploying, and optimizing SQL Server with this cutting-edge online live training course! Course Overview: Learn expert strategies for crafting …

SQLpassion Live Training about running SQL Server in Microsoft Azure + 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.