SQLBits 2015

Tools and Tips: From accidental to efficient DWH developer

As data warehouse developers we deliver data to business users... but we don't deliver data as fast as we want. There are many things you can do to increase your own productivity and become a more efficient data warehouse developer.

You have probably heard about the Accidental DBA, but what about the Accidental Data Warehouse developer? We stumbled into the world of data warehousing, learned dimensional modeling and work with T-SQL and SSIS daily. We're masters of googling solutions to our problems and make sure our complex ETL processes run without errors. We deliver data to business users... but we don't 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've learned and discovered that has made me burst out "Oh wow! Why did I not know this yesterday!?" including query improvements, free tools and scripts, SSMS features and even a couple of things I used to think were only useful for those scary DBAs.

Cathrine Wilhelmsen's previous sessions

Website Analytics in My Pocket Using Microsoft Fabric

Join this session to see how easy it is to create a pocket-sized dashboard for your website analytics. First, learn how to automatically collect statistics from an API and store it in a central location. Then, see how quickly you can visualize the data in a mobile-friendly way using Power BI. 📈

Choosing between Microsoft Fabric, Azure Synapse Analytics and Azure Data Factory

Learn the pros and cons of Microsoft Fabric, Azure Synapse Analytics and Azure Data Factory, and how to choose the right Data Integration solution for your project.

"I can't keep up!" - Turning Discomfort into Personal Growth in a Fast-Paced World

Are you struggling to keep up with all the latest product changes and new technologies? Awesome! That means you have ambitions. You can do anything if you set your mind to it. It just might not be easy. Are you ready to turn your "I can't keep up" into "I can't believe I did all of that in just one year"?

Stressed, Depressed, or Burned Out? The Warning Signs You Shouldn't Ignore

Stress barges through your door and yells "hey, it's me!", while depression and burnout silently sneak in and gradually make adjustments until one day you turn around and realize that you no longer recognize your house. What are the warning signs you need to be aware of in yourself or your loved ones?

6 Tips for Building Confidence as a Public Speaker

In this session, I share the top tips I have learned over the years. All it takes is a little preparation and practice.

Lessons Learned: Implementing Azure Synapse Analytics in a Rapidly-Changing Startup

What happens when you mix one rapidly-changing startup, one data analyst, one data engineer, and one hypothesis that Azure Synapse Analytics could be the right tool of choice?

Biml Tips and Tricks: Not just for SSIS packages!

Biml is not just for generating SSIS packages! Come and see how you can use Biml to save time and speed up other Data Warehouse development tasks like T-SQL development, test data creation, and dimension population.

Level Up Your Biml: Best Practices and Coding Techniques

Attend this session for an overview of Biml best practices and coding techniques. Learn how to centralize and reuse code, simplify logic, and create your own C# classes and methods. Improve your code and level up your Biml in no time!

Tools and Tips: From accidental to efficient DWH developer

As data warehouse developers we deliver data to business users... but we don't deliver data as fast as we want. There are many things you can do to increase your own productivity and become a more efficient data warehouse developer.