Home

sqlcmdcli wiki!

sqlcmdcli utility is a command-line utility for ad hoc, interactive execution of commands on SQL Server to simulate specific workloads, anonymize sensitive data and much more.

Installation

You can find installation instructions on our README.

Commands

anonymizedb (anondb)

Anonymize all text columns longer than two characters!

sqlcmdcli.exe anonymizedb {options} [flags]

sqlcmdcli.exe anondb {options} [flags]

Options

-servername: (-s:) SQL Server instance name

-databasename: (-d:) Database name

-username: (-u:) SQL Server username

-password: (-p:) Password

Options inherited from parent commands

-help Shows help for the command

Flags

-verbose Shows details about the results of running

Examples

sqlcmdcli.exe anonymizedb -servername:BEER -databasename:WideWorldImporters -username:YourUserName -password:YourPassword -verbose

sqlcmdcli.exe anondb -s:BEER -d:WideWorldImporters -u:YourUserName -p:YourPassword

querystoreworkload (qsw)

Runs a specific workload to reproduce a query's regression. It can be used to analyze the regression of a query with the SQL Server Query Store. Once the regression has been identified, it is possible to proceed with the manual forcing of the optimal execution plan

sqlcmdcli.exe querystoreworkload {options} [flags]

sqlcmdcli.exe qsw {options} [flags]

Options

-servername: (-s:) SQL Server instance name

-databasename: (-d:) Database name

-username: (-u:) SQL Server username

-password: (-p:) Password

Options inherited from parent commands

-help Shows help for the command

Flags

-verbose Shows details about the results of running

Examples

sqlcmdcli.exe querystoreworkload -servername:BEER -databasename:WideWorldImporters -username:YourUserName -password:YourPassword -verbose

sqlcmdcli.exe qsw -s:BEER -d:WideWorldImporters -u:YourUserName -p:YourPassword

stressdb (sdb)

Extracts the database schema and runs a query for each table

sqlcmdcli.exe stressdb {options} [flags]

sqlcmdcli.exe sdb {options} [flags]

Options

-servername: (-s:) SQL Server instance name

-databasename: (-d:) Database name

-username: (-u:) SQL Server username

-password: (-p:) Password

Options inherited from parent commands

-help Shows help for the command

Flags

-verbose Shows details about the results of running

Examples

sqlcmdcli.exe stressdb -servername:BEER -databasename:WideWorldImporters -username:YourUserName -password:YourPassword -verbose

sqlcmdcli.exe sdb -s:BEER -d:WideWorldImporters -u:YourUserName -p:YourPassword

Feedback

Thank you for checking out sqlcmdcli! Please open an issue to send us feedback. We're looking forward to hearing it.