Category Archives: Uncategorized
DP-300 Microsoft Azure Database – Optimize Query Performance
1. 69. validate data types defined for columns Hello. Now we’ve got that review of the select statement out of the way. We’re going to look in this section about how to optimize query performance. So part of that is about normalizing tables. We’ll have a look at that in the next three videos and… Read More »
DP-300 Microsoft Azure Database – Review prerequisites Part 2
3. Installing SSMS, connecting to Azure SQL Database, and quick look around SSMS In this video we’re going to connect to our SQL database that we installed in the previous video. So we can do this in the Portal, the Azure Portal, by going to the SQL database and going to Query Editor. So it’s… Read More »
DP-300 Microsoft Azure Database – Review prerequisites
1. Getting a free trial of Microsoft Azure So now let’s get our free account. And you can see an ad at the top, azure Microsoft. com account, free. You could just google Azure Free credit and see what you get as well. So let’s click on that and you can see we have a… Read More »
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 »
