Skip to content
corpus.blogBeta
All posts

sqlpassion.at

sqlpassion.at

2026

https://www.sqlpassion.at/imprint/Read at sqlpassion.at (opens in a new tab)
29 May 2026
https://www.sqlpassion.at/about/Read at sqlpassion.at (opens in a new tab)
29 May 2026
https://www.sqlpassion.at/Read at sqlpassion.at (opens in a new tab)
29 May 2026
Don’t Miss Out – SQL Server 2025 Unleashed Training Starts Next Monday!Read at sqlpassion.at (opens in a new tab)
2 Mar 2026
PostgreSQL Quickie #2: Installation in Virtual MachinesRead at sqlpassion.at (opens in a new tab)
23 Feb 2026
The Linux Page Cache and PostgreSQLRead at sqlpassion.at (opens in a new tab)
17 Feb 2026
Where is My Clustered Index in PostgreSQL?Read at sqlpassion.at (opens in a new tab)
11 Feb 2026
https://www.sqlpassion.at/live-trainings/Read at sqlpassion.at (opens in a new tab)
10 Feb 2026
Vector Capabilities with pgvector in PostgreSQLRead at sqlpassion.at (opens in a new tab)
4 Feb 2026
Don’t Miss Out – SQL Server Query Tuning Fundamentals Starts Next Monday!Read at sqlpassion.at (opens in a new tab)
2 Feb 2026
Spatial Data with PostGIS in PostgreSQLRead at sqlpassion.at (opens in a new tab)
26 Jan 2026
BRIN Indexes in PostgreSQLRead at sqlpassion.at (opens in a new tab)
19 Jan 2026
GIN Indexes in PostgreSQLRead at sqlpassion.at (opens in a new tab)
12 Jan 2026
Level Up Your Skills in 2026: Live Online Trainings for Database & Infrastructure ProfessionalsRead at sqlpassion.at (opens in a new tab)
7 Jan 2026
https://www.sqlpassion.at/live-trainings/mastering-memory-safety-performance-with-rust/Read at sqlpassion.at (opens in a new tab)
5 Jan 2026
GiST and SP-GiST Indexes in PostgreSQLRead at sqlpassion.at (opens in a new tab)
5 Jan 2026
https://www.sqlpassion.at/live-trainings/sql-server-2025-unleashed/Read at sqlpassion.at (opens in a new tab)
1 Jan 2026
https://www.sqlpassion.at/live-trainings/sql-server-query-tuning-fundamentals/Read at sqlpassion.at (opens in a new tab)
1 Jan 2026
https://www.sqlpassion.at/live-trainings/database-infrastructure-automation-with-terraform-ansible/Read at sqlpassion.at (opens in a new tab)
1 Jan 2026
https://www.sqlpassion.at/live-trainings/linux-fundamentals-for-the-windows-professional/Read at sqlpassion.at (opens in a new tab)
1 Jan 2026

2025

