SQLpassion BLOG

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

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 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