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 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.
New-DbaAzAccessToken View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Generates OAuth2 access tokens for Azure SQL Database and other Azure services authentication.
Description Creates OAuth2 access tokens for connecting to Azure SQL Database and other Azure services without storing passwords in scripts. Supports Managed Identity authentication from Azure VMs, Service Principal authentication for applications, and renewable tokens for long-running connections. The generated tokens can be used directly with Connect-DbaInstance and other dbatools commands to establish secure, modern authentication to Azure resources.
New-DbaConnectionString View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Creates connection strings for SQL Server instances using PowerShell-friendly parameters
Description Creates properly formatted SQL Server connection strings without having to manually construct complex connection string syntax. Instead of remembering obscure keywords like “Data Source” or “Initial Catalog”, you can use familiar PowerShell parameters like -SqlInstance and -Database.
This function handles the complexity of connection string building for you, including authentication methods (Windows, SQL Server, Azure AD), encryption settings, timeout values, and Azure SQL Database specifics.
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 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.
dbatools