Blog ala Vidar

Øystein, which has a 3 months old baby at home is used to get up EARLY. I hoped he would sleep ABIT longer, but that wasn’t going to happen!
At 07:44 my phone called, and woke me up. We agreed on getting to CCIB before 9 to get to the first session; “The Next Release of Microsoft SQL Server: Overview of SQL Server 2008”.
Met a Belgish guy from Microsoft at the hotel and he told us about a much quicker way to get to the Metro. Of course, this way we had to change lanes, and of course walking around the corridores
between the lanes for HOURS. I guess you’d probably found out I’m not a fan of walking by now… Anyhow, swetty and HOT we arrived at CCIB later than expected; 09:10, so we missed the first session 😥
We sat down at the HOL, and took a couple of exercises there. DAT02, 04 and 05, to be precise. I even managed to fuck up the virtual machine, without purpose, and learned once again that not all
spanish can make themselves understandable. Anyhow, after a “fresh air”-sessions (Lithuanian guys know what I’m talking about), we (me and Nils Arne) got to the second session:
DAT309, Best Practices for Optimizing SQLCLR in SQL Server 2005 and Beyond, with Bob Beauchemin
He’s still a great speaker! I’m not going to bore you with 15 A4 pages of summart, so here’s a short summary of the session; If there exists a function for it in T-SQL do it in T-SQL. If not, do it in CLR.
Of course, you can bend this rule abit, but let’s not go into details. For those who ARE interested in details, contact me on MSN next week!
Rating: 3

After lunch, and a quick walk in the exhibition hall, we ended up in room 112:
DAT312, Programming SQL Server 2008, with Carl Perry
Not the best speaker, but he made at least me understand a couple of the new features. Filestreams, new date/time types and table valued parameters.
I really believed tvp’s was available in 2005. Probably mixing 5 and 8!
Rating: 5

I desided to skip the next session (DAT306) since this was about Compact version of SQL Server, in advantage for the exhibition hall. I really love walking around talking geek-stuff.
I bet I could do this ALL week, but I also want to go to some sessions. Luxus problems! I also had time for a couple of HOL, specifically DAT09 and 18 till the others showed up after a WPF session.
I think Øystein is very just as impressed by WPF as I’m with SQL Server!

Next session was in room 117:
DAT315, T-SQL Querying: Tips and Techniques, with Stephen Forte
This must be the most energetic speaker, EVAH. Not only was he speaking about something very interesting for me, he even got Sidsel (one of Ronny’s little helpers) who is NOT interested in computers, interested in SQL Server!
THAT’S impressive! As a wanna-be-some-day-speaker-for-TechEd I’m not only watching the slides, I’m also looking for ways to interact with the people listening, and I think he were VERY good at this!
Enough about Stephen (yeah, we’re on first-names, or at least I am!). He introduced me to a couple of new things I already knew abit about, but had not tried. Common Table Expressions which is almost the same as derived tables,
XML with XQuery and Pivot. I have to locate him this week and have a chat! Also got a question prepared for him 🙂 What’s the difference between CTE and derived tables? Anyone?

Rating: 1.5

After almost 10 hours, we found out it was best to get back to the hotel. Tried finding an ok restaurant, which I thought should be pretty easy. Turns out, it’s very difficult, unless you’re near Hard Rock Cafe. Everything else looks “shabby”.
We eventually found a place, which very very cheap and then headed back to the hotel to debriefe (read: have a beer before bed).

My day started at 8am, when Øystein called; “Nå gidde eg ikkje å gå ront aleina lenger. STÅ OPP!” (English: I don’t wanna walk around alone anymore. GET UP!)

We went down to have breakfast, egg and bacon, and then waited till 9 for the hotel-pool to open. We had packed our bikinies (shorts, for those of you who don’t like the sight of me in bikini), and were READY to take a swim, but when we got to the pool we got disappointed!

It wasn’t big enough for a walrus like me! But, we moved on. Got a shower, woke up Jan Leon and headed for CCIB. Now we knew which metro-station to get to, and where to get off!

We started with lunch (right after breakfast you might ask? Well.. To get as big and strong as me, you have to eat like a horse!) at 11:30. After lunch we had a couple of hours to kill, so we got to the HOL (Self-Paced Hands-on Labs), where they have set up computers in areas for learning different things. The SQL-area was full, so we sat down at powershell. Also VERY interesting, since I’m used to Linux (and console) before starting in Omega. Finally you can start scripting almost like in bash! I’ve missed this. The great thing about HOL is that the computers are set up in a way you can’t do anything else than you’re supposed to (working with powershell), and you’ve got a bunch of experts in all areas!

After about an hour in HOL, we desided to find the auditorium where the keynote speak with CO Vice President of the Developer devision in Microsoft; Mr. Somasegar, were starting at 14:00. He’s probably from India or something. We had some problems with understanding his accent, but understood the point of “welcome to TechEd 2007”. The auditorium was filled with geeks like ourself. I’d guess about 500-1000 geeks! That’s more than we’ve got in Ølen!

After the keynote speech, a couple of smokes and a cup of coffee, we got to the first session:

DAT308, Best Practices for Optimizing Service-Based Code in SQL Server 2005 and Beyond, with Bob Beauchemin (from SQLSkills).

Great speaker! I’d love to have a couple of words with him within this week! He were talking about the Service Broker “tool” in SQL Server, which is like a queue. You can use this to run queries asyncronous. FINALLY WE CAN GET RID OF DO ADMIN JOBS!

Rating: 2.5 (1 till 10, where 1 is best, as always 😉

After a smoke, I got “down to earth” again and we managed to get to another session:

SEP203, Introductory Walkthrough of Windows Communication Foundation (WCF) using Visual Studio 2008, with Steve Maine

He was more of a kind of nerd. Didn’t have 100% control over presentations (when error appeared, he got silent and just tried to fix everything asap zulu, instead of starting next topic.

This was not to interesting for me, as I’m more of a database-dude, but I had at least my eyes planted on the big-screen, trying to understand everything.

Rating: 7

When SEP203 were finished, we went to the opening of the exhibition hall, where we (finally) got some snacks. Got to speak with a girl in MSDN, which actually had norwegian grand-parents. Her last-name was Olsen. Same as Øystein 🙂 Got some free caps and some other stuff, and then went home. We were only three at this time; me, myself and …  No. Øystein and Jan Leon. All of us thought we had sense of direction, but we were proven wrong! We walked in all directions, because each person we asked for directions pointed in different directions! After a while we found out that trying to find the way to Hard Rock Cafe was much easier than trying to find the way to the longest street in Europe! Who would have thought that?! Ended up at the hotel after a couple of hours walk, got a couple of beers and now I’m off to bed! Good night!