Microsoft Database Administrator (1)

In this series, we're going to go through all essential concepts of being a Microsoft Certified Azure Database Administrator.

Sizing elastic pool:

1. Total size

2. Peak DB x Peak CPU

3. DB x avg(CPU)

Restore SSIS:

1. Attach

2. CLR

3. Open master key

4. Copy encrypt

Table compression:

• Columnstore archival compression

MSSQL -> Azure:

✓ DB Migration Service

✓ Full & Log backup with CHECKSUM

✖ PolyBase

Data Lake -> external data source:

1. dfs

2. TYPE=HADOOP

Databricks -> hourly store:

1. .partitionBy

2. "{varyID}", "Y", "M", "D", "Hour"

3. .parquet("/{dataset}")

Partition count change:

• Dedicated event hubs

Thank you for your reading!

See you in Microsoft Database Administrator (2).

© 2023 Harmony Pang. All rights reserved.