25, 112, 114. configure security principals (MIs and VMs) Now in addition to database roles on the Mi and VM we’ve also got logins and server roles. So let’s just have a look at the fixed server roles that are there. So we have Sysadmin so that’s any activity so be very careful giving people sysadmin Server admin you can change server wide configuration options including shutting down the server security admin. This is another one you need to be aware of just like the DB security admin appear in…

24, 112. create users from Azure AD identities (MIs and VMs) In this video we’re going to look at how we can create users from Azure Active Directories from this perspective of the managed instance and the virtual machine. So first of all, we can create users using create user name of user from external provider. We’ve had a look at that in Azure SQL database. Now we can create a user not from Azure Active Directory identity as follows. You can say create login name of login with a…

17, 18. evaluate requirements and strategies for the upgrade Hello and in this section we’re going to be talking about an upgrade strategy for moving to Azure. So what do we mean by upgrade? Well, it’s possible that you’re on SQL Server 2012 and you want to go to a virtual machine with SQL Server 2019, so that would be an upgrade. Now, we’ve previously got this virtual machine that you can see here and this is running SQL Server Server 2019 and you can tell that from the server…

94. configure replication – Active Geo-replication In this video, we’re going to configure replication. And I’m going to go to my SQL database here. And on the left hand side we’ve got on the data management Replicas. Now, this keeps moving. It was in the settings, for instance, in 2020, and then it was called Geo replication early in 2021. Now. It’s called replicas. So you can see no Replicas found and indeed read. What we’re seeing here is quite different to what was there in 2020. So this bit…

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…