Category: Uncategorized

It’s the end of another year, and thus the beginning of the next one. Whether you had a successful 2009 for your career or not, now is the time to set a goal and make a plan for the new year. Take an hour over the next day and think about your career and where you want to go, what you want out of your career in the next year, or even next three.

Then make a goal.

A resolution to do something along those lines. It could be blog more (or better), learn a new skill, take on a new responsibility, or something else, but make an effort in 2010 to add something substantial to your modern resume. Add something that will build your brand and make it more attractive to your current, or a potential new, employer.

Something besides another year of work.

cross posted to The Modern Resume

Someone submitted an article recently that walked through how to find the rules in your database, which columns they were bound to, and then how to remove them in order to replace them with Check Constraints. It was interesting because it had been a long time since I’d worked with rules.

Actually I never used them in any databases I designed, though I did run into them with some third party products. For those of you not familiar, a rule functions like a CHECK CONSTRAINT, and determines what is a valid value to put into a column. You use sp_bindrule to link a rule (like a default) to a column. As that page says, however, rules are deprecated and shouldn’t be used.

In fact, they ought to be replaced with check constraints, which function in much the same manner. It’s fairly easy to do, although determining where the rules are bound isn’t. Look for the article soon at SQLServerCentral.

And start replacing those rules with constraints. It will save you some work down the road as likely SQL 11 or SQL 12 won’t upgrade with them.

We usually stuff stockings with little things for each other in the family. Sometimes it’s junk, or candy, but this year I tried to be a little better. I aimed for funny and practical, and cheap.

My wife got some wiper blades since her truck needs them. My oldest got deer whistles since he’s worried about hitting a deer out here. All the kids got little flashlights, and there were a couple book lights in there.

Me? I got pens! Nothing fancy, just a pack of cheap Bic clicker pens.

It’s funny since I am always complaining that I can’t find pens. Despite all the stuff on my desk, I have lots of pencils, sharpies, and other desk instruments, but not pens. So finding them in my stocking was pretty funny for me.

Just a short Happy Holiday, Merry Christmas wish to everyone out there. Enjoying our White Christmas here in Denver.