Data Head Stats:
- Where are you from, and what kind of company do you work for?
- I am from all over the place. I was raised in the military and grew up in many places throughout the United States and Germany. I hail from Grantsville, Utah now. I work for a company that provides Software as a Service (SaaS).
- What’s decorating your office and/or desk right now?
- Scary question. Decorating my office is construction materials and tools. I am in the process of remodeling and finishing. On and around my desk you can find computer accessories and parts. Sprinkle in the family photos, Bucky Balls, and a few books. I do like my math/geek clock from ThinkGeek that also decorates the space.
- What’s the biggest challenge you’ve faced with SQL Server this year? What made it such a roadblock, and how did you eventually turn it from a problem to a solution?
- My biggest challenge this year has been to get XML input from a Web site to rapidly update in the database. The XML contained hundreds of records and needed to be parsed and inserted into correct tables. The XML insert never performed as fast as was desired and the challenge was to make it fast. We optimized the process to get it running up to ten times faster, but that still wasn’t fast enough. In the end, we changed our process to insert from the app into a TVP and then call the proc. This got the inserts down to the desired time. In the end this made a little more sense than serializing the data into XML and then transmitting it to just shred it at the db side.
- When did you discover your love for technology?
- I think that would date me clear back to junior high when I took a Pascal programming class. I liked the idea of creating my own programs and games in class.
- Who’s your current favorite database blogger?
- It depends on the mood I’m in and the type of material being churned out at the time. That being said, I do like to read the stuff that Paul White, Gail Shaw, Paul Randal, and Jonathan Kehayias write.
- Any thoughts on Denali, from how it looks in its latest release to its sticking-with-the-mountain-theme name?
- do like some of the new features. I think they have made improvements to some of the functions such as the OVER clause and how that will help with running totals.
- What’s the geekiest thing you’ve ever done? (Or at least will admit to!)
- Tough call. My wife could probably easily list off several hundred without giving it too much thought. As long as she laughs, it’s all good, right? I would have to say it is a toss-up between constant quoting of Monty Python and the Holy Grail and doing the occasional Urkel stand-up routine.
There are a lot of us lean, mean, data-analyzing machines out there in the real and virtual worlds, and it’s easy for interesting colleagues to get lost in the shuffle. With that in mind, we’ve launched Data Heads, a series of profiles of some of the most intriguing database professionals out there.