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,… Read More »Just one more thing, an essay on troubleshooting
Home »
Configuration
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… Read More »Choco upgrade, y’all
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… Read More »Things to check when restoring a database
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,… Read More »Which configuration changes in SQL Server require a restart?
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… Read More »These are the extensions I have installed on Azure Data Studio
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… Read More »Installing SQL Server on Windows? Don’t forget these two useful switches
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
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… Read More »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… Read More »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… Read More »Proposed SQL Server defaults: cost threshold for parallelism
Fix SQL Server with one click
(This post was updated on 5 February 2022.) Tempting headline, isn’t it? It might even seem like clickbait, but that’s not the intention. The SQL… Read More »Fix SQL Server with one click
Updated Max Server Memory Script
Earlier this year I released a free T-SQL script that will calculate the correct amount of RAM you should allocate to SQL Server, assuming it is a… Read More »Updated Max Server Memory Script
Max Server Memory Revisited
Some time ago, I added a free resource to this site to help DBAs know how much max server memory should be assigned to SQL… Read More »Max Server Memory Revisited