SQLBits 2023

7 Things I wish I'd known before building a 60Tb DWH on a Dedicated Pool

Lots of ADF, lots of data, lots of automation and lots of lessons learned. Backups aren't as useful as they look, dedicated pools have several "interesting" features in the small print, ADF is not always your friend and how to mitigate the sometimes deadly embrace of throughput vs concurrency trade off.
Moving an on premise 60Tb Kimball DWH into Azure while it's still moving. Real life issues and patterns, some that work, others to avoid.