SQL Server Management Studio 2019

Hello and welcome to another episode of C-sharp Corner videos

My name is Mahes Chan, I'm founder of C-sharp Corner. In this video, we are going to see how to download and install SQL Server Management Studio

First thing you're going to do is go to Google and type SQL

server management studio in Google. First thing you will see is download SQL Server Management Studio here, SSMS

Click on the link. Here you will see download. There's article on there

Currently, SSMS is version 18 RC, as you can see from here

I'm sure soon it's going to change as soon as new version

comes out and you can also see that this latest generation supports SQL Server 2019 preview

If you want to install previous versions public releases, previous one is right here

But by the time you will be reading this in next couple of months, this is going to change anyway

So let's install this SSMS 18 release candidate, RC1. You can also read more details on this

You can also see what's fixed here from the user voice, what features are available in this one

So let's get started. So I going to click on download and you can see download is started It about 484 mb It shouldn take much time Depending on your internet speed sometimes it may take you know minutes and even more depends on your internet speed

So while it's downloading, what I'm going to do is a little bit talk about why do we need management to

If you have a SQL server running and you need a visual UI tool where you can create database, you can create tables, run queries, you want to create a store prox, work with tables, import, export data, all that thing you can do through this UI tool without using command line

If you are using other tools or command lines, then you can still use the way you're using SQL Server

Other thing you may want to see is that if you have older versions of SQL Server, you want to make sure that new management studio is compatible with that

So all right, download is complete. Let's open this. I'm going to run this

So I'm running Windows 10 Pro on a HP laptop

So you will see this welcome message. I'm going to click on install button

As you can see this new management studio has new cool UI

It pretty flat The theme is also a little bit different installation theme Installation usually doesn take much time

You can also see the progress here. It's installing and updating you what's going on here

Still says SQLS for a 2012 native client. client ODBC driver, OLE driver, we still use, you have OLEDB, remember OLEDB

I remember 20 years ago, OLEDB was one of the major data tool for data connecting different

kind of data sources. being used a lot. I think Microsoft should maybe probably releasing the new SQL server

I don't know if you guys know that, but Microsoft just released Visual Studio

Studio 2019. It's one of the most popular IDEEs for software developers

around the world. If you have not installed if you write c-sharp and dot net

programs or all kind of different programs you want you may want to look at this

new versions while it's installing the background you want to go to say home

page of c sharp corner you can see visual studio 2019 is available now

and you can also see that this has several cool features Well, let's get back to our installation

I don want to miss anything in this installation right now You can also see as you can see in the background what I will do is let it install

in the side by side. We can do is review a little bit some things here. It's installing

SSRS and the services. There you go. So it didn't take much time, right? So it's

says restart is required so what I'm going to do I'm going to restart now that's

it you install once you install you should be able to see the icon or search

let me restart first and then we will come from there all right we are back after

restarting our machine I'm going to do is search SQL here and you will see a menu item available here for Microsoft SQL Server

Management Studio 18. Click on that icon. If you are starting first time, it may also ask you to import your previous settings

from previous versions. You can import or either. Here you will provide your server name

Obviously here, this is my local server. so I'll say connect and that's it your CS SQL Server Management Studio is up and

running you can create your databases you can as you can see I imported my

previous database here that's it hope you like the video thank you