Changing configurations
PowerShell can help not only audit your current instance configurations, but can also help if you need to manage and change configurations, such as changing service accounts and default backup folders and turning on (or off) some instance- and database-level features.
Start or stop services
There are a handful cmdlets that work with services. To get these cmdlets, you can use the following command:
Get-Command -Name "*Service*" -CommandType "Cmdlet"
The result you will get is similar to the following screenshot:
To start or stop services, you can use the Start-Service and Stop-Service cmdlets. The following snippet is an example ...
Get PowerShell for SQL Server Essentials now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
