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?
Optimizing Query Performance with Statistics Updates in PostgreSQL and Microsoft SQL Server
In database systems, query optimization plays a crucial role in determining application performance. Efficient queries rely on up-to-date statistics that help the database’s query optimizer decide on the best execution plan. In PostgreSQL, the ANALYZE command is a key tool for collecting these statistics, especially when data is modified. This blog post delves into how
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
