Simplify Your Workflow with the Laptop Bill Format for Production

Laptop bill format for Production

right you're able to see my screen right guys yes okay fine yeah so let us start the session guys in the morning session we discussed about the uh Windows Server versions we discussed about the bill number we discussed about the bill number format and we also discussed about the editions the editions of the SQL Server different editions of the SQL Server so all these things we discussed in the last session so in this session we are going to cover the virtual machine creation so we'll start the demo slowly as discussed in the morning session so we have to SQL Server right so if I want to the equal server first I have to create the environment platform we have to create first so that process we'll discuss today we'll try to set up the environment so we'll create one virtual machine and then we'll the operating system so all these things will be discussed slowly guys okay fine so now I want to the SQL Server okay now I want to the SQL Server guys so if I want to the SQL Server what we have to do generally we should have a platform right we should have a platform so for that what we are going to do guys I'm going [Music] to create a platform okay just a minute I'm going right so now what we have to do guys we have to create a platform so generally as discussed in the morning session we will the SQL servers on the Windows servers guys so if I want to the Windows Server first of all I should have a virtual machine guys there are two types of machines guys there are two types of machines okay okay let me add this we have three important additions in SQL Server developer okay Developer Edition Enterprise free from 2017 onwards then standard edition very good and Enterprise Edition okay yeah so okay so let me go back to this this is the problem with the two screens multi screen okay fine gopy Madu any questions so far if no questions you can be mute Madu please ping me in the whatssapp once Madu please ping me in the WhatsApp right okay so now I want to SQL Server guys okay we have to SQL Server as discussed SQL Server is an application okay this application we can on any of the operating system okay so we will use server operating systems as in the organization we will use only server operating systems we don't SQL servers on the desktop operating systems guys so I have to the server operating system so if I have to the server operating system what I have to do guys okay we have to create a virtual machine we have to to create a virtual machine so what is this virtual machine and all how we will create the virtual machine how we are going to allocate the resources to the virtual machine how many types of machines are there let's discuss guys there are two types of machines guys two types of machines okay one is your physical machine or same bare metal bare metal will also call it as a physical machine guys second one is your what viral machine VM one is first model is your physical machine or bare metal second model is virtual machines guys so what is the difference between physical machines and virtual machines guys can anyone tell me what is the difference between physical and virtual machines sir physical means our own laptop virtual machines means another desktops we got to in our physical laptop good any other we can butal miss we cannot touch very good very good yes very good next any other inputs guys right so physical machine or bare metal means we can see we can touch and we can feel is your physical machine your laptop is your physical machine guys your laptop is the physical machine you can see the laptop you can feel the laptop you can even touch the laptop so that is called physical machine but what is the challenge with the physical machine guys if it is one laptop that will be fine or if it is one machine that will be fine if I want to maintain 100 machines right if I want to maintain 100 machines I should have a separate room I should have a separate power I mean to say the power system and all we should have a separate power system we should have a separate cooling we should have a separate Network to manage all these 100 servers 100 machines machine server both are same guys don't get confused here machine server these are all different different words we'll use it in a different scenarios but both are same okay so if I want to if you go to any engineering College lab you can see guys if you go to any engineering College lab computers lab and all you can see around 20 30 computers will be there in a room so it will be like having cooling system and all only for that room and principal room will have cooling system in the colleges right there you can see the whole row of the computers so that is the challenge with the physical machines you need a complete separate room cooling system power and all Network and all so you have to maintain all these things okay fine and as I said we are managing 7,000 servers guys for 100 servers itself if we need a separate room for 7,000 servers can you imagine I should have a big building itself that is called Data Center what is that guys data center data center is nothing but collection of servers is called Data Center guys it can be 10 servers it can be 20 servers it can be 100 servers it can be thousand servers it can be 10,000 servers also collection of servers we'll keep it in one location like one building or one room okay so that is called a data center guys so the challenge with the physical machine is for example your machine is there yes STi for example we are not going to maintain all the 7,000 servers in a single location guys why if we keep all the 7,000 servers in a single location what will happen guys tell me what is the challenge with that if you are keeping all your money yes if you're keeping all your money in a single asset what is the challenge with that guys tell me there is no guant correct if something goes wrong then we can't even recover it guys so if you keep all the servers 7,000 servers or thousand servers or 100 servers at one location what is the problem guys if something happened like disasters if any fire accidents if any tsunamis if any Cyclones if any floods are there if any earthquakes are there or if any hardware failures are there if any OS failures are there it will be difficult to recover will be difficult especially during the disasters it will be difficult to recover for example if I kept all my servers in Bangalore if floods are there very regularly very commonly okay floods and all like they will hit the cities generally so if huge floods are there then I'm going to lose all my data right so that is not at all a good Dr solution Disaster Recovery Solution so what we are going to plan guys generally in the organization we'll keep few servers in Bangalore City we'll keep few of them in Mumbai we'll keep few of them in outside the country like Dubai or Singapore or Australia or us or UK so like that they are going to plan it if something disasterous happened at least the other servers in another location will save us will save the data so for all this purpose we are going to maintain servers in different different locations guys if it is a physical machine imagine in the US data center one physical server is there something happened to that physical server guys how you are going to troubleshoot it how you will troubleshoot it guys something happened to the server that is there in the US data center maybe in New New York data center we have one server something happened to that machine it's not turning on how you are going to troubleshoot again one engineer has to go to that location he has to look into it what is the problem where is the problem he has to fix it means physically he has to go and he has to troubleshoot if one server is having issue in the Australian data center again the same issue so that is the challenging task with the physical machines guys that is the challenging task with the physical machines and all so something went wrong again some Engineers has to go to the location and they have to troubleshoot it and for to maintain that many servers you need a very big building you need a very big cooling system you need separate cooling system separate Network separate power standby power also suddenly if the power is gone to manage 7,000 servers you need a separate power system also so all these things keeping all these things like these are all kind of challenges to maintain the physical machines guys so initially when when when Microsoft or any other systems invented initially like IBM and all so initially of course we don't have any virtualization concept so initially we used to use physical machines only so if you go to any company and all they use it to maintain big big buildings as a server uh like what is that data centers and all they use it to maintain a separate building for data data centers now if you go to any office organization you don't see a separate building to maintain the servers small room is enough Guys small room is enough they can manage terabytes of storage they can manage hundreds of servers they can manage um terabytes of RAM storage everything they can manage so why what happened guys after physical machines okay the whole industry was done into like virtual machines guys so the virtual machines are introduced okay like late 20 2005 2000 kind of thing 2003 onwards like it was started okay getting occupied that whole industry and all so earlier we used to use physical machines but later once virtual machines introduced what is virtual machine guys virtual machine means we can see we can feel but we cannot touch okay what is the virtual machine guys we can see we can feel but we cannot touch guys so your phone is a physical machine or virtual machine guys your phone is a physical or you can feel you can see you can touch it physic right Siri is physical or virtual can you touch Siri no it's virtual it's virtual Google assistant is virtual so you can see Siri you can feel Siri but you cannot touch Siri like in the same way Google Assistant also the same way so you can see they will exist virtually virtually they will exist but they will not exist physically just virtually they will exist guys but again you have to provide all the resources for a system whatever resources are there you have to provide all the resources like Ram CPU storage and the other resources and all you have to provide but we don't need to maintain a separate building on all so using this virtualization Technique we can maintain guys so let's discuss how this virtualization and all will work guys okay let's discuss how this virtualization will work let me open I have a question may I ask here tell me no problem yeah yeah please for okay sir sir in real production environment the companies are running their their databases on a virtual machine or a physical machine number one my second question is Sir as the virtual machines are running on the physical machines on the on the physical on a host operating systems okay if the host Opera systems are crashes the database or the virtual machine that are was running or residing on this host uh Opera system will also be Crasher what is the what will be the scenario in those cases sir I'll I'll answer for the first question what is your second question I'm not getting sir my second question is as the virtual machines runs on the physical machines on the whole operating system a physical operating system like Windows Server 2000 or what whatever it is okay if if the windows are if the window crashes or goes down due to some reason the host machines uh the um virtual machines that are running on these uh window yes will also be on risk risk sir my question is correct correct yes will be down yes I'll I'll tell you I'll tell you it's not going to run like a normal Windows machine and all I'll tell you okay yes fine so now see guys how the virtualization will work okay again for every machine we need RAM we need CPU and we need the storage so what is the difference between RAM and Rome guys can anyone tell me what Ram will do what Rome will do Ram or memory both are same guys Rome or storage both are same and what CPU will do guys can anyone tell me Ram is temporar stored the data okay Rome is permanently store the data okay CPU is in between work RAM and between okay in between okay fine okay so very simple guys very simple I'll tell you correct okay so let me add few things related to this ram ram and how CPU will work so for example uh 4 + 2 into 3 - uh 2 + 6 okay divided by something like 2 can you tell me what is the answer guys for this please calculate and tell me the answer 11 11 11 11 try your answers guys just tell me the answer what is the answer for this I want to see your basics of mathematics tell me your tell tell the answers gu for this 4 + 2 into 3 - 2 + 6 by 2 what is the answer 11 11 Paka yes are you sure two sir sure Paka okay so you how you calculated 4 + 2 six six 4 + 2 6 into 3 18 - 2 16 + 6 16 + 6 how much 22 by 2 11 very good very good okay anyone 19 19 Madan is saying 19 why there is a difference why Madan added extra eight here what about other H so anyone knows about this Bard Mass guys BM rule we need to use bmas rule here first first divide multiply and divide sir first we have to multiply blindly calculated 4 plus 2 into 3 - 2 + 6 by 2 and Sir 11 sir yes sir sure sir bmas bracket of division multiplication division multiplication addition and then subra okay so even though you here we can see addition multiplication subtraction again addition again division so we have lot of operators here so you cannot directly go and just calculate it like that guys you have to go in this formula only okay bracket off we don't have any bracket if you want you can add bracket also division first you have to divide it first so 6 by two how much 6 by two how much three okay then multiplication 2 into 3 how much 6 6 + 4 how much 10 6 + 4 10 okay - 2 - 2 8 then how much is this three three we are getting 11 only yes was it shouldn't be yeah okay let me add this one okay and 6 by2 anyhow it's three right three okay and then 2 into 3 6 right so - 2 + 3 how much guys - 2 this is six right 2 into 3 6 - 2 + 3 1 1 okay and then this is how much six 6 + 1 seven correct answer good guys okay correct answer it's 11 only okay but again you have to follow maybe because of the combinations it's not working but again you have to follow bmas only so b as per bmas so now how this Ram will why we are discussing all these things shanuk it is equal Tob a class right I hope it's not basic mathematic class yes you have few doubts why we are discussing these things means what Ram will do guys Ram will temporary temporarily it will store the data what data will store for example if this is the calculation as for the B Mass first it has to divide this so once it divided this value you will get three that three where it will store it will store temporarily in the ram guys RAM memory both are same so who is going to do this division multiplication Edition the processing and all will be done by your CPU your CPU will do the calculations not only calculations the processing and all will be done by the CPU it's a kind of a mind brain okay so then the temporary results will be stored in the RAM and then finally okay if you want to store the data so that will be stored in the Rome Rome means your hard disk your storage so once it was stored permanently in the disk so data safety will be there but if it is in the ram there is no safety guys once you restarted your laptop the whole Ram will be cleared so that's why Ram you will have 16 GB 8 GB and all just for the processing purpose whatever the intermediate or in between results we are going to get it through this Ram through this processing that will be stored temporarily to complete the whole transaction that will be stored temporarily in the ram ram is not going to store any type of data once you restarted your laptop again the 16GB whatever is there it will be cleared the applications that are using the ram will release the application so whatever data is there in the ram that will be flushed guys when you restart the laptop whereas storage your going to store lot of photos videos in your hard disk when you restart your laptop are they going to be deleted guys no for example I just lock I just typed here you can see I just typed some data here it hasn't been saved till now okay just normal in the notepad I just typed this data if I saved this data it will be stored permanently in the hard disk in the room okay room but I haven't typed right until then until I'm going to store this per it will be stored in the memory guys if someone restarted my laptop I going to lose this data why I didn't saved it if I saved it it will be stored permanently in the hard disk if we don't store it it will be temporarily stored in the memory guys that's what a memory will do and that's how a storage will work and that's how a CPU will take care of the processing and all guys is it clear now so how virtualization will work physical machines and all you know but how virtualization will work guys so imagine this is the organization imagine this is the organization in the organization for every machine we need three basic components guys what are those three basic components for every machine what are the three basic components we need guys just now we discussed same CPU Ram hard disk correct okay we need CPU we need RAM and we need storage storage hard disk Chrome all are same okay CPU let's add some CPU pools guys okay this is my CPU pool okay what I'm going to do I'm just going to resize it I'm just going going to add some CPUs here right and storage hard disk okay hard disk right so we having a pool of stories okay pool of storage guys and then Ram okay CPU stage Storage storage pool pool means collection guys that's it and RAM so now generally for physical machines and all physically for example if your laptop like our laptop is a physical machine so you can see your hard disk physically you can see your RAM and all physically you can see your CPU and all physically you can see if you want to insert extra Ram again you have to buy the extra RAM and you can insert it right you can insert one slot but whereas how virtualization will work guys there are some softwares okay so those are called virtualization softwares what this virtualization softwares will do guys this virtualization softwares will help you okay to share the resources to the respective machines guys so now if I want to create any virtual machine okay Windows Server I want to create a Windows Server customer is asking me to create a Windows server with 16 core CPU um 250 GB hard disk and 32 GB memory guys customer is asking us asking us means is asking the windows team so what Windows team will do guys they are already having a pool of resources these are all called resources guys they have a CPU pool they have a storage pool they have a memory pool they will keep adding guys they will keep adding and all to the resources now if customer is asking us for example these are like 64 core imagine these These are 64 core or 128 core out of this 128 core CPU they will allocate two resources virtually to this machine using how using this using this virtualization software guys using this virtualization software so this virtualization software how it will work guys this virtualization software will help to allocate the resources from the existing pool it will help to allocate the resources from the existing pool guys so from here it is going to take from particular CPU pool it will take and it is going to allocate out of 128 core it will allocate two 32 core CPU to this virtual machine guys okay and then memory out of maybe this is 128 GB memory okay they have reserved memory 128 GB memory so customer is asking for 64 GB right and again they will take this 64 GB of memory okay and that memory they will allocate directly allocate to this particular machine again who will do that again using this virtualization software they are going to allocate memory and they are going to even allocate the storage also so using this who is going to allocate all these things guys your virtualization software will allocate all these things okay your virtualization software is responsible to allocate the resources guys so the virtualization software using the existing physical resources it is going to allocate the resources to the new virtual machine so this machine will have as discussed okay it will allocate let me try properly okay so two CPU course it will allocate here you can see it will be deducted guys okay okay and maybe 256 GB storage right it will be allocated here and uh 16 uh 32 GB right so it is going to allocate these resources to the particular machine now with all these machines with all these resources okay what Windows team will do windows team is going to create a virtual machine guys see here virtually they will allocate using the physical resources once you added your physical resources to the pool that will be visible in the virtualization software those resources virtually they will allocate and they will give it to the particular virtual machine now we have only these many resources guys if it is 128 core we allocated 64 core right we have only 64 core CPU now if we have one TB or 2 TB storage out of 2 TB I just allocated 256 GB so 1.7 TB storage is remaining here if you have 128 GB 64 GB memory I have allocated to this machine so remaining pending is 64 GB next time when they are creating one more machine they are going to allocate the other resources if the resources are finished completed allocated to all the machines then they will keep adding the resources to this resources to this particular pool guys are you getting the point everyone so the advantage with the virtual machines so no need to set up the whole building and all if that's why the whole even though you are managing hundreds and thousands of servers you will have racks guys racks in the sense like this it will be racks okay storage rack okay let me show you like this okay so it will be like this guys so the server rooms look like this okay this is how the server rooms earlier guys nowadays maybe in the Microsoft Azure AWS and all will maintain like this but generally in the organization you'll have a single kind of a what I can say a wardrobe kind of thing same like wardrobe kind of thing guys see here each and every machine physically you can see in this there is a slot kind of thing see here one slot kind of thing this will have memory CPU and storage also so when you added once this rack is finished as discussed here if all the resources are finished they are going to add one more rack with the reserved resources and they are going to assign those resources to other virtual machines guys so earlier before the racks we used to maintain the server rooms like every machine physically we used to maintain now no need to maintain the machines physically just virtual machines so anywhere from anywhere you can start the virtual machine from anywhere we can stop the virtual machine okay from anywhere you can troubleshoot it in case if any issues are there Hardware related issue anyhow in the data center people will be there they are going to troubleshoot it and they are going to fix the particular issue and all once the hardware issues are fixed then it will be visible again in the virtual machine platform so using those resources who is going to create guys this is just for understanding purpose how the basic layer will be in the organization we are not going to do any of these tasks in the organization you are not allowed to do these things also even though you are interested still they don't allow you to do this we are DBS we are going to take care of the database Administration even though you know Windows Administration maybe if it is a startup company kind of thing they might ask your help if it's a big company or normal company every team separate team will be there you will not even have permissions also to do windows related tasks guys okay you are limited to do your activities only clear guys the advantage of the virtual machine is no need to maintain the separate buildings and all you can manage the whole infrastructure in a room okay and if something went wrong you can virtually troubleshoot it you can just take care of the servers virtually we don't need a separate whole building cooling system and all just if you can maintain the cooling system for a room it is enough networking is also same power is also same so you are going to save lot of money guys lot of money so hardly in every organization 95% virtual machines will be there 5 percentage physical machines will be there clear everyone 95% virtual machines and 5% physical machines will be there guys in the organizations So This Is How They are going to be managed so using the virtualization technique you are going to allocate the resources to the virtual machines so the virtual machines whatever virtual machines we are creating once we created that virtual machine what will happen guys so we are going to give this now the server is created with all these resources then I can SQL server on this guys what I can do I can SQL server on this okay I can happily why because the server is ready machine is ready now I can once it's ready I can the SQL Server so SQL Server will be up and running from this machine guys now if something happened to that machine okay imagine this is your SQL Server the SQL Ser is up and running or let me go with this one yeah SQL Ser is up and running on this machine guys so until this machine is up and running your SQL Server also will be up and running if there are no issues from the SQL server side so this is how it will be managed guys this is how the resources will be managed so if I want to SQL Server what I should have guys first what I should have what I should have guys we have server we should have a window correct if you if we should have virtual machine who is going to do all these things who is going to create virtual machines your windows team or VM team will create all these things and all they are going to create virtual machines using one virtualization software that virtualization software can be a VMware that virtualization software can be an oracle virtual box that virtualization software can be Microsoft hyperv guys hypervisor okay so any of the softwares they will use the famous one is VMware most of the organizations will use VMware as a virtual means the software I told you that using this software they are going to allocate the resources so this software can be a VMware this software can be a v virtual machine virtual box and this software can be a h hper V guys but whatever they are using okay whatever they are using at the end of the day server is available or not that is our main priority whether they are using VMware here whether they are using virtual box here whether they are using hyperv here okay there is no concern about it nothing to worry about it so you are not going to work on VMware virtual box hyperv and all whatever it is final product is the server so if the ser is available the users okay users like you okay will be connected to the server and he is going to take control of the server and he is going to the SQL servers guys on this virtual machine so whatever software that you are using as a virtual machine software so that is none of our business okay whether the server is available or not if the server is available we'll directly connect to the server we'll the SQL server on this particular virtual machine guys clear so now Faruk you ask right so in case we are giving we are allocating the resources okay from one physical machine if that physical machine is down okay how you are going to how we are going to manage so that's why we have a high availability okay there are some chances there can be Hardware failures there can be a network failures there are different different challenges are there so there is no guarantee to the man or machine okay so in case if something happened to the track High availability will be there between the racks so if that rack is down okay or if that particular data center will be down is down another data center another rack from another data center will be available to make sure the resources are continuously okay allocating to that particular virtual machines guys okay if you don't set up high availability then it will be difficult you should set up high availability for that with a single if you are using a laptop guys see I also created virtual machines here so using the virtual Oracle I'm I'm going to use Oracle virtual box guys throughout the practice so shanuk why arual box I am good in VMware I'm good in hyperv people will ask like that there are several reasons also one thing is whatever the virtual machine software we are not going to work on this so whether at the end of the day we are able to create the servers or not you can create the servers using VMware or actual box or hyperv anything you can use why virtual box specifically means virtual box will run with the least Resources with 512 GB 512 MB RAM also you can start a server whereas in the VMware very difficult you cannot start the virtual machine with 512 MB RAM okay but whereas in the vir in the arle virtual box you can even start you can create a machine you can start a machine with 512 MB RAM also so lightweight process when compared to VMware I feel arle virtual box is a kind of lightweight process and if you give good enough good amount of ram so it will work like nicely it will work whereas VMware needs lot of resources like in terms of CPU memory and all so that's why we are going to use arle Virtual box guys but again whatever it is the end product is whether we are able to access the servers or not whether we are able to access the whether we are able to create the servers or not so in between they can use any software so that is not our work that will be taken care by the windows Team guys Windows admins clear guys about the virtualization now yeah yeah yes any questions doubts yes yes please uh kindly explain the difference between Oracle vers ual box and Hyper Vis not required not required for I told you right that is not our business okay sir okay okay yeah so this is how it will yes yes please Madu one more box can many windows only one Windows Server very simple see very simple thing see for example you have 10 Rupees Madu so how to how many people you can share the 10 Rupees Madu tell me you want to share the 10 Rupees to how many people you can give that 10 Rupees you can share simply how many people so if you are giving 55 rupees two people if you are giving 2 two rupees five people if you giving one one rupee 10 people so it depends upon the quantity how you are sharing how much you giving so how many virtual machines I can create shanuk here if customers are asking 16 core CPU out of this pool you will allocate 16 core CPU if some customers are asking 64 core CPU so depends upon the resources you have if the resources are completed finished see now all these resources this machine is holding all these resources until you decommission this machine you cannot utilize these resources so you can utilize only pending resources so it depends we cannot say how many virtual machines we can create it depends how much you're allocating how much CP you're allocating whether you're allocating one rupee you're ating 2 rupees you're allocating 5 rupes whether you're allocating whole 10 Rupees so depends upon the allocation only you can tell so there is no correct answer that depends on the resources some servers will be 16 GB some servers will be 32 GB some needs 64 GB some needs 128 GB so like that depends on the resources you can tell so there is no correct answer for that how many virtual machines we can create in the sense if again the same for 10 Rupees okay how many shares you can means depends upon the share it is one Rupee or 2 rupees or whole 10 rupees or 5 rupees or 3 rupees or 4 rupees depends upon the share only so this is how so there is no particular fixed number as it is like a the resources are like varying between machine to machine there is no fixed number but that means okay based cor Bas requirement correct yes uh it is same apply for Windows servers also yes yes Windows of course of course yes it will be applied the same as like how virtual machines are there the same like SQL servers also that will be discussed later okay yeah see guys so I'm having 16 GB ram my machine is having 16 GB Ram see how many machines I have created this is one Machine 2 3 4 5 6 7 8 9 10 machine mach are there here how I running 10 machines guys so if I give 2 to GB also 10 into 2 at least one machine needs 2 GB right roughly 10 into 2 I need at least 20 GB but to manage all these things I also need RAM to my laptop right my local laptop is also going to use a ram so for local laptop minimum to minimum if it is Windows 10 minimum it will take 4 GB worst case so 24 GB how can I managing with a particular 16 GB very simple even though I created 100 servers here I can create 100 servers here with 16 GB Ram also but these are all in powered off State see so if it is in powered off State it is going to okay it is not going to use the resources are you getting the point guys I can create 100 machines here but if you are starting if I'm starting all these 10 machines that's it my laptop will be hanged why because because every machine is going to consume the whole memory and all so as they are in power off State I can create any machines n number of machines why because if it is in power off State it is not going to consume the resources that's how it is going to work guys so all the machines are in powered off State now but generally I can run three machines at a time okay even I have 10 servers I can still run only three machines at a time guys clear everyone why because once these three machines are started it will start allocating the the memory and all will be allocated to these three machines and my local laptop of course one more machine so parall four machines are running so that is enough my Ram is manage my Ram can manage four machines okay but if you want to start fifth machine and all again it will be hanged the whole RAM and CPU will be busy and it will be hanged so that's how even though you have multiple machines still you can manage it by just powering off and on guys this is how we are going to manage the things clear guys now are we good fine so what we will do now let's discuss Let's uh start creating the virtual machines so if I want to create this virtual machine what I should have guys first tell me now tell me the order now if I want to create this virtual machine now so what I should have first virtual box virtual machine software right so I'm going to use Oracle virtual box software okay so let me show you how to Oracle virtual box software in my machine it's already installed so I cannot uninstall and I cannot show you how to it again so if anyone anyone join from the laptop if anyone is ready to share your screen you can share the screen make sure you don't have virtual machine till now or box still now so if you can share your screen I'm going to help you how to download it and to it guys Okay one minute fast yeah I'm just telling you you can share make sure there are no personals on your screen it will be uploaded to YouTube sometimes okay so make sure there are no personal yeah yeah nothing is there okay fine good so guys downloading and installing orle virtual box is very easy very simple uh this doesn't need any kind of discussion we'll simply go go to the uh you can close it close this browser close this uh tab just close it so you can just go to Google you can type Oracle download orle Virtual box just go to Google and download Oracle virtual box guys every software will have version I told you at SQL Server we have different versions 2 onwards 2025 we have Windows servers 2000 onwards 2022 we have so every software orle virtual box is also a software so this will also have different versions guys so open the first link um R so there are different different versions of orle virtual box guys the latest version is orle virtualbox 7.1.4 but don't that one okay why because most of you are using um Windows 10 laptops so if it is uh virtual box seven means compatibility issues and all will come so we can go with the virtual box six and all okay can you see somewhere older builds will be there older builds okay go up go up previous yeah yeah click on the previous releases yeah yeah see here guys once you click down the previous releases you can see virtual box 6.1 can you see virtual work 6.1 click on that 6.1 6.1 is compatible for Windows 10 and windows 11 laptops also okay even though if you're using Windows 11 laptops again you can see virtual box there is no kind of what I can say uh support is not there but we don't need any support okay hey Sunita you started sharing the screen Sunita Sunita stop sharing the screen should I'm sharing yeah yeah yeah yeah uh let me stop stop sharing okay maybe unknowingly or she's just testing whether it is working or not okay fine click on that virtual box 6.1.5 version guys you have to select Windows host we are going to this AR box on Windows host okay so click on the Windows host that's it immediate medely it will be it will start downloading guys it don't take much time hardly 100 MB or 150 MB file so immediately it will be downloaded okay how much it is 1207 MB so7 MB file so it will be downloaded quickly guys once it's downloaded you can this virtual box guys again whatever we are discussing in this session in the whole session we are not responsible to do these things in the organization so don't worry try to concentrate so that you will get a basic idea from the basics okay don't worry at all not even a single step they won't ask you to perform this activity in the organization as we are preparing the environment the whole infrastructure we have to prepare from the scratch so we are the windows admin throughout the training we are the storage admin throughout the training we are the network admins throughout the training we are the DB admins throughout the training the most important is DB admin so to make sure the environment is available we have to do all these things so nothing to worry in the organization we don't perform any of these actions don't double click on it don't double click on it rather so remember one thing guys whenever you're opening an application as a DBA you have to keep this in mind for lifelong for lifelong you have to keep this point in the mind as a DBA if it is an application file you have to open that application file with run as administrator how to get it right click on the software you can see run as administrator option so in case if you don't have any permissions on all it will ask you you should be local administrator so in case if you don't have local administrator permission immediately it will pop you to give the administrator username and password so make sure you are logging into your laptop as an administrator 99 percentage you'll have administrator privileges so always not only here in the organizations also any application so shanuk how to know whether this is an application or not or file just file see um if you see any photo also that is a kind of a file so there is a difference between file and application just click outside once ra so you can see the third column okay type is equal to application guys so if you see the typee is equal to application any application whether it is SS SMS or any other applications always try to open with run as administrator so right click on this and open with run as administrator select and right click so that you can see so now it will pop you for yes or no hit yes so once you just clicked on yes automatically the interface will load and then installing AR box is very simple next next next and that's it so we are not going to okay uh discuss on this why because this is not our part so I don't want to create wait wait wait okay uh yeah click on yes here just click on yes yeah and that's it so this is not our part guys as we are not going to and don't think that they are waiting for you that that guy will come and he's going to the AR virtual box and all already environment will be there so no need to worry about this maybe if it is a a very new project okay then you have to build it from the scratch you in the sense the windows Team guys any Windows admins are there any Windows admins I'm sure one or two people will be there one Windows admin one orle DBA definitely in every batch okay fine fine so it will be installed immediately guys so it don't take much time it will you will get the notification like this just click okay okay don't upload it it will it will always ask you to upgrade to 7.0 and all no need to upgrade you can still use keep using the 6.1 or 6.0 okay that's it guys once you this is how you can see this is the interface this is called Oracle VM virtual box manager using this interface I can create machines I can delete machines I can start machines I can stop machines I can change the settings of the machines okay using this interface guys from today onwards okay every day once you started your laptop you have to open this orle virtual box once you machine your machine is created you can start you can just start the VM and you can start working on it guys okay clear are we good guys any questions doubts installing orle virtual box please one minute H just one minute guys right fine yes um R you can click on new there is a star symbol right new uh click on that new I'm going to create a new not add click on the new I'm going to create a new virtual machine guys so while creating of course every machine will have a name right you have to give a name give batch 57 guys naming wise you should be very careful okay don't give okay what is that uh pinky puppy I love my mommy I love my daddy okay smiley Ravi so don't give these kind of things guys always it should be professional okay so make sure like why saying you will start working on it from day one onwards otherwise see once you joined in the organization from the first minute onwards the security guard also will observe you guys for one two months it's a continuous assessment for you in the organization so including how you are giving names also they will keep an eye by just looking their names also I can tell whether a person is a or Genuine that's why please habituate to give a professional name Nam always professional names in the sense just a good name okay right batch 57 that is the machine name okay so now where we are going to store this machine this machine is going to be created into the this thank [Music] you right so so where we are going to cre virtual machine is also going to create as a file at the end of the day okay as a file only so where you are storing this file you should have proper free space so in the RAS system it is showing by default C drive but make sure you can even create in the C drive also but make sure you have enough free space in the C drive okay it is showing harishankar I don't understand people will unmute and talk or KN it will be unmuted I don't know please be unmute please be muted arank please fine thank you uh okay fine so here in the second section second field by default it will take C drive but but don't give C drive C drive is not sortable drive you can no issues but it's not a good way you have to organize the things properly okay so go to D drive or any Drive guys shanuk I don't have D drive what I have to do nothing to worry go to any Drive which is having enough free space okay so normally go to D drive offline go to D drive again open Windows plus e Windows plus e is the shortcut which will help you to open the this PC my computer go to e Drive okay open this D drive uh control+ shift+ n control+ shift+ n is the shortcut to create the new folder again I'm saying don't right click up down is not at all a good option so the others has to be like they have to ask hey what you did you haven't even selected any option by right clicking on all how you got the new folder so this is control+ shift plus n will give you a new folder guys okay yes now type batch 57 VM don't give any space just okay without space you have to keep it yeah VM very good always use the first word as caps and the main main things and all as caps only okay don't give some people will always give small letters only that's not good option okay fine now minimize this window okay good so what you can do now go to that interface uh here click on the machine folder click on the machine folder click on the down arrow choose the other click on the other go to D drive click on batch 57 select folder okay right now the files will be organized properly okay guys I'm going to create a Windows machine so type as Microsoft Windows only keep it as it is if you want to create Linux machines and all you can select that you'll have different different options L ACC Solaris IBM Mac OS you can choose any of the option but we are going to use Microsoft Windows only keep it as it is the last option okay Microsoft which version you are going to guys Windows go down you can see lot of options Windows servers also you can see here up to Windows 2019 it is showing right remember one thing guys here always you have to select any version but it should be 64bit only in the brackets you can see 64bit you can select Windows 2016 here nothing will happen the logo the icon beside that you can see a small icon right it is showing seven blue color black color and all can you see guys yes that is the one only it will create that logo guys but you can choose Windows 2016 here and you can Windows 2019 also so if you have Windows 2019 choose Windows 2019 yes Windows 2019 64bit remember guys Windows 2019 64bit sometimes click on the same drop down ra sometimes it will only show you 32 bit it won't show you 64 bit and all in the older machines in the older laptops it will show you only 32bit why it will show you 32bit what you have to do how to troubleshoot I'll tell you okay so select Windows 2019 if you don't see Windows 2019 guys nothing to worry you can choose other 20 other windows also click on that again click on that Windows 2019 again at the last you can see other windows 64bit you can choose that also if you if you are able to see Windows 2019 choose Windows 2019 if not others Windows 64bit also is fine okay now choose Windows 2019 64bit next I told you right I'm creating a virtual machine virtual machine means what what and all resources we have to allocate RAM storage correct correct CPU that's what we are doing now I'm creating a virtual machine right I mean I'm creating one more system in my laptop virtual machine is also a system I'm creating one more system virtually in my laptop okay now I have to allocate the ram initially see here he's having how much 8 GB Ram 8192 bytes 8192 bytes means 8 GB Ram okay so I'll tell you how to quickly calculate the MBS GBS TBS and all as a DBA you should have okay that logic immediately you should be able to identify the storage and all I'll tell you now see he's having 8GB his local laptop which is using Windows 11 is almost using open Task Manager once on the taskar right click on task manager see is already using 76% of memory click on that memory yes click on that yeah very good see out of 8 6 GB is already occupied guys can you see left side 6.1 by 7.9 can you see memory under memory under memory yeah so that means out of eight six is already being used by your local laptop so how much is reserved now how much is free now 2 GB so he can give GB okay he can give 2 GB right fine so select 2 GB here just minimize this here you can give 2 GB 2 GB in the sense see 1 MB is equal 1 GB is equal to 1024 MB Guys 1 GB is equal to 1024 MB so 2 GB is equal to 1024 into 2 which will be 248 MB in your machine if you're having 12 GB Ram allocate 4 GB Ram here if you're having 16 GB Ram allocate 4GB Ram here your machine will be fast as you don't have memory to allocate if you have 8 rupees and 6 rupees already you just reserved you have only 2 rupees so that two rupees you can give it to others so shanuk I having two rupees but can I give four rupees no two rupees only even if you select 4GB here nothing will happen but maximum it will use the reserved space only okay guys good are we good questions doubts sir what is the recommended uh required memory uh is for the SQL Server sir Faruk you asking two Advanced questions okay we'll be discussed sir okay we'll be discussed why because it's not a fixed okay kind of thing in the performance Shing we'll be discussed okay guys so now any questions so if we give um like 4 GB here as you told me like the only 2 GB space is here but in some case like if uh our own computer was using less memory then it will use it will use it will use yeah it will use up to 4GB it will use based on the res pleas okay okay yeah so give 248 guys as he's having 8GB he's giving 248 MB if you having more than that you can give 3 GB 372 MB if you are having 16 GB and give 4 GB 496 MB and all like that you can give guys okay go to next ah store is so you can choose uh create a virtual hard disk that was already selected the middle one so keep it as it is guys no need to change it go to create click on create once now vdi format only it will be created don't worry what is this V and all I told you right this is not our area this is not our zone so don't worry vdi is a kind of a file that is the extension of the virtual machine file. vdi so that's how it will be so no need to choose any option keep it as it is go go to next and op dynamically allocated I'm allocating a storage now in the next screen so it should be allocated dynamically we cannot give fixed storage if you don't use fixed sto if you don't use that for example 50gb allocated for this virtual machine while allocating you can either choose dynamic or fixed if you choose fixed that 50 GB will be reserved even though you're using or not using if you choose dynamically allocated if even though you allocated 50 GB how much currently 1 minute just one minute please right okay so guys uh dynamically allocated means even though you allocated 50 GB out of 50 GB how much is used if it is 10 GB then remaining 40 GB you can see as a free space in the Drive currently he is creating R is creating this virtual machine in his D drive so it will consume 50 GB of D drive if there is a free space of 50 GB in his D drive if you allocated a dynamically allocated if you choose dynamically allocated out of 50gb also if this machine is actually using 20 GB remaining 30 GB you can make use of for other things and all so dynamically allocated is good one or fixed is good one guys tell me which option is good one dynamically dynamically so it is not going to waste the storage whereas fixed whether you are using or not using it will keep holding that 50 GB until the machine is up and running okay so make sure dynamically get this selected go to next and storage how much you want you can allocate here I'm going to allocate 30 GB that will be fine guys or 35 GB you can use you can give here so here you can see that one last one 50 GB to showing right you can give 30 GB 35 GB and based on your space 50 is 50 is fine sure 50 is also fine but again we are not going to use till 50 so it will be waste okay so you can give 35 Max 35 35 give you can give 35 GB guys Okay click create that's it yeah now you created a virtual machine guys that's it this is how we will create virtual machine this will be done by the windows Team guys don't worry okay this will be done by the windows team any questions doubt so far any questions guys please don't hesitate guys you can ask in your local language also don't hesitate to ask the questions nothing are we good now can we can we multiple Windows OS in one VM if the resources are available virtual machines we can create and on top of that we can multiple operating systems yes we can create like this now we just created batch 57 right so like this you can create one more machine in that you can some other operating system Windows Server operating system you can create third machine yeah please and one single versal machine can create or multiple voice how that is possible how that is possible no that is not possible that is actually in your laptop see you can two virtual machines two operating systems guys but your laptop will be corrupted okay so it's not recommended to multiple operating systems on a virtual machine just one virtual machine one operating system if you want to one more operating system create one more virtual machine I'm asking as for the real time scenario why we will do that we don't do that M as I said we don't why because if you are installing multiple operating system on a single machine which virtual machine which operating system you will use we cannot keep on switching between the operating systems right one virtual machine one operating system that's it in the real time also we'll do in the same way one virtual machine one operating system so they don't allocate the same virtual machine to other applications why if we have to do any maintenance tasks maintenance activities if there is a chance that you have to restart this virtual machine all the applications that are running on this virtual machines will be down first of all whatever you're asking on a single virtual machine can I multiple operating systems technically it is possible but it's not recommended and even organizations also will not allow to do that first thing the short answer is no second thing is we'll have a separate separate virtual machines and sharing a single virtual machine to all the applications is not at all recommended if that machine is down all the applications also will be down so the answer is no okay mother any other questions guys um sh yes I know for um I think they have templates voice is not clear B so a little bit like yeah can you hear me now I can I can now yeah yeah I was asking that I know in um VMware they have templates where they can just um deploy the server um with Windows and SQ in there is it the same thing with correct yes we are doing yes on top of this virtual machine we'll the operating system on top of that we'll the SQL Server that's how in the organization also will do so if you if you're you're in an area where they deploy a lot of VMS is it like a tempate you just push it or you still have to be creating uh I don't know why your voice is breaking little bit in between where is my speak okay so I was asking if you if you're work in an area where you're deploying a lot of servers right correct a lot of servers yes lot of servers you have is it a template that you just push or you still have to go through process okay got it got it so are we going to do this process manually or any other uh kind of a pipeline to push all these things depends upon the organization B okay so few organizations will go for an automation so once they just hit that pipeline um automatically it will be created guys I'm working on the same project okay maybe maybe in in a month I'm going to simplify the tasks guys uh currently I don't reveal how I'm going to do that but I'm working on the same project I'll try to simplify all these tasks so hoping so I'm working on it since 2 3 months I'm working on it so lot of tasks I have to automate it but yes it will be very simple once that is finished like we can just click the whole environment with a single with just a double click okay so I'm working on that particular personally not organization project and all personally I'm working on that so yes B so it depends upon the organization to organization some people will do the same thing by just okay triggering A a pipeline or an automation kind of thing some people will do the same steps manually they will create uh machines manually like we just did right in the same way they are going to created it so if if you you work in an area where every day they asking you to create a BM right corre I'm asking if in in Virtual in this Oracle virtual box is there a SQL template where no no no no no no no there will be no SQL template at all no this is not like a aure this is on promises right you have to add the operating system you have to add the SQL software and and then you have to so it's not like a bunch of package that you are going to get it okay with the operating system and all you don't get any SQL template you have to attach the SQL software and you have to it manually yeah once you've everything manually can you convert that V to a template uh can you I'm not getting can you when you've installed everything windows and if you put SQL in there can you now convert that VM into a template so you are asking for a template template for creating the virtual machine and SQL Server no no I'm asking you um sh once you've deployed this VM right cor you you Windows right and you um SQL on it correct can you now convert that that VM into a template where request I just yes got it you asking the mirror copy so that the template can be used multiple times the whenever we need a same kind of configuration you are asking exactly like a cloning of the existing machine correct exactly yes yes so that's generally you can do that but lot of challenges will be there be okay I tried doing that the configurations and all will be different from one machine to one machine but if this is a normal template and all yes you can make use of see one time you can create create this machine next time no need to create it next time no need to it manually so you can use the template yes you can do that okay but organization we don't follow such kind of practices because lot of challenges will be there see once we started using the template we don't know where is the issue exactly so it might take lot of time to troubleshoot instead of that creating virtual machine installing the operating system itself is very easy okay but yes there is an option to create this as a template and you can make use of this template anytime anywhere any other questions guys thank you yeah thank you thank you so this virtual machine is same like Citrix or VW no so like any people can log in and work on that yes any people any people can log in and they can work on it how they are going to log in I'll explain the um loging process and all guys okay okay questions guys questions doubts are we good so far please don't worry yes yes if you need to work on multiple servers uh you know single Windows some uh as a DBA we need to work on multiple servers multi one single on one virtual machine we can [Music] guys is his voice breaking Madu your voice is totally breaking Madu one yeah one VM we can One windows voice right correct one VM one window window correct uh on on one windows we canall multiple SQL servers yes multiple SQL servers we can yes yeah yes we can do that we can do that sometimes they yeah sometimes it's Windows OS and SQL servers is not compartible that mean 7 is gold uh then at the time what we need to one more in O and of of course very simple which one is compatible one you have to use that one for example like you want to SQL 2012 you have Windows Server 2022 so difficult to SQL 20121 2022 so on which versions We can SQL 2012 maybe I can on Windows Server 2012 Windows Server 2016 so create one more virtual machine another operating system and you can SQL 2012 on that particular virtual machine yeah okay guys shuk actually in this course are we going to learn about the queries also like um complex queries joints functions no no no no as discussed in the first class we are not going to deal with the okay SQL programming so we are not going to discuss any of the functions triggers to procedures use and all completely muted yeah okay guys any other questions Good Guys people are asking questions lot of questions okay nice any other questions guys some just one more thing U so when you will explain that fine tuning so that time you will explain that predicates like everything that index and what huh index yes indexing and will there lot of things we are going to discuss okay no like when you will explaining that Performance Tuning so that time you will explain some bad query as well like just no no no intermediate level performance Shing we'll discuss okay intermediate level performance Shing in the sense uh we'll discuss see intermediate level in the sense up to 78 years what and all performance issues will get it how to troubleshoot those things will be discussed but again lot of things are there I as discussed like performance shooing side will discuss about the execution plan we'll discuss about the indexes we'll discuss about the statistics and we also discussed about that particular what I can say um the the configurations server level configurations cost to parallelism Max degree of parallelism how they are going to work index fi Factor okay so all these things the best configurations and the responsible settings to tune the query all those things will be discussed guys okay SQL profiler as well right yes yes yes that also yes sh what about CDC CDC no tabasum CDC we don't touch no okay yeah we don't touch okay okay okay yeah okay guys fine so now what we can do take a break come back after 10 minutes uh let's go with the 15 minutes come back after 15 minutes uh we'll start installing the operating system okay and then uh we will continue guys today this session will the operating system let's see based on the time we'll set up the remote connections also and I'll show you how to connect to the server remotely based on the time okay I will be back after 15 minutes guys okay sure right okay so I'm going to create the virtual machine again guys okay so new for me little difference will be there I'm using older version so that's why you can see different different options like this but the fin options that you have to choose the same there will be no difference and all just interface will be kind of a little difference will be there okay so I'm creating bat 57 so here what I'll do guys I'm going to check in which drive I have enough free space right in the D drive 53 and the e Drive 50 so I'm going to use D drive guys so I can simply double click on it I can create a new folder control shift n badge 57 VMS okay bad 57 VM anything is fine okay so now go back to this click on this choose other and choose D drive and batch 57 batch 57 57 57 BMS okay where is that batch 57 match 57 VM select this folder and Microsoft Windows only I'm going to choose I don't see any 2019 2016 only up to 2016 only I can see so I'll choose other windows 64bit next I'll allocate um 3 GB of RAM 372 guys in case if you don't know okay how to calculate the RAM and all okay so listen carefully guys it's very important so how many bits is equal to one byte guys how many bits is equal to one bite can anyone tell me eight bits yes sir very good 8 Bits is equal to 1 byte guys okay and next how many bytes is equal to 1 kilobyte 1,24 1,24 bytes is equal to 1 kilobyte KB 1,24 kilobytes is equal to 1 M megabyte 1024 megabytes is equal to 1 1 GB GB 1024 gabes is equal to 1 te