Archive

Archive for September, 2017

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 !!!


Advertisement
Categories: SQL Server Tags: ,

Microsoft Azure Data Platform – August (2017) update

September 1, 2017 Leave a comment

 
Microsoft Azure updates curated from August-2017 on: Azure SQL DB/DW, HD Insight, Machine Learning (ML), Azure Data Lake (ADL), etc.

1. Teradata Bolsters Analytics and Database capabilities for Azure

2. Migrating a Web App from ClearDB to Azure Database for MySQL

3. Online training for Azure Data Lake (ADL)

4. Introducing the #Azure CosmosDB Change Feed Processor Library

5. August updates to the Azure Analysis Services web designer

6. Bring Interactive Analytics to Azure HDInsight: Kyligence Analytics Platform enables sub-second query

7. Azure AD (AAD) authentication extensions for Azure SQL DB and SQL DW tools

8. Data Management Gateway (DMG) – High Availability and Scalability Preview

9. Using Azure Analysis Services over Azure SQL DB and DW

10. Azure Data Factory (ADF) July new features update

11. Replicated tables now in preview for Azure SQL Data Warehouse

12. On-premises data gateway support for Azure Analysis Services

13. Imanis Data – Cloud migration, backup for your big data apps on Azure HDInsight

14. Azure Database for MySQL and Azure Database for PostgreSQL availability in India

15. Perform advanced analytics on Application Insights data using Jupyter Notebook

16. Announcing the public preview of Azure Archive Blob Storage and Blob-Level Tiering

17. Azure Analysis Services web designer adds visual model editing to the preview

18. Debug Spark Code Running in Azure HDInsight from Your Desktop

19. Hortonworks extends IaaS offering on Azure with Cloudbreak

20. Announcing Azure Data Lake Store Capture Provider for Event Hubs Capture

21. Default compatibility level 140 for Azure SQL databases

22. Preview: SQL Transparent Data Encryption (TDE) with Bring Your Own Key support

23. Announcing Azure Blob storage events preview

24. Stream Processing Changes: Azure CosmosDB change feed + Apache Spark

25. Machine Learning based anomaly detection in Azure Stream Analytics

26. Announcing Default Encryption for Azure Blobs, Files, Table and Queue Storage

27. Automation of Azure Analysis Services with Service Principals and PowerShell