Archives

My Wife and I are Presenting at SQL Saturday Dallas on June 1st!

It might surprise some of you that my lovely wife Melissa is an ETL developer as well, and she’ll be giving her first presentation at SQL Saturday Dallas.

My Better Half

She will be giving the following presentation, while I act as her lovely assistant.

The True Story of Learning Biml

How do you learn Biml when you don’t have years of SQL experience? Is Biml even worth my time and energy when I’m still working on perfecting my SSIS skills? It seems like a lot of work, what is in it for me? In this session you will learn:

  • Why Biml is worth your time and effort.
  • How to identify ideal SSIS packages for conversion.
  • How to convert those packages into Biml.
  • How to troubleshoot your Biml build errors when Google fails you.
  • How to automate SSIS package creation with BimlScript.

Download Presentation Files

I can’t let her have all the fun, so I’m presenting an updated version of the following:

Azure Data Factory V2 and SSIS Automation With Biml

SSIS was originally designed to work in a world where all data was structured and on premise. As modern enterprise data projects increasingly move online, tools like Azure Data Factory (ADF) can extend SSIS capabilities to the cloud. Azure Data Factory is a flexible and powerful cloud based ETL service, but it doesn’t replace the functionality of SSIS. In this session you will learn:

  • The advantages and disadvantages of both ETL platforms.
  • How to use both in tandem to maximize productivity.
  • How both ETL platforms, as well as any supporting structures, can be be automatically generated with Biml Script.

All of the code used in this presentation can be downloaded by attendees, customized, and used in their production environments.

Anyway, it’ll be a great time, and I can’t wait to see some of you there!

Download True Story of Biml Presentation Files

1 comment to My Wife and I are Presenting at SQL Saturday Dallas on June 1st!

Leave a Reply to Cathrine Wilhelmsen

 

 

 

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>