Steve Powell
azuredatafool.net
Steve has been working with SQL server for longer than he likes to admit. He works as a BI trouble shooter for a Law firm no one has ever heard of. He's an MCSA and speaks now and again at SQL user groups.
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.