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

Do you even PowerShell, bro? An ode to dbatools and dbachecks.

Shall I compare thee to Management Studio? Thou art more scriptable and consistent. Those out-of-memory errors do tend to lose hours of work. And I mean, SSMS doesn’t run from the command line. Sometimes I get those line-endings errors, Not to mention IntelliSense bombing out; And figuring out which tab I was in can be
-> Continue reading Do you even PowerShell, bro? An ode to dbatools and dbachecks.