In order to manange and test out my new SQL Server 2019 CTP 2.0 instance I will also need to install SQL Server Management Studio (SSMS). I decided I’m going to install the latest and greatest version of SSMS on my machine. To get the latest version of SSMS I use the “Install SQL Server Management Tools” link on the “SQL Server Installation Center” dialog as shown below:
Install SQL Server Management Tools
When I click on this link the follwong webpage is displayed: https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-2017.
Download SQL Server Management Studio
As you can see the link only brought up a Books Online documenation page. If you look closesly at this page you can see there is a link to download the preview 4 version for “SQL Server Managmenet Studio 18.0. https://go.microsoft.com/fwlink/?linkid=2014662). I will be using this preview version of SSMS for my SQL Server 2019 CTP 2.0 testing. By using this link I download the SSMS setup exe (SSMS-Setup-ENU.exe) and saved it to my VM machine. When I execute this SSMS exe the following dialog is displayed:
SQL Server Managmenet Studio 18.0
To start the install of SSMS 18.0 I click on the “Install” button. When I do this, I am shown the following progress dialog while the installation process of SSMS is running:
Microsoft SQL Server Management Studio Progress Bar
Once the install is complete the following screen is displayed:
Microsoft SQL Server Management Studio Restart
As you can see a restart of my computer is required. I click on the “Restart” button to complete the installation of version 18.0 of SSMS.
Step 3: Verify Installation
At this point I have installed SQL Server 2019 CTP 2.0 and SQL Server Management Studio (SSMS). I start my verification process by using SSMS. When SSMS first starts I see the following screen:
SQL Server Management Studio
This window is displayed for a few seconds, but then eventually SSMS starts and the following window is displayed:
SQL 2019_CTP2 [Running]
I connect to the default instance by placing a period (“.”) in the “Server name” item and the click on the “Connect” button. After SSMS connects this is what I see in the “Object Explorer” window:
Object Explorer Window
As you can see I’m running SQL Server build version 15.0.1000.34, which is the build number for SQL Server 2019 CTP 2.0.
If I expand the Database item in Object Explorer I see the following:
Expand the Database
As you can see I have the normal System Databases (master model, msdb, and tempdb), but I also have the three DW… databases (DWConfiguration, DWDiagnostics, DWQueue). If you have not seen these databases before they are databases used to support PolyBase.
For my next test I issue the following query against my new SQL Server 2019 CTP 2.0 database:
SERVERPROPERTY('Edition') AS Edition,
SERVERPROPERTY('ProductVersion') AS ProductVersion,
SERVERPROPERTY('ProductLevel') AS ProductLevel;
When I run this code the following is returned:
Here I can tell I’m running the “Enterprise Evaluation Edition (64-bit)” version of SQL server 2019 CTP2.0.
Are you ready to install SQL Server 2019 CTP 2.0?
You can see it is very easy to install SQL Server 2019 and all the features by just clicking through the different dialog boxes of the installation process. The only real gotcha I ran across was forgetting to install the Oracle JRE prior to installing Polybase. I think all DBAs should start exploring SQL Server 2019 as a step to get them ready for SQL Server 2019. I encourage all of you to consider testing out CTP 2.0 of SQL Server 2019. Are you ready to install SQL server 2019 CTP 2.0 in your environment?
See all articles by Greg Larsen