I had the great honor of speaking twice at Microsoft Ignite 2018 on the topic of Azure SQL DW. The first session was a fun one about some war stories from the trenches with Azure SQL DW. I wanted to post the YouTube video and slides download for the session for all my blog readers.
Having implemented Azure SQL Data Warehouse solutions for dozens of clients, here are the lessons learned we wish we had known several years ago. Learn a great way to make your loads run twice as long. Learn the best ways to make columnstores perform as slowly as molasses in January. Take a visit to the distribution key hall of shame. We review some common mistakes, understand what’s happening under the covers, then show the best practice to fix the problem.