SQLBits 2019

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.

"Wait, what? Biml is not just for generating SSIS packages?"

Absolutely not! Come and see how you can use Biml (Business Intelligence Markup Language) to save time and speed up other Data Warehouse development tasks. You can generate complex T-SQL statements with Biml instead of using dynamic SQL, create test data, and even populate static dimensions.

Don't Repeat Yourself, start automating those boring, manual tasks today!

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.