Archives

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!

Presenting on Biml Tonight at MSBIC

If you are in the DFW area, come down to the MSBIC Meeting tonight at the Microsoft Building in Irving. The meeting starts at 5pm CST. I’ll be giving an updated version of the following presentation.

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.

Hadoop Series

Also, the great Bryan Smith will be giving another presentation in his fascinating Hadoop series. Details can be found on the MSBIC Website.

I hope to see some of you there!

Teaching a Full Day of Biml Goodness For Tulsa School of Dev

Calling all Business Intelligence/Data Warehouse folks within driving distance of Tulsa, Oklahoma. A week from tomorrow, Friday 5/16, I’ll be presenting a full day of Biml Training at the Tulsa School of Dev, and for the low, low cost of….. FREE! Wait, did I read that right? Does that say Free? Yes, my friend the entire event is Free of charge. The content will be an updated version of the precon I gave at SQL Saturday Phoenix.

I’ve divided the day into four sessions, but I highly recommend that you attend all of them because each one builds on it’s predecessor. My Abstract is listed below:

Automate Data Warehouse Development with Biml

In this series of sessions, you’ll learn how to use BimlScript to automate your data warehouse development using Agile methodology. You’ll also receive many code samples to use in your own environments. Come see why Biml is changing the way we build data warehouses.
Session 1 Focus:

  • How Biml makes Agile data warehouse development a reality.
  • Understand the basic syntax and rules of Biml.

Session 2:

  • The important role of meta data, how to store and consume it to drive your Biml automation framework.
  • How to choose the right scripting method and language for you.

Session 3:

  • Using BimlScript and metadata to dynamically create tables, views, and the SQL Server Integration Services packages to load them.

Session 4:

  • How to spot re-usable patterns which are ideal for using Biml.
  • How to write advanced BimlScript code to create drastically improve your productivity.

Anyone who’s watched me present on Biml, knows how pumped I am about the technology, and the amazing things you can do with it. Hope to see some of you up in Tulsa!

I'm Presenting at SQL Saturday Houston

Hey folks, this is just a quick post to urge people to attend SQL Saturday Houston this weekend (May 10th). The lineup of speakers is impressive, and I’ll be there as well. I’ll be giving a new presentation on Biml at the event. The abstract is below.

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 can’t wait to get down there and spend time with my SQL Family (#SQLFamily). I hope to see some of you there!

Presenting Tonight for the SSIG in Greenville, SC

Bimlprecon
The fine folks at Varigence were kind enough to invite me to come and spend a couple of days with them at their headquarters in Greenville, NC. I’m excited to discuss Biml strategy with them, and how to best leverage and extend my BimlScript frameworks. To be honest, I can’t wait to spend some quality time with them to compare notes and pick up some new ideas.

I’m also going to present something new tonight for the SQL Server Innovators Guild (SSIG).

A CRUD-dy Alternative to Slowly Changing Dimension Processing

Slowly Changing Dimensions (SCD) are the foundation of Data Warehousing. Many of us use T-SQL Merge to process SCDs because the pattern is well known and it performs reasonably well. However, many experts in the SQL Server Community recommend that we stop using it, due to many outstanding bugs, but have not recommended a suitable T-SQL alternative.

In this session, I’ll show you how I use standard CRUD, mostly Inserts and Updates, to process Slowly Changing Dimensions. My current design pattern yields high performance, great flexibility, and easily maintainable code. As an added bonus, you’ll leave this presentation with the design pattern and code samples that you can quickly put to work in your environments.

Wednesday night I’m flying back home to Michigan for a few days to spend time with friends and family. It’s been too long, and I need to recharge my batteries.

Upcoming Biml Precon at SQL Saturday Phoenix

Bimlprecon
The good folks putting on SQL Saturday Phoenix have asked me to give a full day Precon seminar on Friday March 28, 2014. This will be my first Precon focused on Biml (Business Intelligence Markup Language), and I’m really pumped about it.

Fast Track your Business Intelligence Projects with Biml – Precon

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 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.
  • How to leverage BimlScript for ETL performance tuning.

As an added bonus, you’ll leave the precon with many BimlScripts and code samples you can adapt to use in your own environments. 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.

Tickets can be purchased here. If you order by 2/28 the price is only $99 and is $125 after that. Keep in mind that there is a small processing fee as well.

SQL Saturday Phoenix Presentations

If you can’t attend the Precon, I’ll also be giving two presentations on Saturday which are free of charge (of course). If you’re in the area, come see me present:

Biml – The Next Step in Agile Data Warehousing

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.

Data Warehouse Mistakes You Can’t Afford to Make

Many data professionals understand the basics of Data Warehouse design, including Dimension and Fact Tables, slowly changing Dimensions, and the use of meaningless surrogate keys. However, it isn’t until you’ve created a dimensional model and put it into production, that you realize just how much of an impact seemingly trivial mistakes can make. They can hobble performance, allow inaccuracy, and perhaps worst of all, inhibit adoption and usage of the new system. Learn how to avoid many common mistakes, from someone who’s made them and then found ways to correct them.

More details about SQL Saturday Phoenix #279 can be found here. Hope to see a bunch of you there!

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