DP-300 Microsoft Azure Database – Monitor activity and performance Part 2

3. 77. create event notifications for Azure resources So now you’ve got this operational baseline. How can you be notified when things change? Well, we can create an alert. So let’s say we have got this data space used and I wanted to create an alert from that. Well, I can go in metrics to… Read More »

DP-300 Microsoft Azure Database – Monitor activity and performance

1. 38. prepare an operational performance baseline – Metrics Explorer Hello. And in this section we’re going to be monitoring activity and performance and we’re going to start with preparing an operational performance baseline. So one way we can do this is using metrics. Metrics are numerical values that are collected at regular intervals and… Read More »

DP-300 Microsoft Azure Database – Implement compliance controls for sensitive data Part 2

4. 36. implement data change tracking – Change Data Capture In the previous video, we implemented data change tracking CT. However, that didn’t tell us what a particular item went from or to. If we want that, then we’ll have to use a different technology called Change Data Capture CDC. However, I cannot do it… Read More »

DP-300 Microsoft Azure Database – Implement compliance controls for sensitive data

1. 34. apply a data classification strategy Now is some of your data sensitive, but people might still need to be able to see it. So sensitive data includes data privacy, regulatory and national requirements. So we’ve talked extensively about GDPR and the California version. And maybe there are security scenarios including controlling access. So… Read More »

DP-300 Microsoft Azure Database – Implement security for data at rest and in transit Part 2

4. Always Encrypted versus Transparent Data Encryption In this video, we’re going to compare and contrast. Always encrypted and transpound data encryption, or TDE. What’s the difference between them? Well, TDE is an older technology, so you can see it was first around in SQL Server 2008, whereas Always Encrypted started in 2016. Now, you… Read More »

DP-300 Microsoft Azure Database – Implement security for data at rest and in transit

1. 28. implement Transparent Data Encryption (TDE) Hello. And in this section we’re going to look at how we can implement security for data at rest and in transit. In other words, on the move. So we’re going to start with transparent Data encryption or TDE, TDE encrypts and then Denry data at the page… Read More »

DP-300 Microsoft Azure Database – Plan and Implement Data Platform Resources Part 2

4. 6, 8. evaluate scalability and security aspects In this video, we’re going to start by looking at the scalability of the various database offerings. So first of all, as your SQL Database, it really depends on what version you go for. So it starts off at around the 1 TB level. So we’ve got… Read More »

DP-300 Microsoft Azure Database – Plan and Implement Data Platform Resources

1. 1. deploy database offerings on selected platforms Hello. And in this section we’re going to have a look at planning and implementing data platform resources. And we’re going to start with using manual methods. So we’ve already got our first SQL Database. So what happened? I went to Azure SQL and I can go… Read More »

DP-300 Microsoft Azure Database – Optimize Query Performance Part 3

5. 58. determine the appropriate type of execution plan Now in this video we’re going to go a bit behind the scenes and have a look at execution plans. So what I’ve got here is a crossjoin. So I’m joining this table to itself. So if this table is giving me 450 rows then joining… Read More »

DP-300 Microsoft Azure Database – Optimize Query Performance Part 2

3. 67. identify normal form of database tables – Normal Forms 1 to 3 In the previous video we had a not optimal table structure and we’re going to use the first normal form to get it into better shape. But what is the first normal form? Well, the first normal form was proposed by… Read More »