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?

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

Post image

Configuration Manager Shortcut on Windows 10 and Server 2016

(Last updated 2020-01-07) This is more for my own reference than anything. On newer versions of Windows desktop and Windows Server, we may find that the shortcut to SQL Server Configuration Manager is missing. According to Microsoft Docs, the reason for this change is that Configuration Manager is a Management Console snap-in: Because SQL Server
-> Continue reading Configuration Manager Shortcut on Windows 10 and Server 2016