SQL Server

The truth about nested transactions in SQL Server

Nested transactions in SQL Server don’t provide real isolation; @@TRANCOUNT rises, but only the main transaction controls locks.

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.

Common queries on a SQL Server environment for a DBA

This blog will be for queries we use for minor everyday problems. This blog will address issues related to disk space, SID for SQL login, and index fragmentation.. For this blog, you will only need SSMS and sysadmin rights on(…)

Customer experience – How to change ip address in a fully clustered environment

If you have a clusturized environment already up and running, but you want or need change the complete ip adress of your wall with minimal downtime (full downtime during operation: 3 min). You’re in the right place, I will show(…)

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

SQL Server: Do you know how to use SERVERPROPERTY()  function in a useful way?

The SERVERPROPERTY() function is so nice to use to have information about the instance and server very quickly. Sometimes it’s good to come back to basis… How to begin? Read the documentation of course here but you will see(…)

How to patch SQL Server instances with Qualys Patch Management

By one of our Customers, I have to use Qualys to patch their production SQL Server instances. And to be more precise the Qualys Patch Management application which provides a solution to manage vulnerabilities and deploy patches to secure(…)

SQL-Server 2025: Vector Indexes & Semantic Search Performance

When performing search operations on large datasets, performance is a key consideration for ensuring that an application remains efficient and user-friendly. This consideration equally applies when working with embedded data. That’s why in this blog post we’ll explore the different(…)

SQL-Server 2025: Generate Data Embeddings for Semantic Search

In this Blog we will continue with our AI journey in SQL-Server 2025 preview. If you didn’t read the first Blog you’ll find it here: dbi Blog  In this article, we will explore the concept of data embeddings, a(…)