Brad and I are just sitting in the airport enjoying a coffee before the flight. It's been a hard week - getting up at 6am to ensure we were at the first session on time, six 75-minute sessions a day and some sort of event in the evening to make us late back to the hotel. Has it been worth it? Of course - the main points to take away are:

Don't use .NET remoting - its slow, won't interoperate and will be eventually deprecated.

Use ASMX and/or Enterprise Services instead - a lot of work has gone towards making them highly performant and scalable.

SQL Server 2005 is comming - its going to both make your life easier and, if you're an ISV, trample over your business model. Time to look for that next pardigm shift.

Microsoft are getting even more into the developer tools arena - enterprise source and project control, integrated testing and code coverage tools, also code checking and verification tools. I spoke to both Perforce and Compuware to try and get their point of view and see how worried they were.

Compuware trotted out the company line that they have always built on top of what Microsoft provides and will continue to do so.

Perforce were not quite so upbeat - their response was more of a "lets wait and see what Microsoft ships". They made the point that they have probably the fastest source control tool on the market and wonder if Microsoft can match it. They also showed me some new visualizations they are developing related to how the code changes over time - colouring lines based on how old they are. It looks a useful method to find out how a file has evolved.

Two words - "Database Mirroring"... Almost instant stand-by with very fast (~3 seconds) automatic or manual fail over. The client libraries also detect and fail over automatically too. To ensure this happens correctly a third server called the "Witness" provides majority logic to ensure that only a single side is up at any one time. I also get the feeling that Microsoft would prefer you to not attempt to use replication as a fail over solution as there are a number of issues to overcome - data loss, client fail over, recovery and the amount of custom code required to make it work properly. One thing you can't do on a mirror is use it. Kind of obvious really, but you can't even connect in a read-only mode.

Help is at and though - another interesting feature that will be available is a "Database Snapshot" which uses copy on write semantics to provide efficient views of a database at a point in time. A snapshot does not need to copy the database as it will reference the original database pages until they are modified. These snapshots can be created on mirrors which provide ideal access for reporting. Those that have all their data stored in a single database may want to think about splitting it into reporting databases and online databases. Basically, stick the information into a reporting database but keep the OLTP and application runtime data in another.

One last honourable mention is for SNAPHOT ISOLATION LEVEL - similar to Oracle's row versioning. But remember that tempdb is used to store the version information whilst a transaction is in progress.

Data Transformation Services been completely re-written for SQL Server 2005. The main difference is the separation of workflow and dataflow. But additional niceties include for/foreach looping, debugging, and OR constraints which mean daft hacks are not required. In fact modifying the package at runtime is impossible.

The new dataflow pipeline deserves a special mention as its no longer one row in one row out. The transform can consume data from multiple sources and send to multiple destinations in a single task - this allows for some interesting merging and splitting of data. Set operations are also supported - sort, aggregate,  split, multicast amongst others.

DTS has grown up and can play with the big boys. If DTS 2000 is not enough for your needs right now then consider waiting for SQL Server 2005 and not trying to implement yourself.

Our free 'gift' was an African drum. To warm everyone up for the key note they had a drum band lead the entire set of delegates in a mass drum session. So 45 rhythmic minutes later with arms about to drop off; the session started.

I plan on seeing the following sessions, but as usual things will probably change.

Tuesday:
12:00-13:15    DEV381    J2EE & .NET Interoperability
14:45-16:00    DAT313    SQL Server 2005: Data Transformation Services
16:30-17:45    ARC402    Data in Services-Oriented Architecture
18:15-19:30    ARC302    Metropolis : Building Applications in the Service-Oriented Enterprise

Wednesday:
08:30-09:45    ARC307    Realizing Services-Oriented Architecture
10:15-11:30    ARC220    New Developments in Microsoft Solutions Framework
12:00-13:15    DEV301    Visual Studio 2005 Team System - Part 1
14:45-16:00    DEV302    Visual Studio 2005 Team System - Part 2
16:30-17:45    DAT328    SQL Server 2005 : Inside Analysis Services
18:15-19:30    DAT323    SQL Server 2005: What's New in Replication

I would love to see this as well, but Analysis Services comes first...
16:30-17:45    DEV303    Visual Studio 2005 Team System - Part 3

Thursday:
08:30-09:45    CTS300    Prescriptive Guidance for Building with Web Services
10:15-11:30    DAT315    Intelligent BI - Integrating Data Mining into OLAP, RS and DTS in SQL 2005
12:00-13:15    DEV307    21 Rules of thumb - how Microsoft develops its software
14:45-16:00    DAT431    High Availability Technologies in SQL Server 2000 and SQL Server 2005
16:30-17:45    CTS304    Availability and Reliability - Failure Is Not An Option
18:15-19:30    DAT325    SQL Server 2005: SQL Service Broker

Friday:
08:30-09:45    DAT437    SQL Server Analysis Services 2000: Solving Business Problems using MDX
10:15-11:30    ARC406    Understanding the Grey area Between Service and OO Design
12:00-13:15    DAT329    SQL Server 2005: Web Services
14:45-16:00    DEV413    ASP.NET: Tips and Tricks for Building Server Controls
16:30-17:45    DAT335    Business Intelligence using SQL Server Analysis Services and Office 2003

I've finally managed to get TechEd sorted and paid for so I'll be in Amsterdam on Monday. I must say a big thanks to Tim Sneath helping to expedite things.

I wasn't very happy with the clunkyness of blogger, so I've moved over to dasBlog. But due to some constraints from hosting service, I have to move to the root of the site: http://www.jamessnape.me.uk/default.aspx. Hopefully this is the last switch.