SQLpassion BLOG

Creating a distributed Service Broker application with Docker

As you might know, I have written a long time ago a book about Service Broker – a technology within SQL Server that almost nobody is aware of and interested in. But Service Broker provides you an elegant way to implement reliable, distributed, message-based applications directly within the database. One of the hardest things to …

Creating a distributed Service Broker application with Docker + read more

The Boot Process of a PC, and how to write your own Boot Loader

As you know, I’m a technical person, and I always want to know how technology works on the lowest possible level. This approach gives me a better understanding how modern software works, and how to troubleshoot some specific problems – like performance problems in the context of SQL Server. For that reason, I have already …

The Boot Process of a PC, and how to write your own Boot Loader + read more

Data Pages – the Foundation of SQL Server

Last week we laid out the foundation for how SQL Server executes queries. I have also already talked here a little bit about pages that are buffers of 8kb. Today we concentrate further on these pages and drill into more detail and what it means from a performance tuning perspective. Pages are the foundation of …

Data Pages – the Foundation of SQL Server + read more