You have probably heard about the Accidental DBA, but what about the Accidental ETL developer? We stumbled into the world of data warehousing, learned dimensional modeling and work with T-SQL and SSIS daily. We are masters of googling solutions to our problems and make sure our ETL processes run without errors. We deliver data to business users... but we rarely deliver data as fast as we want.
You might not be able to rewrite your entire Data Warehouse or change your team's processes over night, but there are many things you can do to increase your own productivity and become a more efficient Data Warehouse developer.
In this session I will show you some of what I have learned and discovered that has made me exclaim "Oh wow! Why did I not know this yesterday!?" - including SSMS features, tools for query analysis and tuning, free tools and scripts, Biml for SSIS and even a couple of things I used to think were only useful for those scary DBAs.
Cathrine is a technical architect and developer, focusing on data warehousing and business intelligence. She mainly works with ETL, SSIS, Biml and T-SQL development, enjoys both programming and data visualization, and loves to learn and share knowledge. Outside of work she is active in the PASS, Biml and SQL Server communities as a Microsoft Data Platform MVP, BimlHero Certified Expert, speaker, blogger, volunteer, board member of Microsoft Data Platform User Group Norway and main organizer of SQLSaturday Oslo.