Honestly, there is an alternative way to quickly use SSMS SQLCMD mode as a development environment, let us learn about it today.
SQL SERVER – Performance Test – sqlcmd vs SSMS
I have received an email from my clients of Comprehensive Database Performance Health Check. The question was about Performance Test – sqlcmd vs SSMS.
SQL SERVER – How to Execute the Query Without Using Management Studio?
A client’s security team removed SQL Server Management Studio from the server. Here are simple ways for beginners to run a query without it.
SQL SERVER – SQLCMD Error – Failed to Load Resource File SQLCMD.rll
Running SQLCMD gave me this SQLCMD error: Failed to load resource file SQLCMD.rll. Here is how I used Process Monitor to find the missing file.
SQL SERVER – SQLCMD to Build Comma Separated String
A trick from Balmukund and Vinod at SQLBangalore: use SQLCMD to export a table’s data as a comma separated string. Here is how it works.
SQL SERVER – Execute Operating System Commands in sqlcmd
Tired of leaving sqlcmd to check something in Windows? Here is a simple trick to execute operating system commands while you are still in the sqlcmd prompt.
SQL SERVER – Automatically Store Results of Query to File with sqlcmd
Want to store results of query to file automatically without SSMS? Here is how to do it with sqlcmd and its -o option, step by step.