Gerne, jederzeit. Ein Tipp vorneweg: Klaus Aschenbrenner (sqlpassion.at) hat eine ganze Menge Videos über den MSSQL gemacht. Ziemliche Spezialthemen, aber vielleicht auch interessant.
SQLpassion – SQLpassion provides high-quality SQL Server Consulting services for clients around Europe & the US
sqlpassion.at
July 12, 2024 at 3:25 PM
Gerne, jederzeit. Ein Tipp vorneweg: Klaus Aschenbrenner (sqlpassion.at) hat eine ganze Menge Videos über den MSSQL gemacht. Ziemliche Spezialthemen, aber vielleicht auch interessant.
Reading: Indexes on VARCHAR Columns - http://buff.ly/1rPAvnm
Indexes on VARCHAR Columns – SQLpassion
buff.ly
November 25, 2024 at 3:10 PM
Reading: Indexes on VARCHAR Columns - http://buff.ly/1rPAvnm
Check it out at github.com/SQLpassion/o...
GitHub - SQLpassion/osdev: This repository contains OS development specific code and tutorials
This repository contains OS development specific code and tutorials - SQLpassion/osdev
github.com
June 17, 2026 at 9:16 PM
Check it out at github.com/SQLpassion/o...
[Blog] Don’t Miss Out – SQL Server 2025 Unleashed Training Starts Next Monday! www.sqlpassion.at/archive/2026... #sqlserver #performance #ai #vector #hadr
Don’t Miss Out – SQL Server 2025 Unleashed Training Starts Next Monday! – SQLpassion
www.sqlpassion.at
March 2, 2026 at 11:51 AM
[Blog] Don’t Miss Out – SQL Server 2025 Unleashed Training Starts Next Monday! www.sqlpassion.at/archive/2026... #sqlserver #performance #ai #vector #hadr
[Blog] PostgreSQL Quickie #2: Installation in Virtual Machines: www.sqlpassion.at/archive/2026... #PostgreSQL #postgres #quickie #youtube
PostgreSQL Quickie #2: Installation in Virtual Machines – SQLpassion
www.sqlpassion.at
February 23, 2026 at 5:30 PM
[Blog] PostgreSQL Quickie #2: Installation in Virtual Machines: www.sqlpassion.at/archive/2026... #PostgreSQL #postgres #quickie #youtube
As a personal experiment, I rewrote my entire C-based x64 operating system from scratch in Rust (check-out the current state at github.com/sqlpassion/o...).
GitHub - SQLpassion/osdev: This repository contains OS development specific code and tutorials
This repository contains OS development specific code and tutorials - SQLpassion/osdev
github.com
February 18, 2026 at 12:59 PM
As a personal experiment, I rewrote my entire C-based x64 operating system from scratch in Rust (check-out the current state at github.com/sqlpassion/o...).
[Blog] The Linux Page Cache and PostgreSQL: www.sqlpassion.at/archive/2026... #PostgreSQL #postgres #linux #performance
The Linux Page Cache and PostgreSQL – SQLpassion
www.sqlpassion.at
February 17, 2026 at 9:38 AM
[Blog] The Linux Page Cache and PostgreSQL: www.sqlpassion.at/archive/2026... #PostgreSQL #postgres #linux #performance
[Blog] Where is My Clustered Index in PostgreSQL? www.sqlpassion.at/archive/2026... #PostgreSQL #postgres #sqlserver #performance
Where is My Clustered Index in PostgreSQL? – SQLpassion
www.sqlpassion.at
February 11, 2026 at 11:56 AM
[Blog] Where is My Clustered Index in PostgreSQL? www.sqlpassion.at/archive/2026... #PostgreSQL #postgres #sqlserver #performance
[Blog] Vector Capabilities with pgvector in PostgreSQL: www.sqlpassion.at/archive/2026... #PostgreSQL #postgres #vector #ai
Vector Capabilities with pgvector in PostgreSQL – SQLpassion
www.sqlpassion.at
February 4, 2026 at 12:13 PM
[Blog] Vector Capabilities with pgvector in PostgreSQL: www.sqlpassion.at/archive/2026... #PostgreSQL #postgres #vector #ai
[Blog] Don’t Miss Out - SQL Server Query Tuning Fundamentals Starts Next Monday! www.sqlpassion.at/archive/2026... #sqlserver #performance #troubleshooting #indexing
Don’t Miss Out – SQL Server Query Tuning Fundamentals Starts Next Monday! – SQLpassion
www.sqlpassion.at
February 2, 2026 at 2:48 PM
[Blog] Don’t Miss Out - SQL Server Query Tuning Fundamentals Starts Next Monday! www.sqlpassion.at/archive/2026... #sqlserver #performance #troubleshooting #indexing
[Blog] Spatial Data with PostGIS in PostgreSQL: www.sqlpassion.at/archive/2026... #postgres #PostgreSQL #gis #PostGIS
Spatial Data with PostGIS in PostgreSQL – SQLpassion
www.sqlpassion.at
January 26, 2026 at 11:14 AM
[Blog] Spatial Data with PostGIS in PostgreSQL: www.sqlpassion.at/archive/2026... #postgres #PostgreSQL #gis #PostGIS
[Blog] BRIN Indexes in PostgreSQL: www.sqlpassion.at/archive/2026... #sqlpassion #performance #PostgreSQL #postgres
BRIN Indexes in PostgreSQL – SQLpassion
www.sqlpassion.at
January 19, 2026 at 10:21 AM
[Blog] BRIN Indexes in PostgreSQL: www.sqlpassion.at/archive/2026... #sqlpassion #performance #PostgreSQL #postgres
SQL Server Query Tuning Fundamentals
February 9, 2026 · Live Online · 1 Day
Learn more about the training here:
www.sqlpassion.at/live-trainin...
#SQLServer #SQLpassion #Performance
February 9, 2026 · Live Online · 1 Day
Learn more about the training here:
www.sqlpassion.at/live-trainin...
#SQLServer #SQLpassion #Performance
SQL Server Query Tuning Fundamentals – SQLpassion
www.SQLpassion.at
January 15, 2026 at 3:28 PM
SQL Server Query Tuning Fundamentals
February 9, 2026 · Live Online · 1 Day
Learn more about the training here:
www.sqlpassion.at/live-trainin...
#SQLServer #SQLpassion #Performance
February 9, 2026 · Live Online · 1 Day
Learn more about the training here:
www.sqlpassion.at/live-trainin...
#SQLServer #SQLpassion #Performance
The problem isn’t effort.
It’s the lack of a clear mental model for how SQL Server actually executes queries.
That’s exactly what I’ll address in my upcoming live training.
It’s the lack of a clear mental model for how SQL Server actually executes queries.
That’s exactly what I’ll address in my upcoming live training.
SQL Server Query Tuning Fundamentals – SQLpassion
www.SQLpassion.at
January 15, 2026 at 3:28 PM
The problem isn’t effort.
It’s the lack of a clear mental model for how SQL Server actually executes queries.
That’s exactly what I’ll address in my upcoming live training.
It’s the lack of a clear mental model for how SQL Server actually executes queries.
That’s exactly what I’ll address in my upcoming live training.
If a SQL Server query is slow, it’s rarely random.
Most performance problems come from the same issue:
Execution plans that are misunderstood, misread, or ignored completely.
You add an index.
It helps - until it doesn’t.
Then you rewrite the query.
Then performance changes again.
Most performance problems come from the same issue:
Execution plans that are misunderstood, misread, or ignored completely.
You add an index.
It helps - until it doesn’t.
Then you rewrite the query.
Then performance changes again.
SQL Server Query Tuning Fundamentals – SQLpassion
www.SQLpassion.at
January 15, 2026 at 3:28 PM
If a SQL Server query is slow, it’s rarely random.
Most performance problems come from the same issue:
Execution plans that are misunderstood, misread, or ignored completely.
You add an index.
It helps - until it doesn’t.
Then you rewrite the query.
Then performance changes again.
Most performance problems come from the same issue:
Execution plans that are misunderstood, misread, or ignored completely.
You add an index.
It helps - until it doesn’t.
Then you rewrite the query.
Then performance changes again.
I’ve just published my 2nd #PostgreSQL Quickie:
PostgreSQL Quickie #2: Installation in Virtual Machines youtu.be/E-hDSoArqdI This is the 1st Quickie that I have entirely produced on Linux - even the editing (in DaVinci Resolve) and publishing.
Enjoy! 🙂
PostgreSQL Quickie #2: Installation in Virtual Machines youtu.be/E-hDSoArqdI This is the 1st Quickie that I have entirely produced on Linux - even the editing (in DaVinci Resolve) and publishing.
Enjoy! 🙂
PostgreSQL Quickie #2: Installation in Virtual Machines
YouTube video by SQLpassion
youtu.be
January 14, 2026 at 6:54 PM
I’ve just published my 2nd #PostgreSQL Quickie:
PostgreSQL Quickie #2: Installation in Virtual Machines youtu.be/E-hDSoArqdI This is the 1st Quickie that I have entirely produced on Linux - even the editing (in DaVinci Resolve) and publishing.
Enjoy! 🙂
PostgreSQL Quickie #2: Installation in Virtual Machines youtu.be/E-hDSoArqdI This is the 1st Quickie that I have entirely produced on Linux - even the editing (in DaVinci Resolve) and publishing.
Enjoy! 🙂
I've published one about GiST indexes last week: www.sqlpassion.at/archive/2026...
GiST and SP-GiST Indexes in PostgreSQL – SQLpassion
www.sqlpassion.at
January 12, 2026 at 9:40 PM
I've published one about GiST indexes last week: www.sqlpassion.at/archive/2026...
[Blog] GIN Indexes in PostgreSQL: www.sqlpassion.at/archive/2026... #sqlpassion #postgres #PostgreSQL
GIN Indexes in PostgreSQL – SQLpassion
www.sqlpassion.at
January 12, 2026 at 12:57 PM
[Blog] GIN Indexes in PostgreSQL: www.sqlpassion.at/archive/2026... #sqlpassion #postgres #PostgreSQL
[Blog] Level Up Your Skills in 2026: Live Online Trainings for Database & Infrastructure Professionals: www.sqlpassion.at/archive/2026... #sqlpassion #sqlserver #postgres #PostgreSQL
Level Up Your Skills in 2026: Live Online Trainings for Database & Infrastructure Professionals – SQLpassion
www.sqlpassion.at
January 7, 2026 at 10:23 AM
[Blog] Level Up Your Skills in 2026: Live Online Trainings for Database & Infrastructure Professionals: www.sqlpassion.at/archive/2026... #sqlpassion #sqlserver #postgres #PostgreSQL
[Blog] GiST and SP-GiST Indexes in PostgreSQL: www.sqlpassion.at/archive/2026... #sqlpassion #postgres #PostgreSQL
GiST and SP-GiST Indexes in PostgreSQL – SQLpassion
www.sqlpassion.at
January 5, 2026 at 1:38 PM
[Blog] GiST and SP-GiST Indexes in PostgreSQL: www.sqlpassion.at/archive/2026... #sqlpassion #postgres #PostgreSQL
Today, I’m excited to announce the lineup for my upcoming SQLpassion online trainings for the next 6 months, featuring several brand-new trainings I’ve been developing over the past few months: www.sqlpassion.at/live-trainin... #sqlpassion #sqlserver #postgres #postgresql
January 1, 2026 at 5:00 PM
Today, I’m excited to announce the lineup for my upcoming SQLpassion online trainings for the next 6 months, featuring several brand-new trainings I’ve been developing over the past few months: www.sqlpassion.at/live-trainin... #sqlpassion #sqlserver #postgres #postgresql
[Blog] Hash Indexes in PostgreSQL: www.sqlpassion.at/archive/2025... #PostgreSQL #postgres #sqlpassion #performance #indexing
Hash Indexes in PostgreSQL – SQLpassion
www.sqlpassion.at
December 22, 2025 at 4:58 PM
[Blog] Hash Indexes in PostgreSQL: www.sqlpassion.at/archive/2025... #PostgreSQL #postgres #sqlpassion #performance #indexing
I’m looking forward to speak tomorrow a whole day long about the improvements in SQL Server 2025 - and about things which are not working as expected 🫢 #sqlserver #sqlpassion
December 9, 2025 at 3:54 PM
I’m looking forward to speak tomorrow a whole day long about the improvements in SQL Server 2025 - and about things which are not working as expected 🫢 #sqlserver #sqlpassion
[Blog] New on YouTube: PostgreSQL Introduction for the SQL Server Professional: www.sqlpassion.at/archive/2025... #sqlpassion #PostgreSQL #postgres
New on YouTube: PostgreSQL Introduction for the SQL Server Professional – SQLpassion
www.sqlpassion.at
December 1, 2025 at 2:13 PM
[Blog] New on YouTube: PostgreSQL Introduction for the SQL Server Professional: www.sqlpassion.at/archive/2025... #sqlpassion #PostgreSQL #postgres