Archive of ‘geek’ category

Flour

Because we don’t have our own place or any jobs yet I’ve been thrifting it up a bit in the kitchen. Otherwise known as cooking like a povo/1940s housewife. The food I have been making is weird to me and to be honest I’m a terrible cook so a lot of it has been very average. I wish you could just bake everything.

I made the weirdest sauce ever to go with this roast chicken last night. All I have is wholemeal flour, rice, pasta, tiny bit of butter, milk and some vegetables and meat. So I did the roast with some roast carrots, haha, and it was looking pretty disturbingly bland. So I thought I would make gravy, but I couldn’t because a) I hadn’t made the chicken stock yet and b) wholemeal flour does not a good gravy make. So I did white sauce with wholemeal flour lol – I liked it, tastes like a mix between bread sauce and white sauce haha both of which I love but have never made myself.

What other weird things have I done… oh yeah.. hot chocolate with wholemeal flour – HAHA – do not recomend, rice pudding with evaporated milk, porridge with evaporated milk, and washed so many freaking saucepans because there is no dishwasher and no microwave, ahhh, so not used to having to actually do this stuff myself lol.

Anyway most people would probably be a bit disturbed at what I have been cooking but Jonnos pretty good and takes it in his stride although I do wonder what he is thinking haha. I have done some baking and did a batch of cocoa brownies with a layer of ganache which were proclaimed the best ever, made with wholemeal too although you couldn’t tell.

Oh yeah I have been epicly sick so been in bed all day, browsing ASOS.com, learning ASP.NET, reading food forums, deafening myself with dance music, you know the usual. I really need to find a wallet and I am scared of how cold it is going to get and how little warm clothes I have. Never fear. I will survive.

xx L L

Bye bye

Bye bye to my work and my workmates.. it has been cool working with everyone from BCM.. I certainly have learnt a few things that I will take with me ;).. hehe… I will miss you all.

byebye
byebye2
byebye3

What happens when you delete the default database for your login (SQL05)

Well you can no longer connect to SQL Management Studio. In my case I had detached the default database for my user, and was now getting the error:

Cannot connect to ..
Additional information:

Cannot open user default database. Login failed.
Login failed for user ‘Laura’. (Microsoft SQL Server, Error: 4064)

Solution: (Vista, XP similar)

  1. Open a command promt (start, type cmd)
  2. Type sqlcmd in the command prompt. You should see an error saying basically that you cannot open the user default datacase (Msg 18456)
  3. Type in: ALTER LOGIN [USERNAME] WITH DEFAULT_DATABASE=master
    GO
  4. This should set your default database to master and you will then be able to open SQL Management Studio.
  5. Alternatively, open SQL Management Studio, and in the connect to server dialog press options, and then type master into the connect to database: textbox.
  6. You will then have to create a new query and execute the following text: sp_defaultdb ‘USERNAME’, master

SSIS Send Mail Task Useless Error messages

I have spent ages trying to figure out why I am getting this adequately useless error message:

Error: 0xC002F304 at Send Mail Task, Send Mail Task: An error occurred with the following error message: “Failure sending mail.”.
Task failed: Send Mail Task

Msdn provides a list of Integration services error and warning message definitions here, but check out the definition for this one:

DTS_E_ERROROCCURREDWITHFOLLOWINGMESSAGE An error occurred with the following error message: “%1”.

Wow.. an error occured with the following message, failure sending mail, so amazingly descriptive.

Anyway you know you are doing something severely wrong when you do a google search on SMTP Error: 0xC002F304 and only get back about 2 releveant results, and sure enough I was doing something majorly wrong.  Eventually I got so frustrated with the Send Mail task and its complete lack of error debugging information I decided to use the script task to see if that would give me any more.

So I added a new script task and ew put some VB code in and that gave me a different error that was no more descriptive than the last. Anyway that motivated me to open Visual Studio and try the same in goold old C# and sure enough…

sendmaill

My SMTP server was unable to relay to the recipient I had chosen (my personal email). Switched it to my work email and BOOYA all go.

TechEd 2008 Schedule Builder up

Log onto the NZ CommNet site by going to http://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…

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

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 😀

dulce de leche fudge brownies.

Studying for exams puts me in 2 moods. Grumpy being the main one, I severely dislike my after-work free time being taken up by reading code and cramming in properties/method names I will possibly never use. Hungry a close contender – a problem easily resolved by a spot of stress-reducing baking.

(more…)

wse 3.0 good times

Im having issues with .NET 2.0 WSE 3… My web services respond fine to one client but not another. Both of which are on my local machine. So you think it would be an easy fix…

The request failed with HTTP status 415: Unsupported Media Type.

I have seen all the advice saying to add <soapServerProtocolFactory type=”Microsoft.Web.Services3.WseProtocolFactory, Microsoft.Web.Services3, Version=3.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35”/> to web.config… But my configs are all looking good so what gives.

Well it appears it was something funky to do with MTOM – I had MTOM settings off on the client and on on the server. Switching it off appears to have worked :)

mtomissue

Now onto the next issue. Sigh. Do not install .NET 3.5 if you still need to publish .NET 2 Web Services….epic issues ftl.

sotware engineering and cupcakes?

I have been wasting time/self educating myself on all sorts of random things today.. wordpress, css, a bit of study for my Microsoft 50-236 exam, SLR’s, organizing my recipe collection when I think I have made a bit of a discovery…

i think there is some kind of link between baking/cupcake decorating/general awesomeness and being a female software engineer/programmer/real life girl geek. for my proof i bring you the all round greatness of:

hellonaomi
chockylit’s cupcake bake shop
the cupcake fairy

and im sure there are probably more. weird. very weird. anyone care to psychoanalyze?

windows vista mce remote control, good times

Well having just spent 5 hours of my life trying to work a Vista MCE remote I am asking myself why, why did I not research this more before I did it. Sigh.

I bought the Hauppauge PVR150MCE edition. Why did I not just get the normal edition? I think the name sounded cooler at the time or something. Sigh.

(more…)

1 2