Installing SQL Server Developer 2019

Phillip Burton
A free video tutorial from Phillip Burton
Best Selling Instructor - over 300,000 students so far
4.5 instructor rating • 47 courses • 309,602 students

Lecture description

Now let's go through the process of installing SQL Server.  I'll also go through the various editions of SQL Server (e.g. 2008, 2012).

Learn more from the full course

SQL Server SSAS (Multidimensional MDX) - an Introduction

Create cubes from databases, analyse them in Excel, SSRS etc. using SSAS MDX (a Business Intelligence tool)

07:48:56 of on-demand video • Updated March 2021

  • Create cubes in SSAS, based on fact and dimension tables.
  • Process the cubes, and analyse them in Excel, SSRS, and access them in SSMS.
  • Learn some of the more advanced items, such as translations.
English [Auto] 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 and and a box, so I'm going to now double click on the XY, so do you want to allow changes were made? Yes, click OK. And it will now extract it all into this folder. Ezekial Server 2019 developer. So now it's done that it's opened up the crossover installation center, so there's a lot of tabs on the left hand side, you don't need to know much about them at the moment is the installation that we're really going for. So going to click on installation and we're going to have a new secure server, standalone installation. So I can now minimize everything I've got so you can see that it is asking. What Ed. do you want do you want the developer, do you want an express? Are you downloading one of the standard or enterprise editions and you want to give it 180 days trial or have you got a product? Well, I'm going to download the developer edition. I'm going to install the developer edition. So let's click next so you can see down here on the left hand side, these are things that we are going down. So I accept the license 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 set of files. So I'm just going to pause this video. Oh, there. It's just an. There we go. Well done so. List of things to do, get smaller. So everything OK? It gives you a warning for Windows firewall. Don't worry. Click next. And now it's going to ask you, OK, what is it that you want to install? 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 are 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 S.A.S. 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, SS is 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 install the stuff that you need. So as this is an S. S course, I'm going to keep the database engine services and the analysis services are not going to install the integration services unless you wish to do so. So I click next and it's just going to make sure that this is a valid selection and then go on to the instance configuration. So the instances where your databases are held, if you haven't installed Ezekial Server before, then you should have a default instance. It's the one that's easiest to connect to. If not, then you need a second instance and that is called a named instance. Reasons why you might want more than one Escorial server on the same machine. Well, let's say you were installing SSL as both in the MDX mold and in the Tabulam Odd. Both of those require different instances. They can't sit on the same instance. So next we'll go to the server configuration and. I recommend at this stage, just leave everything as is. We don't go to the database engine configuration, I'm going to have this installed in Windows authentication mode. So that means when people log onto an instance and get a database, they're using your Windows credentials or username and password. It's important that you add yourself as an administrator while you are just testing everything while it's on your machine. You don't do this if it's a production machine. If you have got a small C drive, then you might want to change these data directories. Otherwise, just leave them alone. Click next and then we'll go into the analysis services configuration section. So as you can see, there are three different models. And as this is an SS MDX course, you need to install this using multidimensional mod if you want to learn more than you'll need to install a second instance, a second Ezekial server developer again, you should add yourself with administrative permissions. And again, if these data directories are not appropriate because you've got a small C drive, then you should change them here. Click next. And now we're ready to install. So if everything looks OK, just click install. So let's click install and it starts installing and basically you can now leave note long 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 Ezekial Server 2000. That's the first of the year named versions. So 2000, 2005 and then 2008. They then came roughly every two years. And you might find the next one would be 2010, but it was called 2008 are to 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 Ezekial Server costs a huge amount of money if you are talking about the standard 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 in actually upgrading. So it's easy for us who are just using it on a standard computer and you can uninstall and install it. Well, you haven't got people relying on it, so you might find that if you going into work, you don't have the very latest secure 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 install it, wouldn't buy it until the first big service pack has been released. So basically, if you are using Esker or serve on your home computer, get the latest one in this case, the 2019 version. If you're using it to 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 install a secure server. If you haven't already got one in the next element, we need to install the front end. So this is the back end. This is the thing that works in the background. Next will install the front end.