The 2nd post in a series, suppose starting at configuring ADS is a good place to start and the power and productivity in ADS come from learning several short cut keys. At this stage, it’s worth mentioning a few time-saving tips and trips. It also (hopefully) will make my presentations at SQL Saturday Iceland and SQL Saturday Belgium a bit smoother (since I wrote this as draft Iceland has been added to the list.
#1 quick switch to the application of choice
When you open ADS (my application of choice for these blog posts) drag the icon to the far left spot on the taskbar, apologies Its windows only tips here. Then open SSMS and drag to the spot next to it (as below). What is quite cool if you have ADS as a short cut on the taskbar is a different coloured icon to the unopen one!
Now when in any window and you want to open ADS you just hit windows key+1 if you want SSMS its windows key+2, works across the taskbar.
The other one that’s really useful if working in an environment where you use a different account to access SQL, i.e. privileged account, back in the day used to right-click and do a run-as each and every single time.
Using the following syntax and pointing to file in question SSMS in this case adding the /savecred will allow you to just save the password a single time, till your password expires and it will then re-prompt you for it when opening.
C:\Windows\System32\runas.exe /user:DOMAINNAME\USERNAME /savecred “C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\Ssms.exe”
Then just edit the shortcut on the task-bar
So I have my Azure Data Studio all ready to start some funky thing in the next blog post…