Last but not least, if you upgrade to SQL 2017 or Azure SQL DB or Azure SQL Managed Instance, you will have a whole plethora of new features and functions which will undoubtedly make your life a whole lot easier. Regulatory compliance such as PCI-DSS for credit card transactions may no longer be met, which could put your company at risks for fines or penalties and affect your ability to do business in Europe once the GDPR comes into effect on the 25 th of May 2018.Īdditionally, it will probably result in must higher maintenance costs. You will no longer get critical security updates, which may put your data at risk, and possibly affect your compliance with industry standards and regulations. When the end of support comes around on the 19 th of July 2019 the abovementioned will no longer apply. If you wanted any other kind of support (not security), you can still get it by paying for it. SQL Server 20 R2 are currently in the extended support, which means that security updates are still made available. I will also discuss some of the tools that you might use to make the upgrade as painless as possible. In this article I am going to tell you why you would want to upgrade to a newer version of SQL Server (2016 or 2017) or Azure SQL Database. If you are still running SQL Server 2008 or SQL Server 2008 R2, now is definitely the time to upgrade. Which is approximately a year from now, give or take a couple of months. After hanging around for a good decade SQL Server 2008 and SQL Server 2008 R2 has started the countdown to its End of Life.ĭ-day for SQL Server 2008 and SQL Server 2008 R2 is set to the 19 th of July 2019.
This blog post extensively describes how to install both tools provided by Microsoft.As with everything else, all good things must come to an end. Management tools are key for efficient and fast administration of the database systems. Provide Server name and click Connect – I am using a local installation of SQL Server To have access to all new features that are in a preview state, click Yes on Would you like to enable preview feature On the last screen leave Launch Azure Data Studio option enabledĪzure Data Studio should start. Once everything is ready, click Install to proceed with the installation Wait for download till complete and run installer Scroll down to User Installer and click to download an installer
Open your favorite web browser and go to Download and install Azure Data Studio website: You can also use Azure Data Studio that is compatible with other Operating Systems like macOS or Linux. Once the connection is successful you should be able to see the following connection
Start SQL Server Management Studio from Start Menu and connect to SQL Server – I am using a local installation of SQL Server. Wait a few minutes till Management Studio is successfully installed: Once it is done you can start the installation by clicking on Install button:
On Welcome screen review License Terms and Privacy Statements. Once the file is downloaded run the installer: Scroll down to latest version of SSMS section and click on the Download SQL Server Management Studio link: Open your favorite web browser and go to Download SQL Server Management Studio (SSMS) website How to download SQL Server Management Studio? SQL Server instance is installed as described in the second blog post or third blog postĪs a first step, we are going to download SQL Server Management Studio.No issues with connectivity with Active Directory domain (no AD-related errors in System Event Log).There is a connection between Windows server and domain controller.