Archives

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

Announcing Two Biml Presentations Next Week

My enthusiasm for Biml must be catching because I’ve been asked to give two presentations next week.

I’ll be giving a brand new presentation on Tuesday, November 12th, at 4:30pm for the MSBIC group at the Microsoft Building in Irving, TX. This presentation is targeted towards Business Analysts, management, and other members of the data warehouse [...]

Thank You to My NTSSUG SQL Family

I’m happy to announce that I’ve just been elected to the North Texas SQL Server User Group Board of Directors. I owe so much to the PASS Community in general, but even more to our local group. In case you aren’t aware, the NTSSUG is one of the most active and successful groups in the [...]

Biml Makes You THE ONE

The Matrix is one of my favorite movies. The story, special affects, and the theme are so compelling that I’ve watched the movie at least a dozen times. I referenced it in the introduction for my SQL Saturday 255 presentation, Biml – The Next Step in Agile Data Warehousing, and it fits in perfectly with [...]

Page 1 of 612345...Last »