SqlServer

Find-DbaInstance

Scott Sutherland, 2018 NetSPI | Friedrich Weinmann (@FredWeinmann)

Find-DbaInstance View Source Scott Sutherland, 2018 NetSPI , Friedrich Weinmann (@FredWeinmann) Windows, Linux, macOS Synopsis Discovers SQL Server instances across networks using multiple scanning methods Description This function performs comprehensive SQL Server instance discovery across your network infrastructure using multiple detection methods. Perfect for creating complete SQL Server inventories, compliance auditing, and finding forgotten or undocumented instances that might pose security risks. The function combines two distinct phases to systematically locate SQL Server instances:

Get-DbaService

Klaas Vandenberghe (@PowerDbaKlaas)

Get-DbaService View Source Klaas Vandenberghe (@PowerDbaKlaas) Windows, Linux, macOS Synopsis Retrieves SQL Server-related Windows services from local or remote computers. Description Retrieves detailed information about SQL Server-related Windows services across one or more computers, including Database Engine, SQL Agent, Reporting Services, Analysis Services, Integration Services, and other SQL Server components. This function replaces manual service management tasks by providing a unified view of service status, startup modes, and service accounts across your SQL Server environment.

Start-DbaService

Kirill Kravtsov (@nvarscar)

Start-DbaService View Source Kirill Kravtsov (@nvarscar) Windows, Linux, macOS Synopsis Starts SQL Server related services across multiple computers while respecting service dependencies. Description Starts SQL Server services (Engine, Agent, Browser, FullText, SSAS, SSIS, SSRS) on one or more computers following proper dependency order. This function handles the complexity of starting services in the correct sequence so you don’t have to manually determine which services depend on others. Commonly used after maintenance windows, server reboots, or when troubleshooting stopped services across an environment.

Update-DbaServiceAccount

Kirill Kravtsov (@nvarscar)

Update-DbaServiceAccount View Source Kirill Kravtsov (@nvarscar) Windows, Linux, macOS Synopsis Changes the service account or password for SQL Server Engine and Agent services. Description Updates the service account credentials or changes just the password for SQL Server Engine and Agent services. When changing the service account, the affected service will be automatically restarted to apply the changes. Password-only updates don’t require a restart unless you want the changes to take effect immediately.