Setting Drive Allocation Unit Size With PowerShell
There seems to be some ongoing debate around whether or not formatting your data and log drives with 64KB allocation unit size even matters anymore. I would encourage you to …
Setting Up Database Mail And SQL Agent Alerts With PowerShell
As a DBA, you need to know when there’s a problem on your SQL Servers. And while I highly recommend you use a full-fledged monitoring system, there are also some …
Disable Telemetry On Multiple SQL Servers With PowerShell
Starting with SQL Server 2016, when you install SQL Server it also installs the CEIP (Customer Experience Improvement Program) Services, also known at Telemetry. In previous versions of SQL Server …
Configuring Database Data And Log Files
One of the things that Database Administrators typically do is configure the Data and Log file growth settings for the databases on their servers. While these configurations vary by server …