I am a bit of a customisation nut; pretty much with any software package I pick up I have the uncontrollable urge to dig straight into the options and get on the hunt for how to ‘theme it up’!
The one that probably upsets me the most is poor old SQL Server Management Studio (SSMS). SSMS has long lagged behind, considering sharing the Visual Studio shell, on the inclusion of a dark theme. I ended up going on a scrummage around as it seems pretty incredible that this isn’t available yet. This is what I managed to dig up:
Back in April of 2016, this was the news at the time:
“We currently have the dark theme disabled as we need to do a lot more UI enhancements across all the SSMS dialogs and wizards to make this work properly. We will be working on this and true high DPI support in the coming months.”
The options on offer at the moment, by default, are a snooze fest at best:
By way of example, here is the light theme doing its thing:
Alas, it sounds like we might be waiting a while longer for true dark theme support but…if you simply what to customise the code window you can (as in Visual Studio) work some magic in the interim, as follows (yes, the other dockable portions of the UI do not change, but it’s a start).
As a first step, you need to go in search of themes or, more specifically, custom made ‘.vssettings’ files. This is the resource I have used in the past and in this example:
There are a tonne of pretty decent themes on this site. Here are some that immediately interested me, on first glance (as I’m a dark theme psycho):
- Son of Obsidian
- IR Black
- Visual Blend
- Electric Energy
- Sublime Text 2 – New Edition
- Colorful Darkness
If anyone has a good recommendation for other places to go and seek out themes please leave a comment below.
Once you have downloaded any .vssettings files you are interested in (for SQL Server 2016 I have been using the VS 2015 files, without issues thus far), place them in a location that is easily accessible. Now, you need to fly on over to SSMS where the process of importing a .vssettings file is incredibly easy.
Start by navigating to Tools > Import and Export Settings, as below:
Next up, check the option entitled ‘Import selected environment settings’ from the following dialog, and click Next:
Next up, you can save your current settings to a .vssettings file, if you choose. This is a pretty solid bet if you have imported a new theme and have made customisations to it yourself, as you will want an easy way to rollback should your eyes be offended by whatever you import next 😉 ! If you like living on the edge there is always the ‘No, just import new settings, overwriting my current settings’ option. Pick the option that makes you feel good, then click Next:
Here comes the meat in the customisation sandwich; browse to the .vssettings file location (where you have stashed one or more settings files) and pick one of your choosing, then click Next:
Check the dialog that pops up next for any warnings and, if you are happy, proceed by clicking Finish.
Finally, you should get a confirmation that the import process has completed successfully (or not, but I haven’t seen an outright failure yet!):
You should, all being well, see an immediate update to the theming in the code window, as shown:
That’s all there is to it! Again, if anyone has a good resource for themes please let me know, I’m always on the lookout for the cool and unusual.
As an added bonus, here are a few ‘live action’ shots from the bear cave as I was constructing this post:
Thanks for reading, catch you next time!