Continuing the two previous posts on employing custom color in SSMS using the built-in feature or SSMS Tools Pack to reduce error in connecting to a wrong environment, if you have access to Redgate SQL Prompt, this might be the easiest and best option to use. It's so easy to configure as demonstrated that many developers overlook this feature. You can certainly use the default but for the sake … [Read more...]
How to Change Default Project Folder in SSMS
There are several ways to configure SSMS to point to your own working directory as the default. Here's the easiest to do it without registry hack. You just need to edit the Visual Studio settings file (XML format). Open Windows Explorer, and go to (you can force type): Find vssettings file with the latest modification date. The file name should follow the convention … [Read more...]
Using Connection Coloring in SSMS Tools Pack
From previous posting, we demonstrated a way to use custom color coding using SQL Server Management Studio's (SSMS) Registered Servers properties. But using the feature can be very dangerous if you don't have the discipline to follow a strict process of opening new query from the registered servers pane. For example, if you use Change Connection button, the color will stay the same as the last … [Read more...]
How to Use Custom Color in SSMS
With many mistakes made by developers and DBAs alike firing a query in a wrong environment, there is one easy thing that can be done to alleviate this problem. That is by using the color coding on the status bar and you can set this up in the server registration on your SQL Server Management Studio (SSMS). This feature is so easy to overlook because many people just don't bother to look at the … [Read more...]