Install SSMS | SQL with Manoj

SSMS Installation Error – This version of SSMS cannot be installed because a xyz version of SSMS 17.0 was detected

September 23, 2017 2 comments

So, today I tried to install SSMS 17.3 version, and got following error:

This version of ssms cannot be installed because a release candidate version of ssms 17.0 was detected.

This is because if you had installed SSMS previously and uninstalled it and because of some files were not cleaned up properly, you will get this kind of message while installing SSMS separately.

–> The solution is to remove the previously installed SSMS related files from the respective version folder:

Go to following folder and remove all folders and files: C:\Program Files (x86)\Microsoft SQL Server\140\Tools\

Now try installing SSMS again and you won’t get any error !!!

Microsoft released SQL Server vNext (2017) – New features and enhancements in CTP 1.x

November 20, 2016 5 comments

On 16th Nov 2016 Microsoft announced the first Community Test Preview (CTP 1.0) of SQL Server vNext that will run both on Windows & Linux. Not only Linux, but it will be supported on Docker, and macOS (via Docker) too.

For now I’m calling the vNext version as SQL Server 2017. (2018 is not called officially, I’m calling it just to avoid any confusion 🙂 )

This announcement was along with the release of SQL Server 2016 SP1, and the vNext version also supports features added in SQL Server 2016 SP1.

–> Download vNext bits:

To download the SQL Server vNext you can Register and Download the Full version or Free evaluation version (180 days).

Or, directly download the ISO (~2 GB): SQLServerVnextCTP1-x64-ENU.iso

–> Check version and SQL build:

select @@version

Microsoft SQL Server vNext (CTP1) – 14.0.1.246 (X64)
Nov 1 2016 23:24:39
Copyright (c) Microsoft Corporation
Developer Edition (64-bit) on Windows 10 Enterprise 6.3 (Build 14393: ) (Hypervisor)

–> New Features & Enhancements:

>> Database Engine:

1. All new features in SQL Server 2016 SP1.

2. New compatibility level 140.

3. Improvements to the way incremental statistics update thresholds are computed.

4. New DMVs added:
– sys.dm_exec_query_statistics_xml added, to get query execution plan for in-flight requests.
– sys.dm_os_host_info, to provide operating system information for both Windows and Linux.

5. Enhancements to In-Memory Tables & SPs:
– Can now use sp_spaceused, sp_rename, CASE, TOP (N) WITH TIES
– More than 8 indexes

6. Clustered Columnstore Indexes now support LOB columns (nvarchar(max), varchar(max), varbinary(max)).

7. New STRING_AGG() aggregate function has been added.

8. Database roles are created with R Services for managing permissions associated with packages.

9. New Japanese collations are added.

– Features added in CTP 1.1

10. Memory-optimized tables and indexes now support computed columns
   – Full support for JSON functions
   – and CHECK constraints
   – Natively compiled modules now support the CROSS APPLY operator

12. New string functions CONCAT_WS, TRANSLATE, and TRIM are added.
– and the WITHIN GROUP clause is now supported for the STRING_AGG function.

– Features added in CTP 1.2

13. Online index build and rebuild support for non-clustered Columnstore indexes.

14. Support for SUSE Linux Enterprise Server v12 SP2

15. SQL Server Early Adoption Program (EAP), msdn blog on EAP

– Features added in CTP 1.3

16. Full text search, now available for all supported Linux distros

17. Resumable online index rebuilds

18. Temporal Tables Retention Policy

19. Indirect checkpoint performance improvements

20. Online non-clustered columnstore index buill and rebuild support added

21. Availability Groups enhancements:
   – Cluster-less Availability Groups support added
   – Minimum Replica Commit Availability Groups setting
   – Availability Groups can now work across Windows-Linux to enable cross-OS migrations and testing

22. New DMV sys.dm_db_stats_histogram, for examining statistics

23. 5 new dynamic management views to return information about Linux process:
   – sys.dm_linux_proc_all_stat
   – sys.dm_linux_proc_cpuinfo
   – sys.dm_linux_proc_meminfo
   – sys.dm_linux_proc_sql_maps
   – sys.dm_linux_proc_sql_threads

>> SQL Server Analysis Services (SSAS):

1. 1400 Compatibility level for tabular models.

2. Modern Get Data query and import data features for tabular models.

3. Support for ragged hierarchies with the new Hide Members property.

4. Support for drillthrough by using Detail Rows. This includes the Default Detail Rows expression property and DETAILROWS DAX function.

5. Table-level security, restricts user permissions on table data and table names.

6. New DAX IN function.

7. Encoding hints, an advanced feature used to optimize processing (data refresh) of large in-memory Tabular models.

>> SQL Server Integration Services (SSIS):

