In this post I cover the steps required to change (downgrade or upgrade) the edition of a SQL Server instance running on Linux. In my previous post I’ve went through …

Previously I’ve set up an Ubuntu 24.04 VM, so I figured I’d cover the process of setting up SQL Server 2025 on Ubuntu 24.04. The post is mainly aimed toward …

I needed a fresh Ubuntu VM in VirtualBox this weekend so I figured I can take this opportunity to refresh my PowerShell based process. Prerequisites For this VM I’m using …

This is my first time participating in T-SQL Tuesday, and Louis Davidson‘s invitation about learning from mistakes seemed like the perfect opportunity. Backstory To no one’s surprise, I wasn’t always …

In this post I cover some unpleasant side-effects of using heaps in SQL Server for anything else than staging tables. In the past couple of months I’ve been running into …

I recently ran into SQL Server’s page compression being applied to a heap, and I figured I’d cover why that won’t work how some folks expect. SQL Server’s page compression …

In this post I demo a PowerShell script I wrote to extract and decrypt SSMS 21 and 22 saved connection information. This script builds on the one for importing saved …

I wasn’t really planning on writing a blog post today, but I got curios if there’s any way in which connections saved in SQL Server Management Studio 21 can be …

SQL Server Management Studio 22 just went GA this week, so I figured I’d document my new configuration in a blog post. A while ago I made a post about …