How to install SQL Server 2019 Developer and SQL Server Management Studio (SSMS) - for FREE

Video Statistics and Information

Video
Captions Word Cloud
Reddit Comments
Captions
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 favorite search engine and have a look for download sql server 2019 and you can see that the top instance here is from microsoft.com so let's click 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 specialized 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 in 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 or we are downloading at the moment is the back engine 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 are 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 free specialized 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 center capacities the standard edition 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 licensed 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 install but you can't expand it if you want to go into these other rounds of ssrs ssis and ssas now the sql server developer edition used to be a boxed product until the 2014 edition it sold for around 200 us dollars and indeed i 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 server to install it on no in fact the hardware requirements are fairly basic all it requires is a minimum of six gigabytes of available hard disk space yeah right i don't believe that it only requires a gigabyte of memory yeah right but you can see that these are really small requirements the major thing that it requires is a 64-bit processor if you don't know whether your computer has got a 64-bit 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 go to properties and you'll see if you have got a 64-bit operating system or not so it is now downloading so i'm going to allow it to finish downloading so i'll pause the video here and we'll start with the installation 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 we made yes click ok 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 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 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 minimize 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 are you downloading one of the standard or enterprise editions and do 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 install the developer edition so let's click next so you can see down here on those 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 setup files are there and you can see that it is installing a few setup files so i'm just going to pause this video ah there we are it's just done there we go we're all 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 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 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 install 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 now you may notice that there is this looking for reporting services downloaded from the web up here now unfortunately first of all if you click it you'll get an out of date link this leads to sql server 2017 reporting services and there is a 2019 version available so that link is not the best link to download secondly we don't actually need this reporting services instead we're going to be using visual studio 2019 with an ssrs add-in so you don't need this reporting services here and even if you were going to install it you wouldn't install it right now you installed it once sql server 2019 setup has been finished with now for the purposes of this youtube video i'm going to keep all three of these checked now you may notice that there is a reporting services link up here don't use it if you click on it first of all it gives you an out of date link it gives you sql server 2017 reporting services whereas there is a 2019 reporting services available which you can just google to download secondly you only need it if you are not going to be using visual studio 2019 and there is a link in this youtube video to installing visual studio 2019 wave at the ssrs add-in so you don't need this link at all so you can choose to install ssas you can choose to install ssis there's no additional complications no additional options that you need for ssis there is one choice you need to make if you're installing ssas you will need to install database engine services in any case so let's click next whether you're doing dba ss rs or learning about tsql statements so let's click next oh by the way if you have got a small c drive you might want to change the root directory where it's going to install so the computer is now just checking to make sure that this is a valid set of selections and then it's going into the instance configuration so the instance is where your databases are held you can have more than one instance on your computer the default instance should be your first instance it's the one that's most easy to connect to after that you should have named instances the only reason really why you need to have two sets of instances is if you want say developer and express on at the same time but more usually if you want two different flavors of ssas i'll explain what that means in just a moment so i'm going to keep this to the default instance and click next we then go on to the server configuration at this stage i recommend you leave everything as is so just leave it as what it says and then next and we're going to the database engine configuration i would suggest that you leave this unless you've got a reason to do so as windows authentication mode this means that anybody connecting to the instance and then the databases will use your windows credentials your username and password now you need to add yourself assuming this is just a test machine that you are just using for yourself as an administrator so click on add current user and again let's go into data directories if you have got a small c drive then change all of these drive letters and paths accordingly you don't need to do anything with any of the others at this stage click next now this is when we get into the ssas configuration if you have chosen to install it there are two types there is the older mdx version multi-dimensional and there is the newer tabular mod which came in in sql server 2012 so you need to choose which one of these two mods you should be using in other words what do you want to learn so i'm going to put on the mdx mod and i'm going to now click add current user because i want to have administrative permissions for ssas again if you've got a small c drive go into data directories and change the directories and that's it the computer now goes okay i'm happy with all of these installation suggestions and now to install you just click the install button so let's click install 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 then came roughly every two years and you might think the next one would be 2010 but it was called 2008 r2 release 2. 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 standard or 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 we're just using it on a standard computer and you can uninstall and install it will 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 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 sql server on your home computer get the latest one in this case the 2019 version if you're using tsql 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 sql 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 we'll install the front end right now sql server has been installed we can click clause and we go back to this menu of items and what we need to do now is install a frontend and that is sql server management tools so click on that and i get onto this web page 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 ssms and you should say sql server as well because there is more than one type of ssms 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 studio so it's connecting to databases so there are going to be two programs which are going to be installed ssms and azure data studio so azure data studio doesn't have to be used with azure 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 i'm 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 is yes and now we don't know the virus checks and everything else you can just click install so if you want to change the directory you just click change otherwise click install and it's a very smooth download and install hardly anything to it so you can see it has all been installed successfully so i'll click close so go to the search bar and type in ssms sql server management studio 18 click on it and it opens now you need to then say okay which instance are you connecting to so if you're connecting to your default instance then you'll 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 azure data studio they're the front engines and now we can start looking at databases so i hope you've enjoyed this video now if you did want to go further and use ssas ss isl ssrs then you also need an additional install you need to install visual studio 2019 community edition which again is free and then you need to install the appropriate add-in and there is a video on my youtube channel about how to do precisely that so i hope you will look at that as well if you enjoyed this video please click the like button and why not subscribe and click the bell right next to it that way you'll be notified of any new uploads thank you very much for watching and keep learning [Music] you
Info
Channel: SQL Server 101
Views: 12,247
Rating: undefined out of 5
Keywords: sql server, how to install sql server, sql server installation, install sql server, how to install sql, sql, sql server management studio, sql server tutorial, how to install sql server on windows, ssms, install ssms, install sql server on windows, install t-sql, install sql, install sql server management studio, how to install ssms, microsoft sql server, install microsoft sql server, how to install microsoft sql, install microsoft sql, install sql server 2019
Id: Y_J6zMvV_jM
Channel Id: undefined
Length: 21min 13sec (1273 seconds)
Published: Tue Mar 16 2021
Related Videos
Note
Please note that this website is currently a work in progress! Lots of interesting data and statistics to come.