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.  🙂

 

(1)

[Solved] The Backend version is not supported to design databas disgrams or tables.

I Came across this error when i got to work on some other machine with SQL Server Management Studion 2008 R2 installed.

This error thrown up when I tried to modify the design of a table by right clicking on a table and selecting “Design” option.

Error- Backend Version Not Supported - SQL Server Management Studio

Solution:

  • Check Database version using “SELECT @@VERSION”

    select-version

    In my case it was SQL Server 2012 SP1.

  • Update the SQL Server Management Studio to the version of the SQL Server.

That’s all!

(1452)