Finding Version of SQL Server

Always forget what number is what version of SQL Server so here’s list of the ones I commonly run into SELECT SERVERPROPERTY(‘ProductLevel’)GO or SELECT @@VERSIONGO SQL 2005 Release 9.00.1399.06SP1 9.00.2047Hotfix918222 9.00.2153SP2 9.00.3042 SQL 2000 release 8.00.194sp1 8.00.384sp2 8.00.534sp3/3a 8.0.760sp4 8.00.2039  

Continue Reading

Tech.Ed – Some pics

I didn’t take my 350D to Tech.Ed with me cause I didn’t feel like lugging my camera equipment around with me, so we took the old 2 MP Canon IXUS.  Unfortunatly i couldn’t find the charger before we left, so only got to take 1 photo with it.  We got our pici taken with my…

Continue Reading

Tech.Ed – the arrival

We musta picked a good time to fly outta Brisbane (or maybe it was just cause it was a Tuesday)  but we made great time to the airport, plane wasn’t too crowded and got a cab pretty quick.  Got to the hotel, and realised we were in a different class of hotel straight away, when…

Continue Reading

Off to Tech Ed

 We’re off to Tech Ed in Sydney tomorrow afternoon, for 3 jam-packed days of information overload.  So probably no news from us till next week.  Hope to catch up with quite a few people in the next fews days.  Looking forward to it.  See a few of you there.

Continue Reading

List T.Find

When i started using the finder in the new generic lists I couldn’t find a good e.g of how to write the find function.  So here’s a cut down version of one that i ended up writing. First I needed a class that could work out if a supplied item was equal to something in…

Continue Reading

Disappointed with the Census questions

 I must say I was disappointed in the variety of questions asked in the census.  Wasn’t feeling like the census wasn’t really aimed at me.  There was one question about transport and that only related to how you get to work and maybe could count the question about the number of vehicles at the house.  There was…

Continue Reading

Fun with eCensus

After discovering I could complete my census form online, I was happy for both me (I hate filling out forms) and the people who have to read my scrawl.  So I log in and fill out the form and get to about the 2nd last question (think it was the number of bedrooms question) and…

Continue Reading