Skip to content

You should be running on SQL Server 2022

It’s me again with my apparently semi-annual blog post. This time we’re going to talk about which version of SQL Server you should be on, now that we’re at the end of 2023. Which version… 

SQL Server 2019 on Docker no longer runs as root by default

  • by

In my home lab I have an Ubuntu virtual machine that runs both SQL Server 2017 and SQL Server 2019 in Docker containers.

After SQL Server 2019 Release Candidate 1 was released, when I performed my usual migration to get the latest version, I noticed that the command line for the SQL Server instance was different.

I used sudo docker ps -a --no-trunc to see the full command, which is emulated below (note: this output is heavily abbreviated).

Better SQL Server memory defaults in 2019

  • by

In 2016 I created the Max Server Memory Matrix as a guide for configuring the maximum amount of memory that should be assigned to SQL Server, using an algorithm developed by Jonathan Kehayias. SQL Server 2019… 

Better SQL Server CPU defaults in 2019

  • by

SQL Server 2019 is still in preview as I write this, but I wanted to point out a new feature that Microsoft has added to SQL Server Setup, on the Windows version. On the Database… 

What is a container anyway?

  • by

Recently there was a thread on Twitter which established that a lot of IT people didn’t know the difference between virtual machines and containers. https://twitter.com/IanColdwater/status/1137737702227550208 I felt like this was a question I’d already answered,… 

It’s a UNIX system. I know this.

  • by

Jurassic Park was a great film. Steven Spielberg brought technology into the film era in a major way with computer generated dinosaurs and some now-classic film lines, many of which came from Jeff “Dreamboat” Goldblum.… 

Does SQL Server 2019 run on Ubuntu 18.04 LTS?

  • by

Edit from 19 March 2020: Since the release of CU 3, SQL Server 2019 is officially supported on Ubuntu 18.04, per this blog post. Original post continues below. Yes. Here’s the proof from an output… 

SQL Server 2017 Administration Inside Out

  • by

For the last five months or so, I have been helping some really smart people put words on paper, both the physical and electronic kind, which is hopefully going to culminate in an actual technical… 

SQL Server Management Studio v17.0

Version numbers are confusing. SQL Server Management Studio (SSMS), the client user interface by which most DBAs access SQL Server, was decoupled from the server product for SQL Server 2016. For the last 18 months… 

SQL Server 2017 Announced

By now you will have heard that the next version of SQL Server has been announced. There’s no release date yet, but Brent Ozar seems to think it’ll be before June. There are many new features,…