Finding By Self

Udemy course "Hands-On : Azure SQL Database Training for IT Architect" has been released.

https://www.udemy.com/course/hands-on-azure-sql-database-training-for-it-architect/

Table of contents:

Section1. Introduction

1. What is Azure SQL Database?

2. Preparation for using Microsoft Azure

3. Learning contents of the course

4. Service tiers and Availability models

Section2. A. Performance and Scalability

5. Scale-up and Read scale-out

6. Elastic pool

7. Elastic query

Section3. B. Redundancy and Fault-tolerance

8. High Availability and Disaster Recovery

9. Backup and Restore

10. Export and Import

Section4. C. Security

11. SQL authentication

12. Azure AD authentication

13. Managed Identity authentication

14. Public network access

15. Service endpoint access

16. Private endpoint access

17. Always Encrypted

18. Dynamic Data Masking

19. Ledger

20. Auditing

Section5. D. Portability and Deployment

21. Deployment with ARM Template

22. Deployment with Azure DevOps

23. Parameterization on DevOps pipeline using Azure Key Vault

Section6. E. Monitoring and Troubleshooting

24. Metrics and Dashboard

25. Alerts

26. Dynamic Management Views (DMV)

27. Extended Events

 

Sample lecture

23. Parameterization on DevOps pipeline using Azure Key Vault

In this demo, Azure DevOps pipeline's variable group and Key vault to mask login name and password in ARM template json files.

Sample codes used in the lecture

# Please input the commands to "Arguments".

-sqladmLogin "$(sqladmLogin)" -sqladmLoginPwd "$(sqladmLoginPwd)" -aadadmLogin "$(aadadmLogin)" -aadadmLoginSid "$(aadadmLoginSid)"

 

# Please input the commands to "Inline Script".

Param(

[string]$sqladmLogin,

[string]$sqladmLoginPwd,

[string]$aadadmLogin,

[string]$aadadmLoginSid

)

Write-Host "##vso[task.setvariable variable=sqladmLogin]$sqladmLogin"

Write-Host "##vso[task.setvariable variable=sqladmLoginPwd]$sqladmLoginPwd"

Write-Host "##vso[task.setvariable variable=aadadmLogin]$aadadmLogin"

Write-Host "##vso[task.setvariable variable=aadadmLoginSid]$aadadmLoginSid"

 

# Please input the commands to "Override template parameters".

-administratorLogin $(sqladmLogin) -administratorLoginPassword $(sqladmLoginPwd) -administrators {"login": "$(aadadmLogin)", "sid": "$(aadadmLoginSid)"}