– Support Scale Out of SSIS: to run SSIS on multiple machines. With Scale Out Master and Workers, packages can be distributed to execute on different Workers automatically. Check more details here in MSDN.

>> SQL Server R support: Check full details here in MSDN.

–> For new Features released in CTP 2.0 check here.

–> Download & Install SQL Server vNext & SSMS:

–> References:

>> MSDN Blog announcement

>> MSDN for SQL Server vNext

>> SQL Server vNext Release Notes

Categories: SQL Server 2017 Tags: Download SQL Server, Install SQL Server, Install SSMS, SQL Server 2017

SQL Server 2016 RTM full and final version available – Download it now !!!

June 1, 2016 20 comments

Its 1st June 2016 and finally Microsoft has released SQL Server 2016 full and final version, and is available for download!

Exactly a year back the first CTP version of SQL Server 2016 was released and we got a chance to get a glimpse of the new features coming in. Then after every month or two Microsoft kept rolling out the CTP versions with more new features, enhancements, and bug fixes on the previous CTP builds.

–> Download SQL Server:

To download SQL Server 2016 you can Register and Download the SQL Server 2016 Full or free Evaluation version (180 days) here.

Or you can Direct download the DVD ISO file image (~2.1 GB) SQLServer2016-SSEI-Eval.exe

–> Free Developer Version:

Microsoft on March 2016 announced that going forward the Developer version of SQL Server any release will be free for Developers and Learning purpose. Register and Download the Developer version.

Or you can Directly download the DVD ISO image (~2.1 GB): en_sql_server_2016_developer_x64_dvd_8777069.iso

This Developer version is meant for development and testing only, and not for production environments or for use with production data. For more info please check my previous blog post.

–> One big Update on SSMS:

From now onward SSMS i.e. SQL Server Management Studio will not be part of SQL Server installation. This has to be installed separately via the SSMS download page, or from the Installation Center which will download SSMS from online.

As per Microsoft, this is basically to support the move to make a universal version of SSMS for both SQL Server on-Prem & Azure SQL Database, that will ship every month or so.

Check my previous post on installing SSMS separately.

–> Check new features in SQL Server 2016: https://sqlwithmanoj.com/sql-server-2016-articles/

1. Native JSON Support, Part1, Part2, Part3, Part4, Part5

2. Temporal Data/Tables, Part1, Part2

3. Row Level Security, Part1, Part2

4. Dynamic Data Masking, Link

5. Stretch Database, Link

6. Query Store, Link

7. Live Query Statistics, Link

8. Enhanced In-Memory OLTP, Link

9. Enhanced ColumnStore Indexes, Link

10. Truncate Table partition

11. Other features like, IF EXIST with DROP stmt, STRING_SPLIT fn, COMPRESS & DECOMPRESS fn, etc.

Do check & Like my FB Page.

Categories: SQL Server 2016 Tags: Download SQL Server, Download SSMS, Install SQL Server, Install SSMS, SQL Server 2016

Download & Install SQL Server Management Studio (SSMS) 2016 (decoupled from SQL Server engine setup)

April 6, 2016 4 comments

In my [previous blog] post of SQL Server 2016 RC0 availability, I mentioned regarding SQL Server Management Studio (SSMS) that it will no longer be installed from the main feature tree of SQL Server engine setup.

As per Microsoft, this is basically to support the move to make a universal version of SSMS that ships every month or so.

So, now on wards after installing SQL Server 2016 you need to install SSMS separately.

–> Till SQL Server 2014 you have an option of choosing SSMS in the Feature selection tree, but with SQL Server 2016 and on wards this option is taken out, can be seen in the pic below:

Click to expand

–> Now to download SSMS 2016 you can either visit the Microsoft [download page]

Or, try installing directly via the “Installation Center” as shown below. This will install SSMS directly online.

Click to expand

So, once you take appropriate action above to download SSMS 2016, the Installation kicks off like this:

And here is the version information of SSMS 2016 after successful installation:

Microsoft SQL Server Management Studio	 13.0.12000.65
Microsoft Analysis Services Client Tools 13.0.1100.213
Microsoft Data Access Components (MDAC)	 10.0.10586.0
Microsoft MSXML				 3.0 6.0 
Microsoft Internet Explorer		 9.11.10586.0
Microsoft .NET Framework		 4.0.30319.42000
Operating System			 6.3.10586

Tech Tip: Move your SQL server onto the cloud with Hosted Citrix VDI available unbelievable citrix xendesktop pricing and get an easy remote access to it from anywhere on any device(PC/Mac/Linux/android/iOS) powered by one of the leading providers of cloud hosting – Apps4Rent.

Check my blog posts on most of the new features released in SQL Server 2016

Categories: SQL Server 2016 Tags: Download SSMS, Install SSMS, SQL Server 2016