Skip Main Navigation
Page Content
This event has ended

SQL Saturday #331 Denver Pre-Con w/Tim Mitchell & Reeves Smith

Denver SQL Server User Group

Friday, September 19, 2014 from 9:00 AM to 5:00 PM (MDT)

SQL Saturday #331 Denver Pre-Con w/Tim Mitchell &...

Ticket Information

No tickets available.

Share SQL Saturday #331 Denver Pre-Con w/Tim Mitchell & Reeves Smith

Event Details

Title: Getting Started with Biml (Business Intelligence Markup Language)

Have you ever needed to generate dozens (or even hundreds) of similar SSIS packages? Do you ever find yourself needing to regenerate a lot of packages when some piece of the upstream data format changes? These are not uncommon scenarios faced by ETL developers, but historically there haven’t been any good tools to help with this. However, we’re going to introduce you to one of the most useful tools you may ever use: Biml.
For ETL developers, Biml (Business Intelligence Markup Language) is a game changer. This is a great new tool for Microsoft business intelligence developers who want to make the most of their development efforts. In short, it’s an XML-based language that will allow you to programmatically create SSIS packages. Even better, it can be enhanced with VB.NET or C# scripting to create BimlScript, which allows you to dynamically build and modify a few, dozens, or even hundreds of packages with minimal effort. Best of all, you don’t need budget approval – if you already have Visual Studio, you can use Biml and BimlScript for free!

In this full-day presentation, we'll introduce you to dynamic package generation through Biml. Business intelligence consultants Tim Mitchell and Reeves Smith will walk you through the essentials of Biml – getting started, syntax, and common uses – followed by dozens of design patterns to improve your efficiency as an ETL developer.
Among the topics that we’ll cover:

  • Overview of Biml – What is it? Where do I use it?
  • Introduction to Biml syntax
  • Biml in the Visual Studio environment
  • Introduction to BimlScript syntax
  • Dynamic package generation with BimlScript
  • Metadata management with Biml
  • Create a simple staging package project with dozens of packages in less than an hour
  • Package (re)generation
  • Source control
  • Common design patterns for Biml in the enterprise
  • Taking Biml to the next level with Mist

By the end of this full-day presentation, you should be equipped to get started immediately using Biml. It’s a revolutionary technology, and we hope that you’ll be as excited about Biml as we are.

This course is intended for business intelligence developers and other database professionals with experience creating and supporting SQL Server Integration Services (SSIS) packages. Attendees should have a working knowledge of the SSIS essentials. In addition, some experience with either C# or VB.NET, and a basic understanding of XML (or other markup language) would be helpful.

Speaker: Tim Mitchell & Reeves Smith

Speaker Bio:












Tim Mitchell is a business intelligence consultant, author, and trainer. He has been working with SQL Server for a decade, working primarily in business intelligence, ETL/SSIS, data quality, and reporting. He holds a Bachelor’s Degree in Computer Science from Texas A&M at Commerce, and has been a Microsoft SQL Server MVP since 2010. Tim is an independent BI consultant and a group principal with Linchpin People.

As an active member of the community, Tim has spoken at international, regional, and local venues including the SQL PASS Summit, SQLBits, SQL Connections, SQL Saturday events, and various user groups and webcasts. Tim is coauthor of the book SSIS Design Patterns, and is a contributing author on the charity book project MVP Deep Dives 2. He is an active group member and speaker at the North Texas SQL Server User Group in the Dallas area.

You can visit his website and blog at or follow him on Twitter at

Reeves Smith is a consultant and trainer. He holds a Bachelor’s Degree in Applied Mathematics from University of Colorado at Colorado Springs and a Microsoft Certified Master with over 17 years of experience working with SQL Server. Reeves is an independent BI consultant and teammate with Linchpin People.

He is an active member of the Denver, CO, PASS chapter and delivers technical presentations at local and regional conferences and user groups. He has had the opportunity to work on various development and data warehouse projects within industries like banking, DoD, energy, entertainment, gaming, healthcare, manufacturing, oil and gas, travel, and telecommunication.

You can visit his website and blog at or follow him on Twitter at SQLReeves.

Have questions about SQL Saturday #331 Denver Pre-Con w/Tim Mitchell & Reeves Smith? Contact Denver SQL Server User Group

When & Where

Cherry Creek Presbyterian Church - Community Life Center
10150 E. Belleview Ave.
Englewood, CO 80111

Friday, September 19, 2014 from 9:00 AM to 5:00 PM (MDT)

  Add to my calendar


Denver SQL Server User Group

SQLSaturday #441 is being held on Saturday, September 19th at The Summit Event Center, registration to Saturday is separate from these pre-cons and is required if you plan to attend the Saturday sessions. Please register at


The Denver SQL Server User Group is organized to bring professionals of all career levels that work with Microsoft's SQL Server, together to learn and network with others. There is no charge to attend and you are encouraged to bring your co-workers. Through our sponsors, we provide food and refreshments.

We meet every third Thursday of each Month at Microsoft DTC (7595 Technology Way, Suite 400, Denver, CO 80237).

Visit for more information and to create a free account.

  Contact the Organizer
SQL Saturday #331 Denver Pre-Con w/Tim Mitchell & Reeves Smith
Englewood, CO Events Class Science & Tech

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.