Topic: Performance Tuning Your ETL Processes
Session Description: When dealing with Integration Services (SSIS) and SQL Server you have four resources: CPU, Memory, I/O and Network. Learning how to maximize those resources takes time and experimentation. Lucky for you, I've put in years trying multiple strategies for getting the most out of my instances. In this session, I'll share tuning techniques you'll be able to apply the very next day!
Speaker Bio: For over 15 years Shannon Lowder has been spotting patterns and learning ways to work smarter instead of harder. He started with development and moved into database administration. Using T-SQL, Database Jobs and PowerShell, he automated himself out of contracts quickly. As Business Intelligence became a greater demand, he moved into SSIS, SSRS, and SSAS development. Early on, he tried using PowerShell and .Net to automate BI Development. Later those efforts turned to Biml. After founding a startup six years ago, he finds himself a data platform consultant, designing and guiding other professionals to build highly automated enterprise solutions. Today, he is a Biml Hero, one of eight data professionals certified to automate your data warehouse development using Business Intelligence Markup Language.
Meeting Location: Microsoft Office, 8055 Microsoft Way, Charlotte, NC 28273. We're in the Multipurpose Room (MPR) in the left building - the 2nd door, farthest from the entrance.