Adam presented on the challenges of implementing changes on databases.

 

One thing you can say for Adam is that he talks from experience i.e. his company has been around for almost 20 years and developing and delivering systems.  I agreed with much of what was presented.  The point of these sessions is to discuss not agree.

A good session.  Shows how important SSIS is these days.  I like his reference to cache tasks.  Always good to walk away wanting to use something new.

Grant is still looking for an acceptable acrostic for his S.P.E.R.M. reports.  In fact they do look like tadpoles but even more impressive is the logic behind his reports.

 

Quite a presentation.

 

Linking and Presenting analysis services data.

Really good session on the basics of DBA. 

 

Code camp has done well to balance presentations on basic skills with flashy stuff.

 

A great guy to visit in Hawaii

 

 

This is my second time for this session and still it is fresh.

 

This is a guy that really can't be missed.

Julia Heather is covering Database Mirroring.  Julia is raising quite a level of discussion.  Julia works for Dimension Data.

 

A good session.

You can do a masters at CSU based on a Microsoft DBA or developer certification.  Or even an IT management certification.

Rob is doing well to comment on using functions.

 

The begin end implies that the function is really a procedure.  Though scalar functions do require the begin and end.

Here we are in a totally inadequate room for the SQL track launch.  We are full and people sitting on the floor.  Probably some questions to be asked.  Mind you I am looking at Kamal Hathi one of our international speakers happy to sit on the floor and watch the presentation.

 

We are doing a session on what will be in SQL 2010. 

 

Gemini an excel analysis tool.  An in memory BI tool.  This one will be popular.

 

Demo to expose to Sharepoint within sharepoint services.  Use it as a data source.

 

Application and Multi-server Management.  DAC Data-Tier Application Component.  Looking at taking large scale SQL server management to a new level. Something tasty for the dba with large no of instances.

 

Looking at pretested "Fast Track" DW kit.

 

Looking at scaling out parralelism on multiple servers.  This is a big move.  Including Auto Partitioning and replication. Handled in the create database.  100TB 128 node system at Redmond.

 

CEP Complex Event Processing.  Continual stream processing.   TP monitor for handling large scale throughput.

 

 

 

Here we go.  The keynote is under way.  I had to be responsible last night as I was preparing my slide decks for my labs and sessions.

 

DTL17 What's new in C# 3.0

BIN05 Authoring Reports using Microsoft SQL Server 2008 Reporting Services Report Builder 2.0.

BOF09. MDX Q&A with me, Darren Gosbell and Grant Paisley

 

HP guy spoke well. 

OK a microsoft guy has stripped from PC to Windows 7 PC and I mean his clothes.

In memory of my Dad Richard John Orr who passed away yesterday after being hit whilst crossing the road.

 

My Dad was on his way home from playing Bridge his favourite passtime and had just had a nice call from my Mum who was on her way to collect him.

 

We spent a few days together last week as I flew to Hawaii to collect Mum and Dad off a cruise and bring them home.

 

I am surprised at the depth of impact I feel as you think you are prepared as your folks get older.

 

Richard John Orr was a good man with family that were happy to be associated with him.  He was much loved and will be remembered by many.  He had a brilliant mind and was an accomplished engineer and town planner.

 

He had 4 children and 8 grand children.   He was a first grade rugby player and manager for St George.  He was a master at bridge and is sorely missed.

 

Part of me goes with you Dad.

So here is why I got a 29110 error.  TFS 2008 was released before SQL 2008 so it does not support SQL 2008.  However TFS sp1 does.

 

But there isn't an integrated install for sp1 so you have to build it yourself.

 

The basic idea is that you take your install, run a merge with sp1 and generate to a separate directory and then copy it back over the top of your original install.

 

Here is the blog entry that helped though the details are in the TFS help.  I got stuck on accessing the help for a while as I forgot to access the file properties and select unblock.  The web content is blocked by default.

 

 

 

 

Spare me.  I mean how hard can installing TFS be.

 

I worked out my SQL connectivity and my Analysis Services Connectivity.  I installed Reporting Service cool and passed the validations.

 

Did it work, no way.  Error 29110 Reporting Services .... blah blah.

 

My google is burning with the issue but what is the problem.  Stay tuned.

Rob is demonstrating that he really  knows his way around a database execution plan.  His presentation is good.

OK its time  we get into this.   Greg is introducing the subject and Dave Lean is taking it on.  In this case I am a bit nervous of getting involved but I think this will move from scary to standard in the near future.  Bring on Dave's session.

Here we are in Wagga.  At least 100 people getting together in Wagga Waga to talk SQL.  Greg Low has put this all together. I'm giving the refined version of MDX for a SQL Dude course.

 

I'm looking forward to learning and hanging with the dudes and dudets.

Recently I have encountered the Generate Command.

 

It applies a member based set function with a set and then unions the result.  So the following is showing the parents of an Owner based on the Property Owner Lan ID but in this case we don't want the actual member but the parent i.e. the Sales Centre of the Owner where Owner is a Parent Child relationship,

 

 

Adam Cogan and Justin King present the differences between nHibernate and Linq to Entities.

 

It was a great session but every database guy in the house cringed.

It almost requires you to not use stored procedures ever again.  We didn't even attempt to review the quality of the SQL output.

 

Linq came out on top for functionality but some cried foul.  This will be extreemely productive for developers but once again we seem to be focusing on speed of development rather than quality of the outcome.

 

Greg Low talks date issues.  This session is unbelievable.  That after the Millenium Bug debacle we have loads of problems with dates is Bizare.

 

Here is a takeaway use YYYYMMDD as it is language independant but YYYY-MM-DD is not.

 

 

Jonas Folleso

 

So Jonas has shown us Silverlight.  I could really get into this.

 

I mean here is a web based interface that actually looks in control.  OK so flash has done it for years but this is a Microsoft product that could get me excited about web stuff again.