Uncategorized

84. recommend HADR strategy based on RPO/RTO requirements Hello. Now, we’ve had a look in the previous section about restoring and that’s part of disaster recovery. What happens if a major problem happens? Well, in this section we’re going to continue looking at high availability and disaster recovery. And in this video we’re going to have a look at how we can recommend a high availability disaster recovery. So ha d strategy. So let’s have a look at the SLA. So these are service level agreements. So this is what…

98. configure quorum options for a Windows Server Failover Cluster In this video we’re going to talk about quorum options. Now, always on availability groups and failover cluster instances, rely on the underlying Windows Server Failover Clustering Service. And you might see that with an acronym WSFC. It monitors the network connections and the health of the nodes. So we have got these nodes, these clustered servers, and I’ve got a two nod cluster. Now this will function quite happily. If both of these are up, fine. If one is…

100. Configure failover cluster instances on Azure VMs Now in this video we’re going to install Failover Clustering. So we need to install a Windows Failover Cluster role and we do that in Server Manager by going to manage Add Roles and features again. So just skip down to the Features section. And here we have failover clustering. So click Add Feature Features and Next and install. And we’re also going to do that on the SQL Server number Two. So exactly, same thing, manage Add roles and features next…

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…