SQL Server Management Studio Tips and Tricks

SQL Server Management Studio Tips and Tricks

So now that you know the basics of using Microsoft SQL Server Management Studio (SSMS), what power user tips can make you even more productive? Learn how to use the SQL Editor more efficiently to change case, comment or un-comment blocks of code, fix Intellisense when it is broken, and more.

------- Chapter Timestamps (click to jump forward): -----------------------------
0:00 - Intro
0:09 - Bulk Editing: Change case, comment blocks, and rectangular selection
3:57 - Map Scrollbar Mode
6:45 - Code: Snippets, template explorer and surround with
10:29 - Results to text, to grid, and to file
15:03 - Troubleshooting: Four possible fixes when IntelliSense stops working
17:25 - Fix: Tabs to spaces
19:39 - Use "GO" to iterate a code block n times
21:00 - Generate an "INSERT INTO" script from existing table data
27:59 - List table sizes by space used and row count
30:21 - The End

Watch related playlist videos:

Connect with me on social media:

Subscribe to my YouTube Channel:

Background Music:
- "Amplified" by Microsoft Photos / Media Editor

#MSSQL #SQLServer #SSMS #SSMSTips

[brandonbillie]

Hi Matt, thank you very much for this SQL tips and trick video. I love the Alt + Shift + Click trick, I never know about that one before and I find it very useful indeed. The script / create table template one is also coming in very handy. Thank you for creating this video and sharing! - Brandon.