Wayne's Tips and Tricks for SSMS

Wayne’s Tips and Tricks for SSMS

SQL Server Management Studio (SSMS ) is a program that many just launch daily (or only when they restart their computer), and they use it to navigate to various SQL Servers to manage them, either through the GUI or through a query. I’ve found that most people are just not aware of all that SSMS can do to help you be more productive. Therefore, I’m going to be posting a SSMS tip or trick daily for the month of January. I just couldn’t help myself – there’s so many more things that can be done in SSMS that I’m going to keep on adding to this series. It won’t be daily, but keep an eye out for more tips! Let me know if you would also like to for me to cover tools that integrate with SSMS.

During this month-long blog series, I’ll show many tips that SSMS can do that will help you improve your productivity. These tips do not require any third-party tools. I’ll be using this post as a landing page for the series, and I’ll be updating it daily. So, come back every day to get your next SSMS tips fix. To make it even easier, you can use this link to return to this page: bit.ly/MonthOfSSMS. And because I like giving you options, you can also use ssms.waynesheffield.com to jump to this page also.

Bonus Tip: Did you know that SSMS is now distributed independently from SQL Server? It is a free download, and can be installed in parallel with other versions of SSMS. It is compatible with SQL Server 2008+. While it doesn’t block access to SQL Server 2000 or 2005, some features might not work correctly.

Day One: SSMS Solutions
Day Two: Split Screens
Day Three: Tab Groups
Day Four: Pinned Tabs
Day Five: Working with Query Files
Day Six: Vertical Scroll Bar Map Mode
Day Seven: Template Variables
Day Eight: SQLCMD Mode
Day Nine: Multi-Server Queries
Day Ten: Regular Expressions
Day Eleven: Block Select/Replace
Day Twelve: Changing case
Day Thirteen: The SSMS Super Clipboard
Day Fourteen: Object Explorer Drag-N-Drop
Day Fifteen: Query Shortcuts in SSMS
Day Sixteen: Assign a keyboard shortcut to menu items
Day Seventeen: Add color to connections
Day Eighteen: Template Explorer
Day Nineteen: Use Snippets in SSMS to insert blocks of code
Day Twenty: Object Explorer Filtering
Day Twenty-One: Object Explorer Details
Day Twenty-Two: Outlining
Day Twenty-Three: Quick Editing Tips
Day Twenty-Four: Using Bookmarks to navigate code in SSMS
Day Twenty-Five: Using the SSMS Web Browser
Day Twenty-Six: Working with Comments
Day Twenty-Seven: Comparing Query Plans
Day Twenty-Eight: Saving SSMS Settings
Day Twenty-Nine: Presenting with SSMS
Day Thirty: Reports in SSMS
Day Thirty-One: SSMS Activity Monitor
Day Thirty-Two: Controlling what appears in the status bar and query tabs
Day Thirty-Three: Using the Full Screen Mode in SSMS
Day Thirty-Four: Working with tabs and spaces in SSMS
Day Thirty-Five: SSMS Batch Separator
Day Thirty-Six: Removing servers from the SSMS connection dialog