Creating Virtual Machines for Failover Cluster and Always On Availability Group In this video, we’re going to create three virtual machines that we need to use. One for the domain controller and two which contain SQL Server. So I’m going to start off with going to virtual machines and create a virtual machine. This is for the domain controller, and this image that we’re going to be using is just going to be a standard Windows Server. So here we have a Windows Server 2019 data center, for instance. So…

94. configure replication – Transactional replication Hello. And in this section we are going to return to HADR high availability disaster recovery. But we’re moving away from just the ones that are done in Azure and looking at HADR in the sense of hybrid deployments as well as Azure. I’m going to start off with replication and how to configure transactional replication. So you can push changes made in an Azure Mi or in a virtual machine to a SQL Server database on premises, or on an Azure virtual machine,…

108, 110. database (and transaction log) backups with options in T-SQL code In this video we’re going to see how we can perform the data backups with options in TSQL. So in the previous video we generated this so backup database, name of database to a location with and then lots of options separated by commas. So let’s see what options we got available. So we start off with backup database and the name of the database base. We may also have file group names. So useful as I said…

81. automate backups Hello. And in this section we’re going to talk about backups. And this is largely concentrating on virtual machines because backups for Azure, SQL Database and Managed instance, they’re automatically done. You don’t need to worry about backups for VMs, you do. Now you can create automated backups if you want. And this is done through the installation of the SQL Server IAS Agent extension to enable automated backups. So this can also be done through the Creative Virtual machine process. So you need a minimum of…

101. evaluate database health using DMVs – overall resource usage Hello. And in this section we will be performing administration by using TSQL. And we’re going to be starting with evaluating your database health by using DMVs. So a couple of these we’ve already had a look at. We’ve had a look at Sysdmdb resource stats. So this returns CPU I O and memory consumption for an Azure SQL database or Azure SQL managed instance. Now, there is one raw for every 15 seconds or so, even if there is…

Logging into SQL Server on Azure Virtual Machines So in this video, we’re going to log into our virtual machine with SQL Server. So you can see deployment was completed, took around 1214 minutes. So I’m going to go to the results and here it is. And you can see I can stop it, I can restart it and I can connect to it. Why would you want to stop the virtual machine? Well, in reality that’s more like deallocate. So what happens is you don’t actually pay for the…

11, 53, 56. configure SQL Server in Azure VMs for scale and performance – Part 1 In this video, we’re going to start configuring SQL Server in Azure Virtual Machines. So let’s go to Azure SQL and click Create. And on the right hand side we have got SQL Virtual Machines and you can see that there are a lot of different images that we can use. So you can go all the way back to 2008 R Two if you so wished. You’ve also got the choice of Windows…

More about Azure SQL Managed Instance So while we’re waiting for it to be deployed, just a few more things about Azure managed instance. It has a few features which are not available in Azure SQL Database, so they include cross database queries. So you notice I wasn’t able to refer to the Master database when I was in the DP 300 database, where you can in Azure managed instance, you’ve got Clr common language runtime. So this is the execution environment for net framework code. So you could be…

4-8. Evaluating MIs and VMs based on specific requirements Hello. And in this part of the course, we’ll be moving away from what you can do in Azure SQL Database and going towards looking at what you can do in Azure SQL managed instance and SQL Server on Azure Virtual Machines. Now, before we install an SQL managed instance in a virtual machine and look at how we can use the configuration for scale and performance affords you, is probably at this stage a good reminder of the differences between…

76, 79. create event notifications based on metrics Hello. And in this section we’re going to evaluate and implement an alert and notification strategy. So we’re going to start on a virtual machine and we’re going to go into SQL Server Agent. So if I just open it, you can see that we’ve got a section for Alerts. Now. This isn’t for Azure SQL Database because you don’t have SQL Server. Agent. And this isn’t for the managed instance either, because you don’t have that section of alerts. So what…