Everytime I need to render date and time to a DateTime field, I have to scour the Internet to figure out how.  Well, here is how:

If you need to get hourly statistics on your website, select and group by the following metric:

TO_LOCALTIME(QUANTIZE(TO_TIMESTAMP(date, time),3600)) AS Hour

This will properly combine date and time and offset by the correct timezone to a single datetime field recognized by most data parsers.  And it will look like this:

2009-01-21 12:00:00

It shouldn't be too difficult to change that to minutes, seconds, periods, whatever you need.

And so, today we begin the four years of our Great Nation's biggest electoral mistake.

I truly hope I am wrong.

I am learning and working with a Business Objects framework at work called CSLA.NET (Component-based Scalable, Logical Architecture).  It is built heavily using the best of OOP especially polymorphism and abstraction.  You build your objects all based on a handful of base classes that provide a huge variability of useful features.  It also abstracts out data and .NET remoting layers to make the developers life easier.  If you are building large, scalable n-tier applications, you should definitely look this one up. 

Also check out the book Expert C# 2005 Business Objects, which is the companion to the framework.  If nothing else, it contains a great description of n-tier architecture and why to use it.

Ah, the classics.  Occasionally, I will go back and re-read a book I haven't picked up in decades.  Gateway is such a book.  It has been so long, I couldn't even remember the plot.  Oh, I remembered the premise alright, but the details of the plot were lost to me.  This classic of Sci/Fi has spawned sequels, imitations and a pretty decent (1992) computer game. 

Gateway is the story of a reluctant explorer in the hunt for Heechee artifacts.  The Heechee were a race of ancients that left a space station, dubbed Gateway, complete with several hundred FTL ships.  Once discovered, they were quickly experimented with to find that although no one could figure out how to program them, random combinations of the controls would send a ship out and return to Gateway automatically.  Untold riches awaited volunteers who could ride the ships and return with more artifacts, if any are to be found.  Of course, many dangerous and fatal things were on the other end of the trips, and chnaging the controls mid-flight meant certain death.  Our hero is one of the volunteers who must overcome his very reasonable fears and make some trips out.

Gateway is told from a split perspective.  We know that the protagonist is ultimately successful, as he is very wealthy and undergoing therapy, the primary vehicle of the plot.  However, the therapy hints at horrible trauma and the deaths on his conscience.  The well executed plot leads to a suspected, yet surprising ending that is very satisfying.  There are many reasons why this is a classic, and well justified.

Book 2 from the infamous Tom Cavanagh.  Tom is an old friend that I discovered recently is also an author, and a good one at that.  It is no surprise that I picked up this one as soon as I finished Zoe's Tale. 

Mike Garrity has a brain tumor.  He calls it Bob.  And so we meet the main character of Tom's darkly humorous crime novel set in the Central Florida that I grew up in.  Mike is asked by an old colleague from the police force to find a missing member of a up and coming boy band.  With nothing better to do than feel sorry for himself and his mortality, he takes the challenge.  Mike finds himself deep in the middle of a dangerous manhunt as well as surrounded by people who truly care for his well-being.

Head Games is better than Tom's first book, which shows that he is definitely growing as an author.  His dark humor shows in more subtle ways this time around, and again, his locals view of Orlando is very amusing to me.  I am glad that Tom is doing well, and hope that this is just the beginning, if the least reason is for my own amusement.  Great job once again, Tom!

This is a novel approach:  Take your last book, which was really quite good, and retell it from the perspective of a supporting character.  Scalzi's latest book, Zoe's Tale, does just that.  What's more, the supporting character is the sarcastic teenaged daughter of the protagonists in The Last Colony.  Of course, being Scalzi, I ordered and read it in hardcover.

This is the parallel of the last book in the John Perry storyline.  Zoe is the adopted teenaged daughter of John Perry and his ex-SpecialOps wife Jane Sagan who are asked to be the administrators of a new colony.  She must leave behind everything she has known, again, because the colony, named Roanoke, will be hidden, or lost, from everyone.  She must survive with the rest of the colony as the Conclave of Worlds comes after the colonists to destroy them for violating their non-compete edicts.  Oh, and also needs to deal with an entire race of aliens who hold her in the highest reverence for the acts of her biological father.

If you have not read The Lost Colony, do not read this book.  I could only imagine what it must seem like to a non-fan.  It does stand alone, but is not the voice of John Scalzi at his best.  It is, however, extremely entertaining to one familiar with the storyline.  Zoe is sarcastic, cynical, cruel in a teenage-girl way, and very funny.  She is a very endearing character to someone who appreciates some of those qualities.  This may be a fan-service book, but I am very happy to have it in my collection.

Ok, I broke my own cardinal rule of weblogging:  I removed content from this site.  Or rather, suppressed it.  But since it is *my* rule, and I had good reason, I can do that. 

Three weeks ago, I was laid off from my job and needed suddenly to find gainful employment.  Fortunately, I was already on the market anyway, but I wanted the FWHagen.com domain to reflect professionalism as much as possible.  The Subversion/VS.NET article I posted was great for that, however, the two entries above it were book reviews.  So I hid them.  DasBlog makes that very easy in the way that it stores content.  I merely moved the days entries and they were gone.

Today, I started my new job and I have moved the entries back.  Ironically, I have one more book to review tonight, and another this weekend, so it gets worse.  BUT, I am excited about my potentials at the new gig, and anticipate much more technical stuff later.  I am actually going to get to write Real Code!

I am very excited about this book!  I don't like murder/crime mysteries, but this one is different.  (Disclaimer:  Tom Cavanagh is an old friend of mine, so my opinion may be a little skewed!)  When I found out that my old friend Tom is now an author, I didn't even hesitate to order this book.  How could I not read it?  I'm even going to post a link to his website:  http://www.thomasbcavanagh.com/ 

Murderland is a story of Central Florida (where I spent 20 years), Theme Parks and tourists (where I spent 3) and murder.  Kevin Lonnegan is an ex-cop turned private investigator who is asked by a old friend to investigate a pair of murders at the Empire Realm theme park.  His friend is also an ex-cop and happens to be head of security at said theme park.  Lonnegan is called in discretely because the head detective from the Orange County Sheriffs office is a former colleague of both of them whom they have little more than disdain for.  So he goes under cover picking up clues that could endanger his life and that of his new friend Sheila with whom he struggles to figure out his own feelings for in the wake of his young wife's tragic death.

Ok, I started reading this book only because Tom wrote it.  I then found it to be very amusing from an setting perspective.  Tom lives in Orlando, as did I, and it is very evident in his writing.  There are many insider references to the area, that Tom does a great job of exposing to the reader.  And it seems to me that he did an excellent job of describing the theme park that is NOT Disney World, but certainly is to me!  Suddenly, I discovered that I really cared about the characters and settled in for a very fun read.  Only took me a few days, which these days is remarkable!  Turns out, I really enjoyed the book!  I don't know if it's a great mystery novel, for I am not the one to ask about that, but I know what I like. 

I wish Tom the best, and many more novels (he already has 2 more).  It is my hope that he become bigger than some of the less deserving authors I have read...  And continue the poking at the mouse!  I LOVE it!