Installing SQL Server

Downloading SQL Server Developer

– [Instructor] Hello.

And in this video we’re going to download SQL server developer edition.

So let’s just download it now and then I’ll talk about it.

So go to google.com or your favourite search engine and have a for download SQL server 2019.

And you can see that the top instance here is from microsoft.com.

So let’s kick on that.

So we can see that there are three big entries at the top.

We don’t want any of those.

Instead, we want to go down and download a free specialised edition.

And in this case we’re going to download the developer edition.

So I’ll click download and it downloads what’s called a bootstrap, a very small document only about five megabytes.

And it’s saying, okay, now that you’ve got me what do you want to download? Do you want to download a very basic version? It’s a default configuration.

It will allow you to do select statements.

It will allow you to do some database administration but not much else.

So if you wanted to do other things such as SSAS, SQL server analysis services, SSIS integration services, SSRS that’s reporting services then don’t select this basic.

The options therefore are custom which will just run it or download media.

I like to download the media simply because I want to be able to reuse it on multiple computers.

If you haven’t got that need then custom could well be for you.

So I’m going to download the media and I’m going to download it as a cab.

So this is a compressed media.

So dot exe and box files.

So I’m going to now click on download having selected my download location.

You can select your language as well.

So let’s click on download.

So it’s going to take quite a while to download.

So I’m just going to talk about other things.

So let’s have a look at these five different things.

So we start off with SQL server on Azure.

Microsoft Azure is Microsoft in the cloud so you can get SQL server on the cloud.

As the back engine, where you’re downloading at the moment is the back engine or not the thing that you see but the thing that runs in the background and then you can query that from your computer.

The problem is there is a cost to that.

It’s not necessarily a huge cost but there is a cost and you can extend it to internet of things, devices as well.

Now, if you’re using this for work purposes then you’re probably looking at the enterprise edition or the standard edition.

The enterprise edition is the really big version, but also with a big price tag, standard edition, big cut down but a hugely cut down cost.

Now there are two, three specialised editions.

There is the express edition, and that’s fine if you just want to do select statements and if you want to do some database administration but there is also the developer edition.

Look at this.

It is a full featured free edition.

In fact, if we were to look at the various editions and components of SQL server you’ll see the enterprise edition is the premium offering comprehensive high end data centre capacities.

The standardisation offers basic data management but look at the developer, it features all of the functionality of the enterprise edition.

So why do people go for the enterprise edition not the free developer edition? Because it is only licenced for use as a development and test system, not in production.

So if you are going to learn SQL server it’s ideal for that development and test system and it allows you access to all of the various strands of SQL server.

So the reporting services, integration services, analysis services, as well as the select statements and database administration.

You’ll see that the express edition is the best choice for developers and hobbyists building client applications.

It is a very quick instal, but you can’t expand it if you want to go into these other rounds of SSRS, SSIS, and SSAS.

How much does SQL Server developer edition cost? Now the SQL server developer edition used to be a boxed product up till the 2014 edition.

It sold for around $200.

And in did, I bought one for around that price but now it’s completely free.

And therefore, that’s the perfect edition for you.

Now it’s called SQL server.

So does that mean you need a serve to instal it on? No, in fact the hardware requirements are fairly basic all it requires is a minimum of six gigabytes of available hard disc space.

Yeah.

Right.

I don’t believe that.

It only requires a gigabytes of memory.

Yeah.

Right.

But you can see that these are really small requirements.

What are the requirements? The major thing that it requires is a 64 bit processor.

If you don’t know whether you computer has got a 64 byte processor then open up Windows Explorer, press Windows and E on your computer and then go to this PC or my computer.

Right and click on it and go to properties.

And you’ll see if you have got a 64 bit operating system or not.

So it is now downloading so going to allow it to finish downloading.

So I’ll pause the video here and we’ll start with the installation.

Installing SQL Server Developer

– [Instructor] Right.

We can see that the download was successful.

So I’m going to now open the folder.

And here is the folder.

So it just contains two files, an EXE and a box.

So I’m just going to now double click on the EXE.

So do you want to allow changes you’ve made? yes.

