This blog will no longer be updated.

New content is available on my new blog

Happy New Year - Piotr Rodak

Happy New Year

Well, this is my last post this year - I know, there weren't too many of them anyway, but I plan to improve my frequency, promiseSmile .

I have a few days off and all of a sudden I got a flu or cold, felt pretty rubbish two days ago. I spent all day in bed yesterday, sleeping, playing with Rubik's Cube and reading a book - The Storage Engine Big Smile. The effect of day in bed was that I couldn't sleep at night and my brain was plotting grand plans how to become rich and retire before end of 2010. Well, I didn't come up with anything you wouldn't know already so regarding this it was a wasted night. However, I came across idea of using regular expressions to parse some SQL queries to pick table names or columns in select statemets. I downloaded very cool regex designer and was playing with the idea for the whole day today. Call me a geek, but I think regular expressions are cool. It's a pity they are not natively implemented in SQL Server, but on the other hand it would encourage developers to do really heavy lifting on character data in the database - and DBAs would have yet another trouble to look after.

Anyway, happy New Year folks, let it be even better than the old one.

 

Published 30 December 2009 23:49 by Piotr Rodak

Comments

# re: Happy New Year

Czesc Piotrek,

RegEx is indeed a powerful thing but it's a bit write-only as languages go, which is a real shame. I don't know if you know that classic quote by Jamie Zawinski:

Some people, when confronted with a problem, think “I know, I'll use regular expressions.”   Now they have two problems.

04 January 2010 09:44 by DavidWimbush

# re: Happy New Year

That's a good quote :)

On the other hand it is surprising how many people DO NOT know regular expressions what results in wicked code.

04 January 2010 21:59 by Piotr Rodak