Skip to content

Core Functions

Scott Sutherland edited this page Oct 27, 2016 · 3 revisions

These functions are used to test connections, execute SQL Server queries, and execute OS commands. All other functions use these core functions. However, they can also be executed independently.

Function Name Description
Get-SQLConnectionTest Tests if the current Windows account or provided SQL Server login can log into an SQL Server.
Get-SQLConnectionTestThreaded Tests if the current Windows account or provided SQL Server login can log into an SQL Server and supports threading.
Get-SQLQuery Executes a query on target SQL servers.
Get-SQLQueryThreaded Executes a query on target SQL servers and supports threading.
Invoke-SQLOSCmd Execute command on the operating system as the SQL Server service account using xp_cmdshell. Supports threading, raw output, and table output.

Examples:

Get-SQLInstanceDomain -Verbose | Get-SQLConnectionTestThreaded -Verbose -Threads 10 
Get-SQLInstanceDomain -Verbose | Invoke-SQLOSCmd -Verbose -Threads 10 -Command "whoami"

RoadMap

Add Encrypt option to core functions
Add ApplicationName option to core functions
Add PacketSize option to core functions
Add ForceNamedPipe option to core functions
https://gist.githubusercontent.com/nullbind/91c573b0e27682733f97d4e6eebe36f8/raw/b37e5fc6ee115a980fe248927e0646429122b7a2/SQL%2520Server%2520Connection%2520Strings%2520CheatSheet

Introduction

Cheat Sheets

PowerUpSQL Blogs

PowerUpSQL Talks

PowerUpSQL Videos

Function Categories

Clone this wiki locally
You can’t perform that action at this time.