Skip to main content

Posts

Showing posts from July, 2018

Things that you might not know about SQL Management Studio

SQL Server Management Studio (SSMS) has been around since SQL Server 2005 and is a surprisingly nice environment from which to manage SQL Server.  Of course it has its shortcomings and there are 3d party tools that supply either replacements or add-ins to it.  However, if you have not given it a through look over, it might be easy to ignore some of its best features, so I thought I would take you on a quick tour.  Everything I list here is for the version of SSMS that shipped with SQL 2012, but most of the items mentioned are available in any version.  So, let’s start with some basics and then move on to some more sophisticated things.   SSMS Settings   From the Tools menu, click Options .  You now have a wealth of ways to customized SSMS at your fingertips.  Too many to go over in detail, so a few of my favorites, then.  Environment \ Fonts and Colors gives old geeks like me the chance to adjust the font size for query w...