Monthly Archives: July 2023
DP-300 Microsoft Azure Database – Evaluate a strategy for migrating to Azure
1. 15, 16. evaluate requirements and strategies for the migration In this video, we’re going to evaluate requirements for migration of data onto Azure. And we’re going to evaluate offline and online migration strategies. So the requirements you have to look at what workloads you intend to migrate, the actual resource requirements, in other words,… Read More »
DP-300 Microsoft Azure Database – Evaluate performance improvements Part 3
4. 64. recommend query construct modifications based on resource usage In a previous video, we ran this query. So we created the sales order detail copy and sales order header copy tables. But the important thing about these is that they’ve got no indexes whatsoever. So I created this query and run it and you… Read More »
DP-300 Microsoft Azure Database – Evaluate performance improvements Part 2
2. 61. DMVs which gather query performance information In this video we’re going to have a look at how we can use DMVs dynamic management views to gather queer performance information and performance issues generally. So you can see on the screen a variety of DMVs. So what are DMVs? Well, dynamic management views are… Read More »
DP-300 Microsoft Azure Database – Evaluate performance improvements
1. 63, 68. identify and implement index changes for queries In this video we’re going to have a look at identifying and implementing index changes for queries together with assessing index design for performance. So we’ve had a look at what indexes are in previous videos. So they stop us from having to go through… Read More »
5. 25, 113. configure security principals – individual permissions In the previous video we had a look at Grant Revoke and deny for individual permissions but what are these individual permissions that you can use? Well, let’s have a look. So let’s just break this down. We have got authorization permission on securable name to… Read More »
3. 25, 113. configure security principals – roles In the previous video, we solved the authentication problem of adding Susan to my database. But now I can’t see any tables. Well, maybe it’s just a mistake. Maybe it’s just graphically not there. So I’ll rightandclick on here and go to new query. So this is… Read More »
1. 23. configure Azure AD authentication Hello. And in this section, we’re going to start looking at how we can implement a secure environment. Now, as I said before, this course DP 300 requirements don’t go into a huge amount of detail as to the Azure security that you might need. It just has limited… Read More »
9. 14. set up SQL Data Sync In this video we’re going to see how we can set up SQL data Sync. Sync. Short for Synchronization. So let’s suppose that we’ve got these three databases. So it could be that we have a couple of databases which are Azure SQL database and a number database… Read More »
8. 72. evaluate the use of compression for tables and indexes In this video, we’re going to have a look at compressing, data tables and indexes. Now, first of all, why should you compress? Well, you get reduced to space, so that’s useful for data which is infrequently used. The downside is, however, it takes… Read More »
5. 9, 53, 56. Other Azure SQL Database configuration settings In this video, we’re going to have a look at the other tabs in the Create and Azure SQL Database. So, first of all, we have got networking. So we’ve got two different parts of this Firewall rules. First of all, do you want to… Read More »