T-SQL Tuesday #107: Death March

T-SQL Tuesday #107: Death March

This Month's T-SQL Tuesday is hosted by Jeff Mlakar, and he has asked for us to tell the tale of a project that went horribly wrong. This will be short, but it's one of my favorite stories of a project that wasn't totally thought through. I (thankfully) wasn't part of the team for this, but the way word spreads in IT, my group heard of this, and we were shaking our heads in disbelief very quickly. Back in the day, I worked at a large organization with a very large IT staff. There were many systems on differing platforms, and…
Read More

A Tale of a Trigger

This month's T-SQL Tuesday is being hosted by Steve Jones, who has asked for blog posts today on experiences we have had with triggers, good or bad. I am not a fan of triggers. While they represent a very simplistic construct of "if something happens, do something else", I've yet to encounter a situation where they weren't more trouble than they were worth. In my opinion, their biggest flaw is that they're very easy to forget about, and then tend to pop up and create problems when least expected. I avoid them like the plague, and happily tell my clients…
Read More

Collecting Other People’s Christmas Cards

I think one of the reasons I like computers is that they're so much easier to deal with than people. They're predictable, emotions never get in the way, and there's always a logical explanation for everything if you dig deep enough. All that being said, I am grateful for my hobbies that don't involve sitting in front of a computer all day. Thinking through the things I enjoy in my spare time, three central themes that seem to keep popping up are art, architecture, and railroads. Here's two examples of that: Turner Family Christmas Cards The University of Illinois will…
Read More

T-SQL Tuesday #96: Folks Who Have Made A Difference

It's been quite a while since I've written for a T-SQL Tuesday, but I saw this month's topic and felt compelled to throw my 2 cents in. Our host for the month, Ewald Cress (@sqlOnIce) is asking for us to write about people who have made a meaningful contribution to our lives as data professionals. There have certainly been a lot of people who have helped me get to where I am with my career today, but for this post I'd like to take things back to the very beginning. He wasn't my first boss, but was the first DBA…
Read More

T-SQL Tuesday #76 Wrap-Up

This post took me a little longer to put together than it should have, but seeing as how I now have a two week old son at home, time is a little harder to come by these days! My T-SQL Tuesday topic ended up attracting 4 excellent responses, which I'm very happy to recap. The first post was from Rob Farley (@rob_farley).┬áRob has some great insights into text search, but not full-text search. (That's perfectly fine, I left the topic open on purpose and never intended for it to be limited to full-text search.) He tells us all about how…
Read More