When using SQL Server Management Studio, I feel it's a pain and waste of time to choose the same SQL server instance, authentication details repeatedly. As a workaround, I use to make use of the "ssms" command. If SQL Authentication: ssms -s MySQLServer2017ENT -d testbed -u demo -p demo here, -s: Server details -d: Database to connect -u: username -p: password For Windows Authentication: ssms -s MySQLServer2017ENT -d testbed But opening the command prompt and typing this each time doesn't make sense either. So created a batch file and placed it on the desktop that way, double-clicking the batch file is all one has to do. Mainly while working on my laptop, this comes in very handy. Content of the batch file: start ssms -s MySQLServer2017ENT -d testbed -u demo -p demo exit
I write about things which I am passionate about.