SQL Server 2016 Release Candidate First Look


Download is available at this link: SQL Server Management Studio (SSMS) 2016


SSMS_2016 (1)


The setup file is of 634 MB which is supported across the platform : Windows 10, Windows 8, Windows 8.1, Windows 7 (SP1), Windows Server 2012 (64-bit), Windows Server 2008 R2 (64-bit). Refer here for more details: https://msdn.microsoft.com/en-in/library/mt238290.aspx

SSMS_2016 (2)


The installation UI looks a little different and clean than ever before.

SSMS_2016 (3)

The Installation process took quite a bit and it installed it module by module!

SSMS_2016 (4)

SSMS_2016 (5)


SSMS_2016 (6)


After 10 minutes or so, it asked me to do a reboot. And I did!

SSMS_2016 (7)


And I was presented with this:

SSMS_2016 (8)

Yes, you’ve got two more options to log into a SQL server instance:

  1. Active Directory Password Authentication
  2. Active Directory Integrated Authentication

SSMS_2016 (9)

It comes with an awesome “Activity Monitor” eliminating the need of so much used DMV queries to measure which object is being consumed much and do the performance tuning!

SSMS_2016 (10)

Lovely Activity Monitor!

And the cheery on top: Live Query Execution Plan!

Live Query Execution Plan

Loving all this.  🙂


Leave a Comment