An keyboard and mouse

Just one more thing, an essay on troubleshooting

Over the weekend I watched — for the first time in my life — an episode of the long-running ABC and NBC police show Columbo, starring Peter Falk. I originally knew him from the film The Princess Bride (fun fact: I acted in a film directed by Buttercup herself, Robin Wright). I’ve been hearing a
-> Continue reading Just one more thing, an essay on troubleshooting

Chocolatey logo - 11 years old

Choco upgrade, y’all

Chocolatey is a package manager for Windows, like the built-in package managers on Linux, and third-party ones on macOS like Homebrew and MacPorts. The idea is this: when you’re setting up a machine, you don’t want to have to think about which applications you need installed to get up and running. This could be a
-> Continue reading Choco upgrade, y’all

yes

Things to check when restoring a database

Whenever I restore a database — especially one I obtained outside of my regular environment (for example a customer database, a development database, or even a sample database like WideWorldImporters) — there are a few things I like to check to make sure it’s configured for peak performance. Note that some of this advice may
-> Continue reading Things to check when restoring a database

A gaming console remote showing settings buttons

Which configuration changes in SQL Server require a restart?

SQL Server is a complex beast, with many configuration options that can range from recommended to completely avoided. Since the release of SQL Server 2016, several options that were recommended post-install have been rolled into the default installation options and no longer need to be done, and similar changes were made with SQL Server 2017.
-> Continue reading Which configuration changes in SQL Server require a restart?

Azure Data Studio logo

These are the extensions I have installed on Azure Data Studio

At last week’s presentation to the Edmonton SQL Server user group, I spoke at length about the many extensions that are available for Azure Data Studio, and was asked by Chris Wood to share all the extensions I use. It’s worth mentioning that for the most part Azure Data Studio extensions are extremely lightweight, both
-> Continue reading These are the extensions I have installed on Azure Data Studio

close-up photo of audio mixer with red dim light

Installing SQL Server on Windows? Don’t forget these two useful switches

A few days ago on Twitter I wrote: Couldn’t connect to new SQL Server install because I forgot to enable TCP/IP. I’m the lead author for a Microsoft Press book about SQL Server administration. Aside from demonstrating that checklists are helpful, it did raise an interesting point about why this isn’t a configurable option in
-> Continue reading Installing SQL Server on Windows? Don’t forget these two useful switches

Proposed SQL Server defaults: max server memory

(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 Server instances: Set cost threshold for parallelism to 50 Disable lightweight pooling if it is enabled Disable priority boost if it is enabled Set optimize for ad hoc workloads to
-> Continue reading Proposed SQL Server defaults: max server memory

Proposed SQL Server defaults: disable priority boost

(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 Server instances: Set cost threshold for parallelism to 50 Disable lightweight pooling if it is enabled Disable priority boost if it is enabled Set optimize for ad hoc workloads to
-> Continue reading Proposed SQL Server defaults: disable priority boost

Proposed SQL Server defaults: disable lightweight pooling

(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 Server instances. Set cost threshold for parallelism to 50 Disable lightweight pooling if it is enabled Disable priority boost if it is enabled Set optimize for ad hoc workloads to
-> Continue reading Proposed SQL Server defaults: disable lightweight pooling

Proposed SQL Server defaults: cost threshold for parallelism

(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 Server instances: Set cost threshold for parallelism to 50 Disable lightweight pooling if it is enabled Disable priority boost if it is enabled Set optimize for ad hoc workloads to
-> Continue reading Proposed SQL Server defaults: cost threshold for parallelism