I‘m Klaus Aschenbrenner, a Microsoft Certified Master for SQL Server
» I help people to bring their SQL Server
installations to a new level of excellence. «
SQLpassion Offerings
SQLpassion, a European SQL Server consulting company, provides high-quality SQL Server consulting services.
We are based in Vienna, Austria, but our client base is spread across the continent.
We provide the following SQL Server services:
You have seen my Blog Postings?
Understanding PostgreSQL’s $PGDATA Folder in comparison to SQL Server
In the world of databases, the efficiency and reliability of how data is stored and managed are critical factors that can determine the performance, scalability, and ease of administration for any system. PostgreSQL and Microsoft SQL Server take slightly different approaches to data storage. A key concept in PostgreSQL that database administrators often encounter is
Comprehensive Guide: Setting Up PostgreSQL 17 on Ubuntu 24.04
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
The Top 5 Key Differences Between SQL Server and PostgreSQL
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
