Posted on by — Leave a comment

Last week was a fog

So last week, I worked in the yard Sunday and felt my allergies kicking in…so I thought. Went to work Monday but was so ill that by the end of the day I’d left a couple of hours early. Tuesday I was home asleep except for that trip to the doctor’s office. My doctor confirmed…allergies. I think she was wrong. An attempt at work Wednesday failed half way through the day. Then Thursday I was home caring for sick family members. Friday was a half a day of work before returning home for sick family members. It was a rough week.

In all, we had a confirmed virus, three cases of Flu B, strep throat, and two bad coughs all in the same week.

It’s Tuesday and I’m still drained but finally work is starting to flow and items are falling off my to do list rapidly. Things are looking up!

Posted on by — 1 Comment

Date night

DinnerWe are fortunate in that the grandparents are very involved in our children’s lives. They typically take them on Saturday nights to spend time which leaves Cathy and I Saturday nights for quality time and blueberries. Our 22 year old typically spends Saturday playing MMORPGs. Sometimes it is easy to forget he is in the house. So…

Awkward? Loudly declaring, "More handjobs!"
Funny! Realizing everyone on his voice chat probably heard it.

Context? Cathy complaining that she isn’t strong enough to squeeze the foil cutter enough to open the bottle of wine.

Posted on by — Leave a comment

Query of queries reports runtime error

So are you pulling your hair out because your query of queries is returning an error "Query Of Queries runtime error."? The solution is rather simple. In your query that is feeding your QoQ, you probably have a column that is of datatype nchar. Cast that to a varchar and life will be good. Do the cast in the source query not the QoQ. eg. "CAST(foo AS varchar) AS bar" You’re welcome.

p.s. Yes, you can cast it to the same column name eg. "CAST(foo as varchar) AS bar" Case doesn’t matter.

Posted on by — Leave a comment

From the mouths of babes

Me: "Noah, do you want to go to your aunt’s wedding?"
Noah, 16: "Uh, I don’t think so."
Me: "Ok. You’ll miss out on going to King’s Island."
Noah: "Why King’s Island?"
Me: "They live there."
Noah: "They do?"
Me: "Yes. You’ve been there."
Noah: "Once!"

Dad fail! Perhaps I have been a bit remiss in traveling my children. I’m thinking it’s time to plan a vacation.