Wednesday, January 8, 2014

SQL Server Management Studio (SSMS) Tips and Tricks

Change the status bar in the "New Query" window to red when connected to production or green when connected to development.


Open SSMS and in the "Connect to Server" dialog click the "Options" button.  Select the "Connection Properties" tab and check the box next to "Use custom color".  Select your desired color and that's it!




Refresh IntelliSense - If you create a new table/column and IntelliSense just doesn't seem to be working?


Refresh IntelliSense:




Don't have intellisense enabled? Go to Tools, Options.  Text Editor, Transact-SQL, IntelliSense.


Vertical Selection in Management Studio:

Sometimes you may only want to select text vertical compared to the normal text selection done by holding down the Shift Key. To do that, you can do SHIFT+ALT and drag your mouse to the selection of your text.



No comments:

Post a Comment