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

Day Thirty-Seven: SSMS Reset window layout

The post A month of SSMS tips and tricks appeared first on Wayne Sheffield.