Development & Performance

SQL Server: Stop ordering index columns by selectivity

Column order does not affect equality seeks in SQL Server. Measured on 5M rows, then proven inside the B-tree pages.

Why UUIDv7 does not reduce fragmentation in SQL Server

UUIDv7 places its timestamp first, but SQL Server compares uniqueidentifier values starting from the last bytes. Measured on 25,000 inserts: no gain over NEWID().

Green SQL Server DBA Tips #2 – When logs and history records cause your database to growth and crash

How often do I come across this sort of problem when visiting clients? Even more with our customers’ service desk (support) SLAs. We turn up on a Monday morning and there are alerts from the weekend saying(…)

Split, Sort, Collapse: how SQL Server survives an overlapping unique update

How SQL Server shifts a whole unique column by +1 without ever creating a duplicate using Split/Sort/Collapse.

Measuring the real performance cost of SQL Server XE buffers

Are Extended Events always lightweight? See how a bad config converts event loss into query latency through DMVs.

How Row Goal shapes your SQL Server query strategy by hunting for pierogis

Mastering SQL Server Row Goals and how TOP, EXISTS, and FAST N influence execution plans and how to avoid performance traps in your queries(…)

SQLDay 2026 Workshops Overview

SQLDay 2026 offers a full-day workshop program on 11 May 2026, before the main conference scheduled for 12–13 May 2026 in Wrocław, with onsite and online participation options depending on the session. The workshops cover several areas(…)

SQL Server 2025 In-Memory: New Cleanup Features & SQLBits 2026 Insights

SQL Server 2025 finally allows dropping In-Memory filegroups, a breakthrough analyzed here alongside expert performance insights from SQLBits 2026.

Forgejo: Organizations, Repositories and Actions

In the last post we’ve deployed Forgejo on FreeBSD 15. In this post we’re going to do something with it and that is: We’ll create a new organization, a new repository, and finally we want(…)

AI Isn’t Your Architect: Real-World Issues in a Vue project

In my previous article I generated a Rest NestJS API using AI. Today, I will create a small UI to authenticate users via the API. I will use this simple case to show the limits of coding with(…)