Categories: EventsSSIS

Session Materials – Biml DataMinds

All of the materials for my Biml session for DataMinds.be can be downloaded from Github:
  • the slidedeck (it’s only 12MB :))
  • a .sql file with the DDL statements to create objects (schema, tables, views, stored procs, functions) in a database called Biml (which you have to create yourself). Along with some metadata in those tables.
  • a .zip file with an Integration Services project. It contains all the Biml files used in the demos.

The demos use the AdventureWorks2017 and AdventureWorksDW2017 databases, as well as the StackOverflow database (that’s quite a big one though). They also read data from Master Data Services databases (conveniently called MDS and MDS2017). In MDS, the sample models are installed.

If you have any questions, drop a comment below.


------------------------------------------------
Do you like this blog post? You can thank me by buying me a beer 🙂
Koen Verbeeck

Koen Verbeeck is a Microsoft Business Intelligence consultant at AE, helping clients to get insight in their data. Koen has a comprehensive knowledge of the SQL Server BI stack, with a particular love for Integration Services. He's also a speaker at various conferences.

Recent Posts

Cool Stuff in Snowflake – Part 14: Asynchronous Execution of SQL Statements

I’m doing a little series on some of the nice features/capabilities in Snowflake (the cloud data warehouse).…

2 weeks ago

How I passed the DP-700 Exam

I recently took and passed the DP-700 exam, which is required for the Microsoft Certified:…

4 weeks ago

Take over Ownership in Microsoft Fabric

When you create an item in Microsoft Fabric (a notebook, a lakehouse, a warehouse, a…

2 months ago

Book Review – Agile Data Warehouse Design

I recently read the book Agile Data Warehouse Design - Collaborative Dimensional Modeling, from Whiteboard…

3 months ago

Cloudbrew 2024 – Slides

You can find the slides for the session Building the €100 data warehouse with the…

4 months ago

Book Review – Microsoft Power BI Performance Best Practices

I was asked to do a review of the book Microsoft Power BI Performance Best…

4 months ago