Blog

Archive:

Search site:

Tags:

Compilation (1) Concurrency (3) docker (2) Execution Plans (6) Identity (1) Indexes (2) internals (11) linux (4) Optimization (6) Parameterization (1) Performance (9) Performance Tuning (2) postgres (6) RCSI (2) sql (1) SQL Server (24) Statistics (2) Stored Procedures (1) Transactions (1) Version Store (2)

Categories:

Docker (2) Linux (4) PostgreSQL (6) SQL Server (24)

Month: July 2026

  • Four Flavours of Postgres Install – Part 3 (Docker Container, Windows Host)

    Four Flavours of Postgres Install – Part 3 (Docker Container, Windows Host)

    Last Updated: July 29, 2026 In this series, we’ve been working through the different ways to install PostgreSQL. In Part 3, we move into the Windows world and will install PostgreSQL as a Docker container. Unlike Part 2, where the host was a Linux machine, this time, the host is a Windows server. The VM…

    Keep reading

  • KILL and Query Store

    KILL and Query Store

    I love Query Store. I like to think of it as SQL Server’s built-in monitoring tool and I use it a lot to look at query history in terms of run times and IO metrics. One thing I learned about Query Store recently is how it deals with queries that have been killed. Setting up…

    Keep reading

  • Four Flavours of Postgres Install – Part 2 (Docker Container, Linux Host)

    Four Flavours of Postgres Install – Part 2 (Docker Container, Linux Host)

    In the last post, the first in this series about installing PostgreSQL, we looked at how to install PostgreSQL on Linux. This post is an alternative install method where we’ll look at how to install PostgreSQL on a Docker container, where the container is run on a Linux host. As before, we’ll run through the…

    Keep reading

  • Transaction Types

    This post is just a quick reference post that outlines the three different types of transaction in Microsoft SQL Server. AutoCommit The default. Each statement in a batch works as though it had been individually wrapped in BEGIN TRAN / COMMIT so the following code block: is effectively the same as: This moves us nicely…

    Keep reading

  • Four Flavours of Postgres Install – Part 1 (Linux)

    Four Flavours of Postgres Install – Part 1 (Linux)

    This is the first post in a short series documenting the various methods of installing PostgreSQL. In this post, we’ll look at how to install PostgreSQL natively on Linux and connect to the cluster we install from a remote client. The VM Firstly, let’s create a VM to install PostgreSQL on. I won’t detail the…

    Keep reading

  • Cross Database Deferred Name Resolution

    Cross Database Deferred Name Resolution

    I have been aware of temporary stored procedures in Microsoft SQL Server for a long time but never really had cause to use them, however, recently a need arose. I was testing what effect some index changes would have on a particular stored procedure. The testing was on a non-production server, and when I went…

    Keep reading

  • #tsql2sday #200

    #tsql2sday #200

    This post is my first T-SQL Tuesday post since starting the blog a couple of months back. T-SQL Tuesday was originally set up by Adam Machanic, original creator of the essential sp_whoisactive stored procedure. The concept is that once a month, a different host puts out an invitation to the community for bloggers to write…

    Keep reading

  • SQL Server – See What’s Executing Now With DMVs

    SQL Server – See What’s Executing Now With DMVs

    Last Updated: July 7, 2026 In SQL Server, there are a few DMVs that tell us “What is running now”. This is built into SSMS as Activity Monitor, but I’ve never met anyone who actually finds that method useful, there’s also sp_who and sp_who2, but they are dated and limited in what they tell you.…

    Keep reading