Development & Performance

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(…)

What is Forgejo and getting it up and running on FreeBSD 15

In recent customer projects I had less to do with PostgreSQL but more with reviewing infrastructures and give recommendations about what and how to improve. In all of those projects GitLab is used in one(…)

How effective is AI on a development project?

In this article, I will try to evaluate the benefits of AI on a development project and what concrete changes it makes to our development practices. The test case and the approach I chose a familiar environment for(…)

Understanding XML performance pitfalls in SQL Server

A deep dive into how SQL Server processes XML, the performance impact of XQuery methods, and why proper indexing matters.

Avoid CORS requests in development mode with Vite

When developing a modern web application, it’s common to use a frontend (Vue, React) that communicates with a backend (Nest.js) via REST APIs. Often, the two projects live in parallel, requiring them to be run in development mode. Without(…)

SQL Server 2025 release

Microsoft has announced the release of SQL Server 2025. The solution can be downloaded using the following link: https://www.microsoft.com/en-us/sql-server/ Among the new features available, we have: The introduction of the Standard Developer Edition, which offers the same(…)