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 »
3. 9, 53, 56. DTU-based purchasing model, Server vs Serverless So if that is the Vcobased purchasing model, what is the DTU based purchasing model? Well, DTU are little units. They’re called database transaction units. And they are packages of maximum number of compute, memory and input output or read and write resources for each… Read More »
DP-300 Microsoft Azure Database – Configure Azure SQL Database resource for scale and performance
1. 9. configure Azure SQL Database for scale and performance In this section we’ll be looking at how to configure Azure SQL database for scale and performance. So let’s go to Azure SQL and we create a new SQL database. So there are three different types. Single database. So this is obviously a single database.… Read More »
DP-300 Microsoft Azure Database – Identify performance-related issues Part 2
3. 49. identify sessions that cause blocking In this video, we’re going to have a look at blocking. What is blocking? Well, here we have an update statement. So it’s going to update this table. So where the city is equal to Toronto, it’s then going to say, well, make the city equal to Toronto… Read More »
DP-300 Microsoft Azure Database – Identify performance-related issues
1. 48, 60. Query Store – an introduction Hello. And in this section we’re going to be identifying performance related issues. First of all we’re going to be using the Query Store to help us. What is the Query Store? Well, it contains three different stores. A plan store for executing plan data, a runtime… Read More »
26. Azure Databricks – Sending logs to Azure Monitor In this chapter, I am going to give just a quick note on sending the application logs from Azure Databricks onto Azure Monitor. I’m also going to include this link as a resource on to this chapter. So this link actually gives you the way in… Read More »
24. Azure Stream Analytics – Diagnostics setting And welcome back. Now in this chapter I just want to go through the diagnostic settings that is available for your Azure Stream antics job. So even earlier on we had seen that we could actually direct the logs the pipeline runs when it came on to Azure… Read More »
22. Azure Stream Analytics – More on partitions Now in this chapter, I just want to go through some more notes when it comes to your partitions in Azure Steam Attics. So when it comes to your Stream antics job, there is something known as a compatibility level. Now, by default, the compatibility level at… Read More »
