Archives

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 [...]

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 [...]

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 [...]

Presenting Tonight for the SSIG in Greenville, SC

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 [...]

Upcoming Biml Precon at SQL Saturday Phoenix

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 [...]

My Biml Metadata Strategy

Now that we’ve discussed various common metadata strategies used in creating BimlScript, I’m going to explain exactly how the metadata in my sample BimlScript framework functions. Basically, I’m going to start to pull back the curtain and explain some of the “magic” involved in my Biml – The Next Step in Agile Data Warehousing presentation.

As [...]

Strategies and Languages for Generating Biml

What are the best methods for generating Biml and what language should you use? Before I dive into this, let me begin with a disclaimer. I applaud anyone working with Biml to improve their productivity and eliminate needless, repetitive work. One of the primary advantages of Biml is its flexibility, which allows people to generate [...]

Biml Metadata Options and Considerations

Simply put, metadata is data about data. Probably the most common way that SQL Server Professionals use metadata is when we query SQL Server System Views. In this article we’ll discuss using metadata to drive BimlScript automation. Before I start listing common metadata sources and methods, I need to briefly contrast two basic metadata philosophies [...]

Agile Data Warehouse Development using Biml

Agile development is good, Waterfall is bad. We hear this all the time, along with un-documented statistics claiming that approximately 80% of Data Warehouse projects fail. So, we as Business Intelligence Professionals are told that we must be Agile. Whenever I taught Dimensional Modeling and Data Warehouse classes, I could count on at least one [...]

Biml Syntax Basics and Rules

Biml is a human readable XML language, created by a company called Varigence, which compiles into SQL Server objects such as tables, views, SSIS packages, and SSAS cubes. In this post, we’ll cover the basics of the Biml language so you can start coding as fast as possible. Since, I’ve always found that it’s easier [...]

Page 1 of 612345...Last »