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!