A discussion on LinkedIn led to this hypothetical “real world” question: Problem statement: I have a SQL Server 2000 database backup that I need to… Read More »How do you restore a SQL Server 2000 database in the year 2024?
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
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
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
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
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
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
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
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
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
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
(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
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
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
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