Guess who’s pregnant?!
Yep, Carol and I are expecting Pedro 2.0! We found out this past Thursday. The baby is just 4 weeks into the making so it looks a bit like this right now:
This is still very new for us, we’re excited but we really don’t know what to expect. Carol made her first appointment with the doctor today, they want to see her when she’s 8 weeks into the pregnancy. Right now the only thing she is doing different is taking prenatal vitamins.
We’ll keep you guys posted!
Vegas!
Carol went to Vegas on business and I tagged along for the ride. We went to the grand opening of Folio, a furniture manufacturer from Canada. We took a tour of their manufacturing plant and showroom with their products.
This time we wanted to take it easy and we didn’t plan enough in advance to go to any of the major shows. We stayed at The Mirage, their pool is awesome. I liked that they had a ton of chairs around the pool so you never had to be hunting for one.
We’re really not huge gamblers so we ended up betting less than $5.
And we couldn’t drink alcohol so we only drank a ton of Smoothies from the Blizz yogurt shop at The Mirage, they were awesome!
Bittersweet ride to work, summer is fainting
This morning’s ride to work had the perfect temperature! It began a tiny bit chilly when I got out of my garage, after a mile I got warmed up and felt perfect. I broke a sweat after a while but that’s alright I prefer that than starting the ride colder. The temperature was absolutely perfect.
Now the bitter part is that summer is on it’s downfall. Two weeks ago there was no way you would get temperatures like this morning. Winters really suck around here.
My international friends might need some more detail about why winter really really sucks around here: The sun comes out late like at 8am and sets early around 5pm. Meaning you only have daylight from around 7am to 6pm, after that it’s really dark. All the daylight time is during work hours.
Run #2, no pain!
Ran 2 miles on thursday, no pain. Ran 2 miles today, no pain … I’m still taking the prescription anti-inflammatories though. So I need to be extra careful until I’m out of that.
The plan is to run another 2 miles in the next 2 or 3 days. After that I’ll go for two 2.5 mile runs. Then I’ll do four 3 mile runs… we’ll see how that goes.
Also, I went rafting in Idaho this weekend, will post something as soon as I have some pictures.
Kings of Leon Concert
The concert was yesterday and the gang was there. We got lawn seats for the ultimate laid back experience. Even though it was a Monday night, I had a great time.
MS SQL: Get returning data type info of a query
For years I’ve wondered if there’s a way to get the returning data types of a complex query or a stored procedure in Microsoft SQL Server. Something like:
sp_get_return_type_info select firstname, lastname from [user]
OR
sp_get_return_types StoreProcNameHere
I’ve done quick google searches for this many times in the past and this time I really dug deep. I mean like 3 hours deep just on this. And sadly, I could not find anything like that!!
But I did get something good out of this and I don’t want to forget it. I wondered how Visual Studio figures out the returning data types of complex queries that are added to a DataSet. So I ran the SQL Server Profiler as I was adding a new TableAdapter and I saw that they are also not using any magic sp_* call. They use this query to get the datatypes of each of the joined tables:
select col.name, st.name as DT_name,
case when (st.name in ('nchar', 'nvarchar') and (col.max_length > 0))
then col.max_length / 2 else col.max_length end as max_length,
col.precision,
col.scale, bt.name as BT_name, col.is_nullable, col.is_identity,
col.is_rowguidcol,
OBJECTPROPERTY(col.default_object_id, N'IsDefaultCnst') as is_defcnst,
CONVERT(bit, case when(cmc.column_id is null) then 0 else 1 end)
as is_computed,
case when(cmc.column_id is null) then null else cmc.definition end
as formular,
col.collation_name, col.system_type_id
from campusvue_train.sys.all_columns col
left outer join campusvue_train.sys.types st
on st.user_type_id = col.user_type_id
left outer join campusvue_train.sys.types bt
on bt.user_type_id = col.system_type_id
left outer join campusvue_train.sys.identity_columns idc
on idc.object_id = col.object_id and idc.column_id = col.column_id
left outer join campusvue_train.sys.computed_columns cmc
on cmc.object_id = col.object_id and cmc.column_id = col.column_id
where col.object_id = object_id('TABLE_NAME') order by col.column_id
It’s just a nice join to have handy.
And VS is not able to figure out the datatypes of a table returned by a stored procedure. I tested this on a stored procedure that returned a select on a table variable as opposed to returning a select that came entirely from a normal database table; maybe it supports that, but I doubt it.
Finally went kayaking on Daybreak Lake
For those of you that didn’t know, Daybreak has a man made lake:
The lake is maintained by the HOA (Homeowner’s Association) which is funded by all daybreak residents. The lake goes around this island where lots are being developed; I’m sure they will be pricy! Another cool thing that the HOA covers is free kayak checkouts for residents. And we finally took one out for a ride:
The weather was great for doing this. It was a warm day but the chilly water cooled you down beautifully.
Dining room update
I had a serious debate about whether or not I should blog about curtains! Because that’s really what I’m doing here … But I know my family wonders about my new home and some friends wonder about it too so here it goes…
We finally installed some curtains on our dining room. Check out the before and after pictures:
Actually the “before” picture already has the gray accent wall. That wall was beige like the side walls. We painted that a couple of weeks ago when we started painting the garage. Which reminds me I need to document the garage project for you guys.
Carol wants to change the light fixture and the table (or maybe just stain it darker). But we have soooo many more important things to do around the house that we agreed to leave those little things for the very last. Which means it will be like that for at least a couple of years =)
30+mile epic mountain bike ride
Daren and I pushed our limits yesterday on an epic, cross mountain, 30 miler!
The day that we really need our GPS watches, we forget them =(. I mapped the trail out by hand and it turned out to be 30 miles long. But when you map things by hand you usually cut corners so it’s probably a bit more than 30 miles.
We started at the bottom of puke hill, then went to the crest, headed towards Mill Creek canyon but then turned right towards The Canyons ski resort. We stopped for lunch there at the Red Pine Lodge and took the mid mountain trail to the Park City ski resort and then headed back to the other side of the mountain where we parked the car.
My right hamstring was close to cramping out, Daren’s quads totally cramped, we had multiple chain breakings, we got lost … all the ingredients of an epic ride. It’s fun pushing the limits every now and then!
Modest Mouse concert yesterday
I was there and it was awesome! They played a ton of good songs amongst them my favorite: Third Planet.