Click.

Okay.

And it will now extract it all into this folder SQL server 2019 developer.

So, now it’s done that.

It’s opened up the SQL Server installation centre.

So there’s a lot of tabs on the left-hand side.

You don’t need to know much about them at the moment.

It’s the installation that we’re really going for.

So, going to click on installation, and we’re going to have a new SQL server standalone installation.

So, I can now minimise everything I’ve got.

So, you can see that it is asking what edition do you want? Do you want the developer? Do you want an express? Or you’re downloading one of the standard or enterprise editions and you want to give it 180 days trial? Or have you got a product key? Well, I’m going to download the developer edition.

I’m going to instal the developer edition.

So let’s click next.

So you can see down here on this left-hand side these are things that we have going down.

So I accept the licence terms, click next.

So it’s now going to check whether all of the set of files are there.

And you can see that it is installing a few sets of files.

So, I’m just going to pause this video right there.

It’s just done.

There we go.

We are done.

So, list of things to do get smaller, so everything okay.

It gives you a warning for windows firewall.

Don’t worry, click next.

And now, it’s going to ask you, okay, what is it that you want to instal? So there’s a huge list here.

If this is your first time, first of all, don’t worry you can always come back to it and add additional things.

If what you you’re looking for is to build your select statements, database administration.

Then I would start with just this.

Database engine services.

If you are looking for SSAS analysis services, then click on here.

And when I do, you’ll notice that this list expands.

So here’s our analysis services configuration.

If you’re looking for integration services, SSIS then click on this.

If you’re looking for anything else then you can click on it.

I would no longer select all.

I used to say select all but those were in the days when we didn’t have things like R and Python and Java so, only instal the stuff that you need.

Now, just one thing, if you’ve got a small C drive then you might want to change the instance root directory at this stage.

And there’ll be other places where you need to change it as well.

So, for the purposes of this course I’m just going to instal the database engine services only.

Not analysis services or integration services, though you can instal them if you wish.

So you can see what is going to be installed in addition to just the database engine services.

That’s all fine.

Next the computer’s just going to check that I have a valid selection and then it’s going to go into the instance configuration.

So, your instance configuration, this is what contains your databases.

If this is your first time installing SQL Server, then you should have a default instance.

It’s the first instance that anyone will try to connect to.

It’s the easiest to connect to.

So, let’s just click on next.

And then we have our server configuration and our database engine configuration.

So server configuration, I suggest at this stage you just leave everything as it is.

Go on to database engine configuration.

We’re going to be installing this in windows authentication mode, at least to start with.

So, that means that anyone who tries to connect to the instance and then to databases will be using their windows login.

And I want to add the current user.

And this is quite important, add the current user as an administrator.

Administrators have all of the power that you need in the instance.

If your C drive is on the small side then you might want to change these directories.

If not just leave them as is.

So, leave everything else as is and go to next.

So, now it is ready to instal.

And to instal you just press the instal button.

So, let’s click instal and it starts installing.

And basically you can now leave it alone for the next few minutes.

Now, while it’s installing, I’d like to talk about some different editions.

So I’ve talked about one type edition.

Are you getting the express, the developer, the standard or the enterprise.

However, every two years or so, Microsoft come out with a new version.

So we started off with SQL Server 2000.

That’s the first of the year named versions.

So 2000, 2005, and then 2008.

They don’t come roughly every two years.

And you might think the next one would be 2010 but it was called 2008 R2, release two.

However, it was actually released in 2010.

And then we have 2012, 2014, 2016, 2017, and then 2019.

So, you can imagine the next one will come in 2021.

Now SQL Server costs a huge amount of money if you are talking about the standards of the enterprise edition.

And that is one big reason why you might find big companies using older versions.

There are improvements in each version but they might not be sufficient for somebody who is wanting to spend or not spend tens of thousands of dollars, hundreds of thousands of dollars to upgrade.

And then there is a big hassle factor naturally upgrading.

So it’s easy for us who are just using it to understand this computer and you can uninstall and instal it.

Well, you haven’t got people relying on it.

