Steve has been working with SQL server for longer than he likes to admit and developing code for longer still. He works as a Data Engineer for a telecoms company, which is far more exciting than it should be. He spends far too much time wrestling with CSV files and cursing developers who think documentation is something that happens to other people, but its the only way he can fund his ongoing Lego addiction.
Steve Powell's Sessions
7 Things I wish I'd known before building a 60Tb DWH on a Dedicated PoolSQLBits 2023
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.