Erection dysfunction substance is often a name which 7drugs priligy Priligy kostar

Cialis is finding progressively more takers due african mango African mango results to its great capacity to cure male Electronic cigarette price Electronic cigarette china impotence and activate Mail order viagra without prescription Viagra questions libido. If you're out to Human Growth Hormone Human Growth Hormone

In Where can i buy viagra Buy viagra online at the usa on your own, you'll find 16 Viagra samples Buy viagra online without prescription to 25 zillion American adult men that Potent levitra Levitra suffer kind impotence of male impotence. Several of Free cialis Indian cialis these Buy cheap levitra xanax xenical Buy levitra at a discount men Buy cialis online in missouri Buy cialis online in missouri

There are various individuals Raspberry ketone extract for sale Raspberry ketone supplement sale

TechEd 2008 Schedule Builder up

August 12th, 2008 § 0 comments § permalink

Log onto the NZ CommNet site by going to www.msteched.com/newzealand

Start building up your TechEd schedule :) I’m sturggling like last year to choose between some Architecture tracks and the Development ones. I will post up my schedule later once its complete.

And of course don’t forget to nag the token female at your work for invites to the Girl Geek Dinner on the monday night. Mmm. The food was good last year…

butterscotch pecan cheesecake

August 11th, 2008 § 2 comments § permalink

Pecans and Butterscotch have never really appealed to me, but somehow this recipe did…

I have never ever made a cheesecake before, shock horror, and so I have no idea whether or not this is going to set. Not only that, but I screwed up my oven timer melting butter for the banana cake I was making simultaneously and so I have no idea how long I baked it for. Stay tuned for is it set… /edit: it set perfectly :)

» Read the rest of this entry «

sending mail for each row in a table (SQL 2005)

August 8th, 2008 § 18 comments § permalink

You would think this would be quite a simple task right. It probably is if you are some SQL guru I imagine, this whole sending mail from a db is a new concept to me, and I may have missed something very basic (wouldn’t be the first time, and certainly not the last).. it does not seem to be all that straight forward.

My first thought was to go with Database Mail. Well, Database Mail is nice enough, I set it all up nicely following the msdn walkthrough here, the test email fired off fine.. I thought all was good and well until I thought my problem through a bit further. I will have a recordset where each row is associated with someone to email with information in that row. So to use the sp_send_dbmail procedure would involve some kind of cursor/crazy stored procedure that I just wasn’t all that keen on writing. Like I said. Im no SQL guru.

So then one of my collegaues said what about Notification Services. I thought, hey cool, I love the BI tools that come with SQL 2005 (especially reporting services <3) and Notification Services I would love to learn about. So I spent 20 mins googling it and then I find out Notification Services does not ship with SQL 2008. Well that kind of pissed me off a bit because I didnt want to implement some solution that would get scrapped in a few months when we upgrade to SQL 08. Not that my workplace is likely to do that anytime soon.. haha.
Anyway, so then I discovered this awesome, and I mean awesome tutorial that basically explains to do exactly what I wanted. One thing I have learnt though, is that delaying validation on the send mail task will allow you to set the ToLine property using an expression. This is the perfect solution for my problem, and means that for every row in the table/recordset I can send a new email to the required person with information from that row.

Send Mail Task Editor To Line Configuration

Another caveat was that to get exchange to act as a SMTP relay so you can fire off the Send Mail task you need to tweak the default settings a bit. The official word on how to do that is here, basically just add the IP address of your Exchange server to the Relay settings in your exchange system manager.

Now I can spam emails to my co workers when I test this on Monday :D

chewy chocolate cookies

July 26th, 2008 § 0 comments § permalink

250g softend butter
1 tsp vanilla extract
3/4 cup caster sugar
3/4 cup brown sugar
1 egg
2 cups plain flour
1/4 cup cocoa powder
1 tsp baking soda
400g any kind of chocolate chopped up.

preheat oven to 180 degrees and line oven trays with baking paper
beat butter/sugar/vanilla/egg with eletric mixer until light and fluffy.

stir in flour, cocoa, baking soda. stir in chocolate

roll tablespoons of dough into balls and place 5cm apart on trays, bake about 12 mins and cool on trays.

variations: add a handfull of sliced toasted almonds and 1/3 tsp almond extract.

kitchen kaos [old]

July 20th, 2008 § 0 comments § permalink

found proof that this is what happens when you make 2 sets of cupcakes and a salad in one go in my tiny kitchen.

most awesome collosal mess. link to full size pics here