Hash Indexes in PostgreSQLRead at sqlpassion.at (opens in a new tab)
22 Dec 2025
New on YouTube: PostgreSQL Introduction for the SQL Server ProfessionalRead at sqlpassion.at (opens in a new tab)
1 Dec 2025
SQL Server 2025 RTM – A Technical Deep Dive into Microsoft’s Most Capable Release YetRead at sqlpassion.at (opens in a new tab)
24 Nov 2025
Master SQL Server Performance Tuning – Black Friday Sale: 50% Off All Online Trainings!Read at sqlpassion.at (opens in a new tab)
17 Nov 2025
How SQL Server Professionals Can Master PostgreSQL – Without Wasting Months on Trial & ErrorRead at sqlpassion.at (opens in a new tab)
3 Nov 2025
SQL Server 2025 Unleashed Live Training – A New Era BeginsRead at sqlpassion.at (opens in a new tab)
27 Oct 2025
Why I Avoid SMR Drives – and What the New Western Digital Warnings RevealRead at sqlpassion.at (opens in a new tab)
24 Oct 2025
Bringing 10 Gbit to my Client Devices in my Home OfficeRead at sqlpassion.at (opens in a new tab)
20 Oct 2025
Understanding Upstream vs. Downstream PostgreSQLRead at sqlpassion.at (opens in a new tab)
13 Oct 2025
What’s New in PostgreSQL 18Read at sqlpassion.at (opens in a new tab)
29 Sept 2025
From Couch-Potato to Triathlete – and What This Means for Your SQL ServerRead at sqlpassion.at (opens in a new tab)
21 Sept 2025
Introducing my new PostgreSQL Quickies Series on YouTubeRead at sqlpassion.at (opens in a new tab)
15 Sept 2025
Column Tetris Explained: The Hidden Storage Costs of Migrating from SQL Server to PostgreSQLRead at sqlpassion.at (opens in a new tab)
8 Sept 2025
Running PostgreSQL with PgBouncer on Mac OS Using Docker ComposeRead at sqlpassion.at (opens in a new tab)
1 Sept 2025
What’s New in SQL Server 2025Read at sqlpassion.at (opens in a new tab)
25 Aug 2025
The Reckless Race: How Generative AI Could Break SocietyRead at sqlpassion.at (opens in a new tab)
8 Aug 2025
My First Sprint Triathlon: From Doubt to Triumph at Aloha Tri TraunRead at sqlpassion.at (opens in a new tab)
4 Aug 2025
The Best of Both Worlds: How I Built My Ideal Dual-Boot System with Ubuntu 24.04 and Windows 11Read at sqlpassion.at (opens in a new tab)
28 Jul 2025
Building a VS Code Debugging Workflow for a Custom x64 Operating System with QEMU and GDBRead at sqlpassion.at (opens in a new tab)
22 Jul 2025
Switching My 2019 MacBook Pro to Linux: The T2-Ubuntu JourneyRead at sqlpassion.at (opens in a new tab)
2 Jul 2025
Attend my Online Training in November: PostgreSQL for the SQL Server ProfessionalRead at sqlpassion.at (opens in a new tab)
23 Jun 2025
Maximizing 40G NIC Performance on Linux with Intel XL710 and Cisco Nexus SwitchesRead at sqlpassion.at (opens in a new tab)
16 Jun 2025
From SQL Server to PostgreSQL: A Story of 5 Key SQL DifferencesRead at sqlpassion.at (opens in a new tab)
11 Jun 2025
https://www.sqlpassion.at/sql-rescue-de/Read at sqlpassion.at (opens in a new tab)
4 Jun 2025
https://www.sqlpassion.at/sql-rescue-en/Read at sqlpassion.at (opens in a new tab)
4 Jun 2025
Why I Created the SQL Rescue Sprint – And How It WorksRead at sqlpassion.at (opens in a new tab)
4 Jun 2025
My First Bike & Run Half Distance: St. Pölten 2025Read at sqlpassion.at (opens in a new tab)
2 Jun 2025
Solar-Powered, Proxmox-Driven: A Tour of My Ultimate SQL Server Home LabRead at sqlpassion.at (opens in a new tab)
12 May 2025
Mastering Memory Safety & Performance with Rust – a 1 day Intensive Online Training on June 24, 2025Read at sqlpassion.at (opens in a new tab)
5 May 2025
Master SQL Server Query Tuning in Just Two Days! Online Live Training – June 17 – 18, 2025Read at sqlpassion.at (opens in a new tab)
28 Apr 2025
Understanding Text Data Types in PostgreSQL and SQL ServerRead at sqlpassion.at (opens in a new tab)
24 Feb 2025
Understanding Query Plan Caching in PostgreSQL and How It Differs from SQL ServerRead at sqlpassion.at (opens in a new tab)
10 Feb 2025
Understanding Fill Factor in SQL Server and PostgreSQLRead at sqlpassion.at (opens in a new tab)
27 Jan 2025
Online Recording: Exploring PostgreSQL for SQL Server Developers and DBAsRead at sqlpassion.at (opens in a new tab)
20 Jan 2025
Understanding Concurrency Control in SQL Server and PostgreSQL: A Comparative AnalysisRead at sqlpassion.at (opens in a new tab)
16 Jan 2025
Introducing My Brand-New Online Training: PostgreSQL for the SQL Server Professional!Read at sqlpassion.at (opens in a new tab)
8 Jan 2025

2024

How to Fix the PostgreSQL “Could Not Resize Shared Memory Segment” Error in DockerRead at sqlpassion.at (opens in a new tab)
9 Dec 2024
Exploring Data Access Methods in PostgreSQL and How They Compare to SQL ServerRead at sqlpassion.at (opens in a new tab)
3 Dec 2024
SQL Server Quickie #48 – Azure SQL Managed InstanceRead at sqlpassion.at (opens in a new tab)
18 Nov 2024
Microsoft Releases Windows 11 ARM ISO – A Game Changer for ARM-Powered DevicesRead at sqlpassion.at (opens in a new tab)
14 Nov 2024
Master SQL Server Performance Tuning – Black Friday Sale: 60% Off All Online Trainings!Read at sqlpassion.at (opens in a new tab)
6 Nov 2024
Optimizing Query Performance with Statistics Updates in PostgreSQL and Microsoft SQL ServerRead at sqlpassion.at (opens in a new tab)
28 Oct 2024
Understanding PostgreSQL’s $PGDATA Folder in comparison to SQL ServerRead at sqlpassion.at (opens in a new tab)
21 Oct 2024
Comprehensive Guide: Setting Up PostgreSQL 17 on Ubuntu 24.04Read at sqlpassion.at (opens in a new tab)
14 Oct 2024
The Top 5 Key Differences Between SQL Server and PostgreSQLRead at sqlpassion.at (opens in a new tab)
9 Oct 2024
SQL Server Quickie #47 – Azure SQL DatabaseRead at sqlpassion.at (opens in a new tab)
5 Sept 2024
SQLpassion Live Trainings about SQL Server on Microsoft Azure & Availability GroupsRead at sqlpassion.at (opens in a new tab)
22 Jul 2024
SQLpassion Live Trainings about SQL Server Query Tuning Strategies & Availability GroupsRead at sqlpassion.at (opens in a new tab)
8 Jan 2024

