Development & Performance

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

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

SQL Server’s LinkedIn Posts catch-up!

You may not have followed all my posts this summer about what we are doing with Microsoft SQL Server technology and the BI stack like Power BI and Azure Data Fabric. So, I thought I’d write a little catch-up blog(…)

APEX IR Subscriptions #JoelKallmanDay

Interactive Reports allow to send their content per e-mail on a regular basis thanks to the subscription feature. But this can also raise some security concerns. Let’s see how to bring some kind of control into the game… Requirements We(…)

MongoDB Log Analysis : A Comprehensive Guide

Contrary to other DBMS, MongoDB self-managed deployments generate logs in a JSON format, which can be quite intimidating at first. But instead of hoping to never have to look at the logs, you can use some tools and tips(…)

SQL Server 2025: Where Data Meets Intelligence

The evolution of AI is booming and brings many new possibilities to enhance efficiency and convenience with many different use cases. While AI chatbots have had an almost revolutionary influence in recent years, we are now entering the next phase(…)

Customer case study – Partition switching and transactional replication

The client’s environment includes two SQL Server instances (I1 and I2). One of the databases, D1 (on I1), is replicated to I2 via transactional replication. Additionally, the tables in this database are partitioned. The largest table (which is the one(…)

SQL Server 2025 – Optimized Locking

Within the past few days I was investigating one of the new features of SQL Server 2025: Optimized Locking. I was curious about the capabilities, the behaviour and as well the limits of the feature. Optimized Locking is based on(…)

SQL Server 2025 – OPTIMIZED_SP_EXECUTESQL

Within the past few days I was investigating another new feature of SQL Server 2025: OPTIMIZED_SP_EXECUTESQL. I was curious about the capabilities and the behaviour. OPTIMIZED_SP_EXECUTESQL is a database scoped configuration which allows us to get rid of the overhead(…)

SQL Server 2025: Local SQL Server Container – Schema design preview

After my blogs about “SQL Server 2025: Local SQL Server Container without Docker Command” and “SQL Server 2025: Local SQL Server Container – Schema compare preview”, I continue to play & test it. One new feature in preview(…)