A community of more than 1,600,000 database professionals and growing

I was discussing the PASS Summit with someone and they were wondering about building their schedule. Actually, they wanted to pick sessions, but see the choices in a calendar format, but the schedule wasn't out at that point in time. My suggestion was to just build the schedule and then sort out conflicts later.

A few people have mentioned over the years that they want to build a schedule and be ready for the event to maximize their experience and be efficient. I think that's a common, normal thing that many technical people like to do. Many of us are Type-A, and we like knowing our plans and having a schedule prepared in advance. We can then decide which sessions might have greater priority for us during a time slow and adjust our choices to have the best experience. After all, we may want to see two speakers, but if they present at the same time, we have to make a choice.

The problem is that we don't have perfect information. Even if the descriptions and abstracts included perfect information about the agendas, what is covered, and to what depth, including demos, we'd still not necessarily assimilate and recognize all that data in a way that makes sense, even to us. There are no shortage of people that make plans today and are unhappy a few weeks later.

Even if we knew what we wanted to watch, many of us might think a session on database design has to cover third normal form, even when the text said this examines PKs and FKs. We might assume an SSIS data load talk included something on CSVs when the presenter described the talk as being for ragged right text files.

We're human, and that means we have flaws in how we deal with the world. This includes the ways in which we model and analyze data. We can make mistakes in our analysis often when we simplify our view of a problem to the point where our analysis is inherently flawed. If we don't account for this and assume we're flawed, we may overweight our conclusions.

I try to remember this when I write reports from systems that others will use. I won't have every piece of information that might affect a decision, but I try to ensure I have the most important, or significant, data. Or at least, the data I and the users feel is significant. The important thing to remember is that out data is always incomplete, and it's entirely possible that we have missed a valuable piece of data.

When that happens, we have to adapt and adjust our report, our application, or our conference schedule. We'll learn more across time and we can use that information to change our system. I know that my view of a conference like the PASS Summit today, or even a week before the event, will be different than how I feel at the event. I should have a plan, but be willing to flex as circumstances change. And, always have a backup. I like to pick two or three sessions for every time slot, just in case.

Join the debate, and respond to today's editorial on the forums

The Options column is a column set. As values are added to the sparse columns, the column set returns an XML representation of the values.

Ref: Use Column Sets - click here

» Discuss this question and answer on the forums