How to install SSMS from command line? A client’s silent install failed: the specified value for setting MEDIALAYOUT is invalid. Here is the fix.
PowerShell – Querying SQL Server From Command Line
A client’s deployment scripts got me curious about PowerShell. Here is how to start querying SQL Server from the command line with a PowerShell script.
SQL SERVER – How to Connect Using NT AUTHORITY \ SYSTEM Account?
SSMS will not let you type in Windows credentials. Here is how to connect using NT AUTHORITY\SYSTEM account with PsExec from Sysinternals.
Connect to MySQL From the Command Prompt: Host, Port, User
To connect to MySQL from the command prompt, you pass a host, a port, a user and a password to the mysql client. This post runs every switch, then shows the exact error that a wrong port, user, password or database produces.
Find mysqld.exe on Windows and Fix ‘mysql’ Is Not Recognized
To find mysqld.exe on Windows, search the drive with dir or where, or ask the running server where it lives. This post fixes the ‘mysql’ is not recognized error by adding the bin folder to PATH, and it shows every command with its real output.
Enable SQLCMD Mode in SSMS: SQL in Sixty Seconds #048
To enable SQLCMD mode in SSMS, use the Query menu or set it as the default for new windows. This post tests :connect, :setvar, :r, !! and :on error exit with sqlcmd.exe on SQL Server 2025 and shows the Msg 102 error you get when the mode is off.
SQL Server – Using SSMS Command Line Parameters
My friend Vinod Kumar shows how SSMS Command Line parameters can save you a few clicks every time you open Management Studio and connect to a server.