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…

3, 82. apply patches and updates for hybrid and IaaS deployment In this video we’re going to have a look at how to apply patches and updates for hybrid and IAS deployment and also automate performance, tuning and patching. So IAS. IAS means VM. So the hosted infrastructure SQL Database and managed instance that’s pass Pas, they have builtin patching and they always use the latest stable database engine version. However, IAS we have got a Windows or Linux background as the operating system and of course operating systems need…

Full, differential and transaction log backups In this video, we’re going to look at how we can perform a database restore to a point in time. And actually this is very easy for Azure SQL database. You don’t have to worry about the backups. Backups are done automatically a full backup, and this is by the way, the same in Azure SQL managed instance. A full backup is done every single week. So that is a backup of absolutely see everything. A differential backup is done every twelve to 24…

46. What is Elastic Job Agent? Hello. And in this section we’re going to be talking about automating tasks, including backup and restore. So first of all, automating database maintenance tasks. So you could have a lot of databases all over the place. So we’ve got two servers here, some of which are Azure SQL Database single databases and some which are in a pool. Now it might might be that we need to do exactly the same thing to all of them. So it could be backups, though that…

Describe Dataverse solutions Hello and welcome to this section all about Solutions. So you can see that I’m in the PowerApps portal, make powerapps. com and I can go to solutions by going to the bottom left hand corner and going to solutions. I can also do this in Power automate. So what are solutions? Well, solutions enable you to transport apps and components from one environment to another. They contain things like sitemaps tables, processes, web resources, flaws and more. Now there are two types of solutions unmanaged solutions…

56. Share flows In this video we’re going to look at how we can share flaws. And it’s a bit more complicated than it might first appear. So let’s have a look at this Twitter language count. Suppose I wanted to share it, or the obvious place is to go to the share icon just here. So let’s do that. Or you can click on the dot dot and go to share here. So that gets you to this screen. So you can add people as owners. Now, you must…

49. Configure triggers Hello. And in this section we’re just going to take a step back from designing detailed flaws and we’re going to have a look instead at the individual components that you can use. So we’re going to have a look at triggers, actions and expressions when you need to manipulate variables, for instance. So hopefully after this section you will have a few additional ideas of flaws that you can create in Power Automate. So in this video we’ll be looking at triggers and I hope you’ll…