7 Things I Wish I'd Known Before Building a 60TB Data Warehouse on a Dedicated Pool

7 Things I Wish I'd Known Before Building a 60TB Data Warehouse on a Dedicated Pool

SQLBits via YouTube Direct link

Concurrency (use params in ADF)

17 of 20

17 of 20

Concurrency (use params in ADF)

Class Central Classrooms beta

YouTube videos curated by Class Central.

Classroom Contents

7 Things I Wish I'd Known Before Building a 60TB Data Warehouse on a Dedicated Pool

Automatically move to the next video in the Classroom when playback concludes

  1. 1 What to expect
  2. 2 Project background
  3. 3 Azure Solution
  4. 4 ELT Framework
  5. 5 Don't move the ETL
  6. 6 Pause/Resume / Scale
  7. 7 Backup/Restore (granular)
  8. 8 Fun with HEAPS
  9. 9 Rebuild your HEAPS
  10. 10 Retry is unavoidable
  11. 11 Retry cos of random errors like these
  12. 12 04: Random flakiness is inherent
  13. 13 05: Idempotent (in Azure Data Factory...)
  14. 14 05: ADF Singleton Pattern
  15. 15 Concurrency is almost everything
  16. 16 Concurrency (one size fits all is bad)
  17. 17 Concurrency (use params in ADF)
  18. 18 Index and Stats Maintenance
  19. 19 Netezza has hidden columns
  20. 20 XX:And the rest

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.