Which command would find all SQL services running on a Windows server?

Which command would find all SQL services running on a Windows server?

• A. Get-Service -Name SQLServer
• B. Get-Service sql*
• C. Query-Service -Name SQL*
• D. Get-Process SQLServer

Answer: (B)

PowerShell can query Windows services directly with Get-Service, and you can filter what you get by using a wildcard for the service name. Using a pattern that starts with sql matches all SQL-related services whose internal names begin with sql, so you gather every SQL service in one command rather than hunting each by name. This leverages the Service Control Manager, returning service objects you can inspect or filter further (for example, to show only those currently running). Using a specific exact name would miss other SQL components, and Get-Process would list running processes, not services, so it isn’t appropriate here. Query-Service isn’t a standard PowerShell cmdlet, so it wouldn’t reliably retrieve the services either.

PowerShell can query Windows services directly with Get-Service, and you can filter what you get by using a wildcard for the service name. Using a pattern that starts with sql matches all SQL-related services whose internal names begin with sql, so you gather every SQL service in one command rather than hunting each by name. This leverages the Service Control Manager, returning service objects you can inspect or filter further (for example, to show only those currently running). Using a specific exact name would miss other SQL components, and Get-Process would list running processes, not services, so it isn’t appropriate here. Query-Service isn’t a standard PowerShell cmdlet, so it wouldn’t reliably retrieve the services either.