Management Studio February Update : An Illustrated Guide

Management Studio February Preview : An Illustrated Guide

Yes, it's March. But just today, Microsoft announced the availability of a new build of Management Studio (SSMS), labeled the February 2016 Preview.

You can download a new preview of SSMS standalone (13.0.12000.65) here:

Changes to SSMS are documented here:

It is important to note that there are significant changes in SSMS, either already in place with this build, or in process for one of the next ones. You should be aware of a few things:

    No more .NET 3.5 Framework required!

    I have to tell you, this was wonderful. I was able to install Management Studio 2016 on a freshly installed Windows 10 virtual machine without having to stop, go back, install .NET 3.5, and start over (I voiced my misery over this here). Sadly, though, it is still a requirement for the RC0 database engine. My fingers are crossed this prerequisite will be totally abolished by RTM.

    HiDPI issues have been (kind of) fixed

    Gianluca Sartori (@spaghettidba) blogged about the issues you may have noticed with older versions of Management Studio on HiDPI, UQHD, or 4K/5K screens in his post, "SSMS in High-DPI Displays: How to Stop the Madness." Essentially, Windows tries to scale things for your DPI settings and, depending on the technology used to render your fonts and dialogs, this can end up with ugly and sometimes unusable screens. Gianluca's fix is to make a registry change and add a manifest file to the SSMS directory so that SSMS no longer tries to render Windows' scaling changes. In the latest builds of SQL Server 2016, SSMS now acts as if the manifest file were in place. Take a look at the following image:

    DPI awareness

    Go on, click to enlarge. Compare the table properties dialog on the left (using RC0) to the one on the right (using a CTP 2.2 build of SSMS, but on the same version of Windows, with the same resolution and scaling settings, and the same monitor). The one on the right is at least resizable, but it does not present well initially (there are worse examples of this in Gianluca's post). The one on the left has ugly, blurred fonts, which makes me feel like I'm using a CRT in the late 1990s, but at least all of the dialogs are now usable. You can also compare the Help | About dialog to the one below – when the problem is active, you have to Copy Info to even tell what build you're running, because the dialog is not resizable.

    SSMS is moving to its own, independent release cycle

    This means that you will download SSMS separately, it will have its own "check for updates" functionality, and it will no longer be included in the features area of the main SQL Server setup routine. In fact, in RC0, it has its own setup routine launched from the installation center:

    rc0_ssms_01

    …and no longer appears among shared features:

    rc0_ssms_2

    However in RC0 you get a slightly older version of SSMS (13.0.12000.59), as this was the version that was ready to be packaged into the ISO. in future releases, this will grab directly from the web with the version that is current at that moment.

    Do not mix and match

    You may have heard from a friend that it worked okay, and even some of Microsoft's own documentation implies that it's okay, but be careful. The current builds of SSMS – whether from CTP/RC media or from the separate, preview downloads – are very much betas, and are not guaranteed to be compatible with other versions of SSMS or shared components. If you want to play with this stuff, please do so on a separate VM or test system that you can afford to revert to an earlier snapshot or rebuild.

 

Installation

Okay, all set with the warnings? Let's walk through setup.

The first thing you'll likely see is a warning if, like me, you didn't set up a clean, separate VM for this installation (but really, do as I say, not as I do):

ssms_1

If that hasn't scared you off, click Yes. Next, you'll see a slightly different screen, with links to the license terms and privacy statement (which could point to dancing baby gifs or spoof sites trolling Oracle for all most people know):

ssms_2

Click Install. At this point, you'll be prompted by UAC (if you have UAC enabled; I try to disable it whenever possible):

ssms_uac

Click Yes, and setup will start doing its thing:

ssms_3

This took about 10 minutes end-to-end on my machine; your mileage may vary. At the end, I was prompted to reboot. While probably not strictly necessary, I did anyway:

ssms_4

After restarting, I launched SSMS from the taskbar (it replaced my previous entry there); you may have to find it in your Start Menu or Start Screen depending on your version of Windows. The first thing I saw when doing so was a prompt about resetting my settings:

ssms_shell

When I clicked okay (because what choice did I have?), I saw the shiny new splash screen:

ssms_splash

Next, I got prompted to import my settings (which I did, from Making SSMS Pretty : My Dark Theme):

ssms_import

This did take a little bit to initialize:

ssms_wait

Then I had an empty interface. I immediately went to Help > About to see version information:

rc0_ssms_aboutYou'll have 13.0.12000.59 if you install from setup

Things I changed right away

First, when I opened a new query window, I was greeted with a toolbar that seemed much busier than I ever remember (click to enlarge):

ssms_toolbar_before

This is easy to fix, by going to Tools > Customize > Commands > Toolbar > and then deleting all the noise from both the "SQL Editor" and "Standard" toolbars:

rc0_ssms_customize

In addition to removing the items I don't use (Debug was first to go!), I also moved some things around to be much more logical for my workflow. Ah, much better:

ssms_toolbar_after

Next, I noticed a very distracting focus box around the current line of code I was editing:

ssms_linefocus_before

Also, easy to fix, under Tools > Options > Text Editor > General, uncheck the "Highlight current line" option:

ssms_linefocus_edit

Now it looks better:

ssms_linefocus_after

(I will confess I spent some time trying to find that styling in Tools > Options > Environment > Fonts and Colors. Hopefully this will save you some time. I also turned off "Track changes" on that same screen to prevent those yellow and green stripes from appearing at the left.)

Comments ( 1 )

  • Chris Wood says:

    Aaron,

    Does this install NF 4.6.1 if it isn't already installed or some other version of NF 4.6?

    Thanks

    Chris

Leave A Comment

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.