So you might find that if you’re going into work you don’t have the very latest SQL Server.

And that’s absolutely fine.

And in fact a lot of people even if they were going for the latest version at work, wouldn’t instal it, wouldn’t buy it until the first big service pack has been released.

So, basically if you are using SQL Server on your home computer, get the latest one.

In this case, the 2019 version.

If you’re using T-SQL select statements, then there were quite a lot of improvements in the 2012 version and have been minimal improvements at least the intermediate level ever since.

So, you can use 2012, 2014, 2016, 2017, 2019 if you’ve got one installed.

Basically you will almost likely be fine.

However, this is how to instal SQL Server.

If you haven’t already got one.

In the next element, we need to instal the front end.

So this is the backend.

This is the thing that works in the background.

Next we’ll instal the front end.

Installing SQL Server Management Studio

– Right, now SQL server has been installed.

We can click close, and we go back to this menu of items.

And what we need to do now, is instal a front-end.

And that is SQL Server Management tools.

So I click on that, and I get onto this webpage, now if you don’t have this, so I’ll just close this, we can find this very easily by going to Google, and typing in S-S-M-S.

And you should say SQL Server as well because there is more than one type of S-S-M-S.

So you can see we get to download, SQL Server Management Studio.

So you can see we’ve got the latest version here.

Now, the latest version keeps updating, every two months or so.

So it may be a completely different version, to the one that you’ve got here.

However, it doesn’t matter.

They’re all basically the same.

At the intermediate level.

So in terms of styling, in terms of other things.

Really most of the changes happen, in the back half of SQL Server Management Studios.

So the connecting to databases.

So there are going to be two programmes which are going to be installed, SSMS and as your Data Studio.

So as your Data Studio, doesn’t have to be used with us here.

But it is a cut down version of SSMS, which is focusing on creating select statements.

So if you want to do anything else, you’ll find it’s not as useful as SSMS.

And quite frankly, I just use SSMS for everything.

So I’ll just click on it so you can see, it’s around a 640 megabyte download.

Now, if for some reason you find problems, with the latest version of SSMS, then scroll down the page and you will see, a link to previous versions.

Now you can only have, one edition of SSMS 18, on your computer at once.

You can have 18 and you can have 17, but only one version.

So if you have say 18.6 and you’re still 18.8, then the 18.6 gets upgraded.

So going to pause the video, while it downloads.

Right, so now you can see SSMS has just downloaded, so I’m going to click on it.

It’s going to ask me if I want to make changes, so the answer’s yes.

And now we download the virus checks, and everything else, you can just click instal.

So if you want to change the directory, you just click change otherwise, click instal.

And it’s a very smooth download.

And instal hardly anything to it.

So you can see it has all been installed successfully.

So I’ll click close.

So I’ll go to the search bar and type in SSMS.

SQL Server Management Studio 18, click on it.

And it opens.

Now you need then say, okay, which instance are you connecting to.

So, if you are connecting to your default instance, then you will either be using probably localhost, one word or just a dot.

Otherwise you could click on browse for more connections and then find a connection, or you might be given a server name.

So let’s click connect.

And here you can see, we are connected.

Now, I should also have a look at the Azure Data Studio, as well which has also been installed.

So what we need to do from here is new connection, and the server.

Again, I’m just going to put a dot, I’m going to leave everything else as is, and here you go.

I am now connected to my instance, using Azure Data Studio.

Now, as I said, there’s very few changes in SQL Server Management Studio in terms of visuals or anything at the intermediate level.

The biggest change really has been a restyling of these icons.

So now we have installed SQL server.

The back engine.

we have installed SQL Server Management Studio and the Azure Data Studio.

However, for this course we also need to instal another front-end.

We need to instal a front-end, that can handle all of SSAS, SSIS, and SSRS.

And we’ll be doing that, installing Visual Studio 2019 Community edition which again is free in the next video.

Installing Visual Studio

– Now, we also need to instal Visual Studio.

Visual Studio is the container of many things.

For instance, you can create programmes in VB.Net or C#.

And with regards to SQL Server, you can also instal SSIS, SSAS and SSRS.

