Archives

Presenting Azure Data Factory Automation with #Biml at the PASS Summit!

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!

Presenting SSIS Performance Tuning With #Biml Tomorrow at #SQLSatOKC

Varigence_Football
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!

I'm Giving Two Biml Presentations at SQL Saturday Sioux Falls!

Varigence_Football
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!

Presenting on Biml Tonight at North Texas SSUG!

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.

Presenting SSIS Performance Tuning with BimlScript Tonight in Fort Worth!

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!

Presenting Agile Datawarehouse Design With #Biml Tomorrow at #SQLSatOKC

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!

Presenting Agile Datawarehouse Design With Biml Tonight at NTSSUG

If you are in the DFW area, come down to the North Texas SQL Server User Group tonight at the Microsoft Building in Irving. The meeting starts at 6pm CST. I’ll be giving 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.

Ryan Adams (Blog/Twitter) will be giving the second presentation of the evening.

Is AlwaysOn the Right High Availability and Disaster Recovery Plan for me?

You need a high availability and disaster recovery solution for your mission critical databases. SQL Server AlwaysOn can help, but with Windows Clustering, Failover Cluster Instances, and Availability Groups, the choices get confusing and complicated quickly. This session will clear up all the confusion by explaining the various components and exposing all the gotchas. You will learn how to choose the right level of protection for your environment. You will walk away with the knowledge and confidence to pick the right solution to give your critical databases a solid high availability and disaster recovery plan.

Oh, and I should mention that Ryan is running for the PASS Board of Directors and I can’t wait to vote for him.

Anyway, additional details about the meeting can be found here. Hope to see some of you there!

SQL Saturday Dallas Precon Vote

As my fellow board member Ryan Adams mentioned recently, the North Texas SQL Server User Group is choosing SQL Saturday #447 precons by popular vote. The voting went live this weekend, and I urge everyone who may attend our SQL Saturday to take part. Each person is only allowed to vote for one precon, and your vote does not obligate you to actually attend one. Each of the 10 submission abstracts can be found here.

To vote, please email precons@ntssug.com and include the session name in the subject line. I submitted the following abstract and would like your vote.

Fast Track your Business Intelligence Projects with Biml

You’re a business intelligence developer or manager trying to provide quality data in a timely, cost-effective manner. Perhaps you’ve considered Agile methodology, but found that the details of ETL, the plumbing if you will, makes iterative development all but impossible. In just one day, you’ll learn how to leverage Biml Business Intelligence Markup Language (Biml) to super charge your ETL efforts, alleviating the pain and tedium of data warehouse development.

You will Learn:

  • How Biml makes Agile data warehouse development a reality.
  • Understand the basic syntax and rules of Biml, the important role of meta data, and how to choose the right scripting language for you.
  • Using BimlScript to dynamically create tables, views, and the SSIS packages to load them.
  • How to change your development mindset and spot re-usable patterns which are ideal for using Biml.

As an added bonus, you’ll leave the precon with several production quality BimlScript frameworks and code samples to use in your own environments. None of these samples require special software or third party tools. These samples will enable you to:

  • Dynamically create and load an Operational Data Store with historical tracking.
  • Dynamically create and load an Enterprise Data Warehouse using Agile Methodology.

But wait, theres more!
To help you learn BimlScript faster and easier, Varigence has agreed to provide a free two month subscription to Mist/BimlStudio to all attendees. This is a $500 value!

The entire seminar is geared toward getting you up to speed on BimlScript so you can stop wasting your time repeating the same old patterns. Come see why Biml is changing the way we build data warehouses.

I'm Giving Two Biml Presentations at SQL Saturday Houston!

Varigence_Football
If you’re in the Houston area this weekend, come see me present at SQL Saturday Houston #408! I’m going to head down Friday afternoon, and will be giving the following presentations.

Writing Your First BimlScript

In this highly interactive presentation, I’ll guide you through the process of creating your first BimlScript. During the process we’ll cover the basics of Biml syntax, language options for generating BimlScript, recommended methods of storing and using metadata to drive your BimlScipts, and a lot more. As an added bonus, you’ll leave the presentation with several BimlScripts you can adapt to use in your own environments.

This is talk has been updated since the last time I gave this 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 have a bunch of Biml schwag with me, courtesy of my friends at Varigence. I’ll be bringing shirts, miniature footballs, laptop stickers, etc.

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

I'm Presenting on Biml at Austin SQL Saturday

I’m looking forward to seeing #SQLFamily this weekend down in Austin. I’m going to head down Friday afternoon, and will be giving a newly revised version of one of my favorite presentations.

Writing Your First BimlScript

In this highly interactive presentation, I’ll guide you through the process of creating your first BimlScript. During the process we’ll cover the basics of Biml syntax, language options for generating BimlScript, recommended methods of storing and using metadata to drive your BimlScipts, and a lot more. As an added bonus, you’ll leave the presentation with several BimlScripts you can adapt to use in your own environments.

I’m going to have a bunch of Biml schwag with me, courtesy of my friends at Varigence. In fact, since this is Superbowl weekend, I’m going to be tossing some Varigence footballs around during my talk.
*** Note: Insert mandatory joke about deflated balls here.
Varigence_Football

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

Page 1 of 3212345...102030...Last »