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… You should be running on SQL Server 2022
One of my hobbies is trying to break technology so that you don’t have to. I don’t consider myself a professional or hobbyist hacker, though if the shoe fits… Last year when Windows Server 2019… Unsupported but working versions of SQL Server on Windows Server 2019
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).
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 memory defaults in 2019
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… Better SQL Server CPU defaults in 2019
Next month, Microsoft is ending five years of extended support on SQL Server 2008 and SQL Server 2008 R2. This follows five years of mainstream support before that. You really should be upgrading to SQL… SQL Server 2008 and 2008 R2 is end of life on 9 July 2019
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. |￣￣￣￣￣￣￣|| CONTAINERS || ARE NOT | | VIRTUAL || MACHINES ||… What is a container anyway?
Here’s an interesting story for you this week. As part of the new Intelligent Query Processing improvements introduced in the upcoming SQL Server 2019, we find a new feature called scalar UDF inlining. This post… The case of scalar UDF inlining, where context is everything
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.… It’s a UNIX system. I know this.
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… Does SQL Server 2019 run on Ubuntu 18.04 LTS?
Since the release of SQL Server 2008 Service Pack 1 in April 2009, it has been possible to install SQL Server with media that includes the latest patches, whether they be Service Packs (for SQL… Create a slipstream installer for SQL Server on Windows
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 2017 Administration Inside Out
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 Management Studio v17.0
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,… SQL Server 2017 Announced
(This post was last updated on 1 August 2022.) Everything changed for SQL Server Standard Edition on 16 November 2016, and how memory limits work. On that day, a slew of Enterprise Edition features made… Max Server Memory and SQL Server 2016 Service Pack 1