Klaus Aschenbrenner

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 …

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

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

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 Trainings about SQL Server Query Tuning Strategies & Availability Groups

On January 25, 2024 and on February 22, 2024 I will run two SQLpassion Live Trainings about SQL Server Query Tuning Strategies and SQL Server Availability Groups. In the training about SQL Server Query Tuning Strategies I will cover the following areas: Index Tuning Strategies Search Arguments Bookmark Lookup Operations Tipping Point Index Intersection Filtered …

SQLpassion Live Trainings about SQL Server Query Tuning Strategies & Availability Groups + read more