My TechEd session Ready for download

My TechEd session on Delivering an End to End Business Intelligence is now up on Microsoft for download.

Check out: BIN213.ppt

New Zealand TechEd Is Finally Here!

TechEd 06 has been a sold out event for a number of weeks now. It sold out in record time. For those you that are not aware, Microsoft NZ TechEd is the largest annual IT conference in New Zealand with over 2000 delegates attending.

This year I am presenting again. I am lucky enough to have one very comprehensive session on Business Intelligence.

BIN213 - Delivering an End to End Business Intelligence Solution on Monday 21st Aug 2:00:00 p.m. to 3:15:00 p.m.

My session is going to cover a detailed overview of implementing Microsoft Business Intelligence solutions. I am covering topics such as SQL Server 2005, SSIS, Analysis Services 2005, Reporting Services 2005, Office 2007 and ProClarity.

I am also looking at the business reasons behind BI projects. In the demonstrations I will show an integrated architecture for a Microsoft BI platform.

Ok it’s a lot to cover. So I will also be about on the HP stand this year to go through any questions or demos you would like to discuss in detail.

If you have registered for TechEd you need to login to CommNet and book your session schedule.

For complete schedule information see Nigel Parkers Blog

TechEd 2005 Auckland NZ Session slides

Hello,

My session slides have now been posted on to ww.microsoft.com

For my session on Analysis Services 2005 migration tips see:

http://download.microsoft.com/download/0/9/b/09bb6510-535a-4fe6-be02-8af8762b0acc/SQL312.ppt

For Ad-hoc reporting with report builder see:

http://download.microsoft.com/download/e/2/6/e2631eea-9a8d-484c-ba43-ac2e5be86396/BIN316.ppt

\Myles

TechED Photos

Hello All,

Mark who attended my morning session has sent me some pics of me getting ready for the migration to AS 2005.



Thanks Mark.

\Myles

What I got out of TechED

Wow TechED is over, three days of sessions and two presentations of my own. It was a full on event for NZ IT scene.

Besides presenting at TechED I did get to a couple of sessions. Looking back at them I took something from each session, listed below are my thoughts.

BIN301- Cube Design in Analysis Services 2005 - Best Practice for Performance and Functionality - Richard Lees.

This was the only session on AS 2005 that I was able to attend this year. Richard covered the UDM in detail and gave us a run of all the client tools for AS 2005. The best was the review of the proactive caching for loading cubes and the use notification services for automation of cube processing.

The UDM really does have a large amount of features around query performance. Something I am going to look into in more detail on this blog at some stage.

BIN310 - SQL Server 2005: End-to-End Part 3 (Analyze and Act) - Thierry D'Hers

It was great to get to meet Thierry. I spent a bit of time with him on is brief say here in NZ. His insight into the direction of the MS BI platform was very informative. Thierry’s session reviewed all the SQL 2005 features with a take on MS direction for the product range.

DBA313 - Architecting a Large Scale Data Warehouse with SQL Server 2005 - Doug Barrett

Doug took us threw some of the key DW features for creating a DW on SQL 2005. The session was more of a traditional approach to DW architecture. He cover table partitions and loading with SSIS packages.

I realy feel that any new BI projects on the MS platfrom will be based around the UDM.

Microsoft is going to post all TechED presentations on their NZ site latter this month. I will post a link to these sessions on blog.

Till next time

Myles

What I am going to see at TechEd 05

Hello All,

Well its 17 days out to New Zealand TechEd 05 and I can’t wait.

I know I have not blogged for a long while. This is due to work commitments and TechEd prep. I am still in the middle of a large Data warehouse project. It’s been running for the last 8 months and nearing completion.

There are a few TechEd sessions I am really looking forward to seeing. I thought it would be a good idea to share them with you. Below are the key sessions I don’t want to miss.

• BIN303 - Exploiting Data Mining in SQL Server 2005 - Richard Lees
• BIN304 - SQL Server Integration Services: Deploying, Managing and Loading a Data Warehouse - Tony Bain
• BIN310 - SQL Server 2005: End-to-End Part 3 (Analyze and Act) - Thierry D'Hers
• DBA313 - Architecting a Large Scale Data Warehouse with SQL Server 2005 - Doug Barrett

I haven’t listed the times here as the schedule may change for the latest TechEd schedule see: http://nigelp.members.winisp.net/schedule.htm

Bye for now.

Myles

TechEd 05 Preparation – Project Real

Hello All,

While I am doing prep for TechED 05, I came across a couple of really good public links to project Real. For those of us that are going to be converting a lot of SQL 2000 Clients to 2005 it's on the 'must read list'.

Check Out:

Project REAL: Technical Overview
http://www.microsoft.com/technet/prodtechnol/sql/2005/projreal.mspx

Project REAL—Business Intelligence in Practice
http://www.microsoft.com/sql/bi/projectreal/default.mspx

Happy Reading

Myles

TechEd 2005 Sessions Schedule

Hello All,

My Sessions have now been confirmed. Both sessions are on the last day of TechEd (Day 4: Wednesday 31st August)

I am presenting the following sessions,

9.00am - 10.15am Session 12

Project REAL and Tips for Migrating from SQL Server 2000 Analysis Services to SQL Server 2005


3.45pm - 5.00pm Session 16

Ad Hoc Reporting with Report Builder: Extending the Capabilities of SQL Server 2005 Reporting Services

Check out the link below for the TechEd sessions schedule

http://www.microsoft.com/nz/events/teched/sessions/default.aspx

See you all there!

Myles

TechEd 2005 – Auckland New Zealand

Just a quick post to let you all know, that I am presenting two sessions on the next version of SQL Server 2005.

I will be covering the advanced features of Report builder New in SQL Server 2005. Also I will be covering migration tips from Project REAL for migration of Analysis Services 2000 OLAP cubes to AS 2005.

Once I have a confirmed schedule I will publish my session times.

Myles