2023

My new YouTube playlist – the Rust QuickiesRead at sqlpassion.at (opens in a new tab)
20 Dec 2023
SQL Server Quickie #46 – SQL Server on LinuxRead at sqlpassion.at (opens in a new tab)
28 Nov 2023
Exploring the Query Store on Secondary Replicas in SQL Server 2022Read at sqlpassion.at (opens in a new tab)
22 Nov 2023
Exploring Neural Networks with TensorFlow in Visual Studio Code Dev ContainersRead at sqlpassion.at (opens in a new tab)
9 Aug 2023
I’m speaking at the Data Saturday Holland!Read at sqlpassion.at (opens in a new tab)
1 Aug 2023
SQLpassion Weekly Update #4Read at sqlpassion.at (opens in a new tab)
16 May 2023
SQLpassion Weekly Update #3Read at sqlpassion.at (opens in a new tab)
8 May 2023
SQLpassion Weekly Update #2Read at sqlpassion.at (opens in a new tab)
26 Apr 2023
SQLpassion Weekly Update #1Read at sqlpassion.at (opens in a new tab)
20 Apr 2023
SQLpassion Live Trainings about SQL Server Query Tuning Strategies & Availability GroupsRead at sqlpassion.at (opens in a new tab)
17 Apr 2023
SQL Server Quickie #45 – SQL Server Availability GroupsRead at sqlpassion.at (opens in a new tab)
21 Mar 2023
SQLpassion Live Training about SQL Server Query Tuning FundamentalsRead at sqlpassion.at (opens in a new tab)
7 Mar 2023
Windows Server 2022 KB5022842 crashes ESXi VMsRead at sqlpassion.at (opens in a new tab)
17 Feb 2023
SQL Server Quickie #44 – SQL Server on DockerRead at sqlpassion.at (opens in a new tab)
16 Jan 2023

2022

vscode-binutils: Analyzing Binary Files directly within Visual Studio CodeRead at sqlpassion.at (opens in a new tab)
30 Nov 2022
Configuring WSL on Windows Server 2022 for Visual Studio Code Remote AccessRead at sqlpassion.at (opens in a new tab)
3 Oct 2022
SQLpassion Live Training about SQL Server Availability GroupsRead at sqlpassion.at (opens in a new tab)
5 Sept 2022
Virtual Memory & x64 Long ModeRead at sqlpassion.at (opens in a new tab)
11 Aug 2022
Loading and executing the Second Stage Boot LoaderRead at sqlpassion.at (opens in a new tab)
25 Jul 2022
SQLpassion Live Training about Query Tuning FundamentalsRead at sqlpassion.at (opens in a new tab)
4 Apr 2022
Reading Files from a FAT12 PartitionRead at sqlpassion.at (opens in a new tab)
3 Mar 2022
Heap TablesRead at sqlpassion.at (opens in a new tab)
1 Mar 2022
Data Page RestrictionsRead at sqlpassion.at (opens in a new tab)
21 Feb 2022
Extent Management in SQL ServerRead at sqlpassion.at (opens in a new tab)
14 Feb 2022
Creating a distributed Service Broker application with DockerRead at sqlpassion.at (opens in a new tab)
7 Feb 2022
The Boot Process of a PC, and how to write your own Boot LoaderRead at sqlpassion.at (opens in a new tab)
3 Feb 2022
Data Pages – the Foundation of SQL ServerRead at sqlpassion.at (opens in a new tab)
31 Jan 2022
How SQL Server executes a QueryRead at sqlpassion.at (opens in a new tab)
25 Jan 2022

2021

https://www.sqlpassion.at/live-trainings/performance-tuning-workshop/Read at sqlpassion.at (opens in a new tab)
4 Nov 2021
My new Online Training: SQL Server Query Tuning Fundamentals – German EditionRead at sqlpassion.at (opens in a new tab)
18 Oct 2021
My upcoming Online Trainings and Speaking EngagementsRead at sqlpassion.at (opens in a new tab)
15 Sept 2021
Relaunching www.SQLpassion.atRead at sqlpassion.at (opens in a new tab)
5 Jul 2021
Older posts

194 posts from sqlpassion.at are held, newest first (corpus.blog, measured 17 October 2026).