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,… Read More »You should be running on SQL Server 2022
Home »
Compatibility
SQL Server 2019 on Apple Silicon redux: it actually works
Edited on 12 January 2023: You can run a SQL Server Docker container on Apple M1 and M2 Silicon Last month I wrote a blog post… Read More »SQL Server 2019 on Apple Silicon redux: it actually works
You can’t run SQL Server on Apple Silicon, and it sucks
Edited on 12 January 2023: You can run a SQL Server Docker container on Apple M1 and M2 Silicon Prior to 2017, the only way to… Read More »You can’t run SQL Server on Apple Silicon, and it sucks
Deprecated and discontinued features in SQL Server
My co-authors and I recently wrapped up the book SQL Server 2019 Administration Inside Out, which should be hitting the shelves in the next week… Read More »Deprecated and discontinued features in SQL Server
Accelerated Database Recovery in SQL Server 2019: Choose your own filegroup for the version store
An exciting new feature in SQL Server 2019 is Accelerated Database Recovery (ADR). Resulting from a combination of magic beans and smart software developers (I… Read More »Accelerated Database Recovery in SQL Server 2019: Choose your own filegroup for the version store
Better SQL Server memory defaults in 2019
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,… Read More »Better SQL Server memory defaults in 2019
Better SQL Server CPU 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… Read More »Better SQL Server CPU defaults in 2019
SQL Server 2008 and 2008 R2 is end of life on 9 July 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… Read More »SQL Server 2008 and 2008 R2 is end of life on 9 July 2019
Containers and data: you gotta keep ’em separated
There was an interesting conversation on Twitter recently, between Grant Fritchey (blog | twitter), Kenneth Fisher (blog | twitter), Anthony E. Nocentino (blog | twitter),… Read More »Containers and data: you gotta keep ’em separated
SQL Server containers no longer being updated in the Docker registry
In October 2018, Microsoft announced a change to the source of their Docker containers. You should be using the new Microsoft Container Registry (MCR) as… Read More »SQL Server containers no longer being updated in the Docker registry
Proposed SQL Server defaults: max server memory
(This post was updated on 1 August 2022.) A few months ago I suggested that the following settings should be the default for most SQL… Read More »Proposed SQL Server defaults: max server memory
The easy way to handle UTF-8 in a .NET application when dealing with SQL Server 2019
A short post this week. On a mailing list recently, someone noticed that a .NET application writing to SQL Server did not have the expected… Read More »The easy way to handle UTF-8 in a .NET application when dealing with SQL Server 2019
A short Azure SQL Edge explainer
On Thursday May 2nd, 2019, Microsoft announced a new edition of SQL Server targeting Internet of Things (IoT) edge devices. That means SQL Server can… Read More »A short Azure SQL Edge explainer
The case of scalar UDF inlining, where context is everything
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… Read More »The case of scalar UDF inlining, where context is everything
Proposed SQL Server defaults: optimize for ad hoc workloads
(This post was updated on 5 February 2022.) A few months ago I suggested that the following settings should be the default for most SQL… Read More »Proposed SQL Server defaults: optimize for ad hoc workloads