So we’re going to instal this programme.

Now, you can see, the requirements are fairly minimal.

You need at least Windows 7 Service Pack 1, so if you’ve got Windows 8, Windows 10, you’re fine.

And we’re going to be installing the Community edition.

So that is a free edition.

Now, this web page, I just googled Visual Studio 2019 requirements, and you can see there are actually links to downloading but I’ll start from the beginning.

I’ll go to Google and I’ll type Visual Studio 2019.

And you can see here is the current website.

And I’m going to go to the Downloads section.

So visualstudio.microsoft.com/downloads.

Now, on the 8th of November 2021, Visual Studio 2022 was released.

However, the extension that we need to get our particular SQL Server programme to work has not yet been released.

Therefore, do not at the moment instal Visual Studio 2022.

Instead, we need to instal an earlier version, Visual Studio 2019.

Now, to get to this, we need to go to the bottom of this screen and go to Older Downloads.

Then expand 2019 and click on Download.

Now, notice, if you don’t have a Visual Studio subscription, you can create one for free by clicking on create a new Microsoft account.

So you may have a bit more to do than I do when you click on Download.

And then scroll down and go down to Visual Studio Community 2019.

It’s free, so you don’t need to worry about paying for it.

Click Download, and it will download a bootstrap.

So a very small programme that you get before you get to the main options for the installation.

Make sure you have got good virus protection, of course, before downloading any programme.

So I’m going to click on this.

I’m going to minimise everything else.

And you can see, it just needs to set up a free things.

Now, Visual Studio seems to have a major update every two years.

So there was Visual Studio 2017 and then 2015 and then 2012 before that.

And the versions, they change a little bit but there haven’t been huge versions for what we are doing.

However, there has been a bit of a change with Visual Studio 2019.

And that is how you actually instal the second bit, the bit that relates to SQL Server.

What we have to do in this Workloads section is go all the down to other toolsets.

So it’s the last section.

And click on data storage and processing.

Connect to SQL Server.

So click that, and over here on the right-hand side, you’ll see it’s going to download some optional data tools.

That’s fine.

So you can see the total space required.

About eight gigabytes once you include the bootstrap and so forth.

So click Instal.

And as you might imagine, there’s going to be an awful lot of downloading and installing coming up.

So here you can see, it’s downloading in the background and there are quite a number of packages to instal.

292.

So I’m not going to take the survey.

And it’s now a waiting game.

It’s going to be downloading and installing a lot of packages.

So I’m going to continue the recording but I’m going to speed it up and then we’ll see what happens.

So as you can see, no problems installing.

So I’m going to reboot the computer, and then we can open Visual Studio Community.

Adding SSAS

So now I’ve installed Visual Studio, let’s open it.

So I’ll go to Start menu and go to Visual Studio 2019.

So for the first time you run it, it’s just going to get things ready.

So I’m going to click on continue without code.

I just want to click through.

However, if I go to File, New, Project, and look for SASS or look for Analytical, then you’ll see that our programme has not been installed.

We have to add it into Visual Studio.

And we do that by going to Extensions, Manage Extensions.

And go to Online and the Visual Studio Marketplace.

And you’ll see here, we have Microsoft Analysis Services Projects.

So click Download.

Now, it’s quite a hefty download.

330 megabytes.

So it’ll probably take a minute or two to download.

So you can see it’s downloaded and it says your changes will be scheduled.

The modifications will begin when Visual Studio is closed.

It’s not very easy-to-understand language but basically, close Visual Studio and it calls itself modify.

It will add into Visual Studio the SSAS extension that we’re going to be using.

And it’s a very easy instal.

After this initialising phase is over, we’ll see do you want to modify Visual Studio with the SSAS? So click on Modify if you’re happy for it to be installed.

And then it just instals.

So again, I’ll speed up the video and you can see it being installed.

So you can see that SSAS has been installed.

Fine, your modifications have been successfully applied.

So let’s now open up Visual Studio 2019.

Go to File, New, Project.

And if we now look for Analytical, we’ll find we have the ability to create a new SSAS MDX project.