|
|
If you are in the DFW area, come down to the North Texas SQL Server User Group tonight at the Microsoft building in Irving, Tx. The meet and greet starts at 6:00pm and the presentation follows at 6:30pm. I’ll be giving the following brand new, deep dive presentation.
Creating Your Own ETL Automation Framework with Biml for Beginners
You may have heard of Business Intelligence Markup Language or even tried to learn it. But how can you take the time to learn it, while getting the rest of your work done. In this highly interactive presentation, I’ll guide you through the process of learning/using Biml, without sacrificing your daily productivity.
We’ll cover how to:
- Identify “easy” ETL patterns to BimlScript
- Take incremental steps in automating these processes
- Move to metadata driven BimlScript
- Tie it all together into a full-fledged framework
As a bonus, you’ll leave the presentation with a completed framework which dynamically generates most types of flat files that you can use in your own environment.
Anyway, additional details about the meeting can be found here. Hope to see some of you there!
This is just a quick note that I’ll be presenting an updated version of the following talk tomorrow at SQL Saturday Houston.
Agile Data Warehouse Design with Biml
Business Intelligence Markup Language is literally changing the way we think about Data Warehouse design and ETL. In this interactive presentation you’ll see how you can rapidly iterate through the Data Warehouse Development Cycle and provide ROI almost immediately. Learn how you can use BimlScript to automatically create staging tables, SSIS Packages, and other necessary objects during the modeling process.
Presentation Code Download
It’ll be a great time, and I can’t wait to see some of you there!
If you are in the DFW area, come down to the Forth Worth SQL Server User Group tonight at the Frees and Nichols Headquarters. The meet and greet starts at 6:30pm and the presentation follows at 7pm. I’ll be giving an updated version of the following presentation.
Azure Data Factory 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;
and how both ETL platforms, as well as any supporting structures, can be be automatically generated with Biml Script.
Anyway, additional details about the meeting can be found here. Hope to see some of you there!
This is just a quick note that I’ll be presenting an updated version of the following talk tomorrow at SQL Saturday Dallas.
Agile Data Warehouse Design with Biml
Business Intelligence Markup Language is literally changing the way we think about Data Warehouse design and ETL. In this interactive presentation you’ll see how you can rapidly iterate through the Data Warehouse Development Cycle and provide ROI almost immediately. Learn how you can use BimlScript to automatically create staging tables, SSIS Packages, and other necessary objects during the modeling process.
Presentation Code Download
Also, I’m bringing a bunch Biml t-shirts with me, courtesy of my friends at Varigence.
It’ll be a great time, and I can’t wait to see some of you there!
This is just a quick shout out for anyone attending the PASS Summit. I am giving two presentations, and couldn’t be more pumped. First, I’m giving the following Lightning Talk in 2 hours:
Three Things You Won’t Believe I Do With Biml
Room: 618-620
Time: 4:45PM – 6:00PM
You may have seen a basic Biml presentation in the past, perhaps a data staging pattern moving records from one database to another, and that’s all great. In this presentation I will amaze and astound you with advanced applications of Biml that I guarantee you have never seen. In front of your very eyes, I will use small amounts of BimlScript to tackle problems that have vexed ETL developers for years.
I will also be presenting the following 75 minute presentation on Friday.
Azure Data Factory and SSIS Automation With Biml
Room: 615-617
Time: Friday 3:30PM – 4:45PM
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;
and how both ETL platforms, as well as any supporting structures, can be be automatically generated with Biml Script.
So, if you’re attending the PASS Summit, I’d love to see you there!
Just a quick shout out that I’ll be at SQL Saturday Oklahoma City tomorrow to give an updated version of the following presentation.
SSIS Performance Tuning with BimlScript
You may heard that Biml can automate ETL loads, but what if your data warehouse is several terabytes with a tight load window. In this demo focused presentation, we’ll discuss how to use BimlScript to accomplish the following:
– Dynamically create multiple SISS packages for a data warehouse ETL load, each following a different best practice design pattern.
– Automatically execute each package multiple times and record the results for analysis.
– Determine which package version should be used in production.
The only way to be sure that your SSIS packages are performing optimally is to test them against multiple patterns. Make your life easier and let BimlScript do the work for you.
Presentation Code Download
Also, I’m bringing a big box of Biml schwag with me, courtesy of my friends at Varigence, including shirts, miniature footballs, laptop stickers, etc.
It’ll be a great time, and I can’t wait to see some of you there!
If you’re in the Sioux Falls, SD area this weekend, come see me present at SQL Saturday Sioux Falls #539! I’m going to fly up Friday afternoon, and will be giving the following presentations.
Agile Data Warehouse Design with Biml
Business Intelligence Markup Language is literally changing the way we think about Data Warehouse design and ETL. In this interactive presentation you’ll see how you can rapidly iterate through the Data Warehouse Development Cycle and provide ROI almost immediately. Learn how you can use BimlScript to automatically create staging tables, SSIS Packages, and other necessary objects during the modeling process.
Presentation Code Download
SSIS Performance Tuning with BimlScript
You may heard that Biml can automate ETL loads, but what if your data warehouse is several terabytes with a tight load window. In this demo focused presentation, we’ll discuss how to use BimlScript to accomplish the following:
– Dynamically create multiple SISS packages for a data warehouse ETL load, each following a different best practice design pattern.
– Automatically execute each package multiple times and record the results for analysis.
– Determine which package version should be used in production.
The only way to be sure that your SSIS packages are performing optimally is to test them against multiple patterns. Make your life easier and let BimlScript do the work for you.
Presentation Code Download
Anyway, it’ll be a great time, and I can’t wait to see some of you there!
If you are in the DFW area, come down to the North Texas SQL Server User Group tonight at the Microsoft building in Irving, Tx. The meet and greet starts at 6:00pm and the presentation follows at 6:30pm. I’ll be giving the following brand new, deep dive presentation.
Biml Baby Steps – Automation for Everyone
Biml is not just for BI Professionals. DBAs and Developers of all types can use it to dynamically generate code.
So, you may ask, “How do I get started?” In this special 2 hour interactive presentation, I’ll guide you through the process of creating your first BimlScripts. We’ll cover the basics of Biml syntax, C# scripting, the important role of metadata, and a lot more. As an added bonus, you’ll leave the presentation with BimlScripts you can adapt to use in your own environments using tools that you already have.
Free Stuff
I’m going to bring some Biml schwag with me, courtesy of my friends at Varigence, including shirts, miniature footballs, laptop stickers, etc.
Anyway, additional details about the meeting can be found here. Hope to see some of you there!
Download
The instructions and code for this demo can be found here: Biml Baby Steps.
If you are in the DFW area, come down to the Forth Worth SQL Server User Group tonight at the Frees and Nichols Headquarters. The meet and greet starts at 6:30pm and the presentation follows at 7pm. I’ll be giving an updated version of the following presentation.
SSIS Performance Tuning with BimlScript
You know that Biml can automate ETL loads, but your data warehouse is several terabytes with a tight load window. In this demo focused presentation, we’ll discuss how to use BimlScript to accomplish the following:
– Dynamically create multiple SISS packages for a data warehouse ETL load, each following a different best practice design pattern.
– Automatically execute each package multiple times and record the results for analysis.
– Determine which package version should be used in production.
The only way to be sure that your SSIS packages are performing optimally is to test them against multiple patterns. Make your life easier and let BimlScript do the work for you.
Free Stuff
I’m going to bring some Biml schwag with me, courtesy of my friends at Varigence, including shirts, miniature footballs, laptop stickers, etc.
Anyway, additional details about the meeting can be found here. Hope to see some of you there!
Just a quick shout out that I’ll be at SQL Saturday Oklahoma City tomorrow to give an updated version of the following presentation.
Agile Data Warehouse Design with Biml
Business Intelligence Markup Language is literally changing the way we think about Data Warehouse design and ETL. In this interactive, demo focused presentation you’ll see how you can rapidly iterate through the Data Warehouse Development Cycle and provide ROI almost immediately. Learn how you can use Biml Script to automatically create staging tables, SSIS Packages, and other necessary objects during the modeling process.
I’m also bring a big box of Biml schwag courtesy of my friends at Varigence. Hope to see some of you there!
Page 1 of 3312345...102030...»Last »
|
|
Recent Comments