Sunday, September 27, 2009

Tech Ed 2009 Thank you!

Dear James,

Thank you for attending TechEd 2009!

We really appreciate the effort and commitment that TechEd takes from all of our attendees and thank you for your support during the particularly tough current economic climate.

This year we hosted 128 sessions over 11 tracks and 3 virtual tracks and trust this provided you with confidence in the Microsoft roadmap, and visibility on how Microsoft technology can help to move your business and career forward. 

To maximise your TechEd experience, we are pleased to announce that as a delegate of the event, you will have complimentary access to premium content on TechEd Online. This offers hundreds of hours of breakout sessions from TechEd events around the world and is a great way to check out your favourite session or catch up on any of the sessions you may have missed.  We will notify you by email as soon as your access details have been set up.

Also don’t forget to tell us what you would like to see at future TechEd New Zealand events. Your feedback is critical for our future success so please go to www.msteched.com/newzealand/Public/eval.aspx to complete the evaluation form.  To show our appreciation you will automatically go into the draw to win a HP ProBook 5310. Deadline Wednesday 30 September.

Thanks again for supporting TechEd 2009 and we look forward to seeing you next year!

Kind regards,

Scott Wylie

Director Developer & Platform Strategy

Microsoft NZ Ltd

Training Report

Kiaora Jacinta,

As requested, here is a detailed report back on the value of the training that I received this year at Tech Ed.

Tech Ed is the premiere Microsoft conference in New Zealand.  It runs from Monday to Wednesday, delivering more than seven streams (DEV, DB, Security, Vendor Case Studies, Architecture, Office System, Azure) of simultaneous training from which to choose.  In addition, Code Camp is an optional, extra training day, organised by the New Zealand User Group Community that runs on the Sunday preceding Tech Ed.

Code Camp topics that I attended were:

  • What’s Happening in .NET Languages – An overview of the changes to be expected in Visual Studio 2010.  VS is the development tool that I use all day every day.  Ivan Towlson demonstrated the new Functional Language F#, as well as how the existing statically defined languages (C#, Visual Basic) can interact with them.
  • Behaviour Driven Development – This is an evolution of the formerly named Test Driven Development methodology of application development.  Owen Evans was able to clearly demonstrate the conceptual brilliance of the “Given… When… Then…” paradigm.
  • C#4.0 – Ivan again showed how VS2010 will enable developers to use new dynamic features of our existing static languages in order to “break the mould” of our strongly-typed declarative world.

In addition to attending Code Camp, I also contributed two presentations:

  • Lightening Talk – Data Dude: MS VSTS for Database Professionals (GDR), in which I explained the usefulness of GDR as an optional add-in to the Development Edition of Visual Studio.
  • Becoming Certified – In which I explained the benefits, costs & process of attaining Microsoft Credentials.

Tech Ed topics on Day 1 that I attended were:

  • Keynote presentation by Hon. Steven Joyce, Minister of IT&C, in which he discussed fibre to the home.
  • DAT201 Overview of SQL Server 2008 R2 – Mark Souza from Microsoft NZ explained how to enable managed self-service Business Intelligence, via the new Excel add-on “Gemini”.
  • DAT202 Microsoft Business Intelligence Overview – Myles Matheson from Microsoft US further elucidated on the BI Reporting Maturity Model.
  • MVP – I had a very illuminated private discussion with Rose Stamell from Microsoft Australia about what’s involved in being nominated as a Microsoft Most Valuable Professional.
  • LABS – These were available at anytime as a “filler” for in-depth hands-on training with the latest products.  At this time, I did an ADO.NET lab because DEV307 was postponed.
  • DEV302 What’s Coming in .NET 4.0 – In which John-Daniel Trask from Mindscape demoed Visual Basic 10 language improvements.
  • Gen-I Dinner – In which I briefly turned up, looked around, recognized nobody, saw it was going to be a booze party and left 10 minutes later.
  • GeekZone Dinner – In which I sat in a Chinese restaurant and conversed with industry peers.  Much more to my liking.  Social networking at its best.

Tech Ed topics on Day 2 that I attended were:

  • DEV204 What’s new in Team Foundation Server 2010 – In which Adam Cogan from http://ssw.com.au demonstrated Team Collections.
  • VOC203 Databases, gods and maps – In which Scott Campbell from Express Couriers Limited demonstrated their use of GIS via SQL Server to deliver on-time, every time.
  • DEV301 Visual Studio 2008 IDE Tips – In which Sara Ford from Microsoft US demonstrated many keyboard shortcuts and little-known option settings.
  • LABS Azure – Nothing else appealed at this time.  Self-study.
  • DAT301 Building applications in SQL Azure – In which Jeremy Boyd from Mindscape demonstrated how to do it, and gave useful advice like avoid chatty calls, code for chunky calls.
  • DAT305 Upgrading from SQL 2000 to 2008 – In which Greg Low (MVP, SQL Server Master) gave us a practical approach, which I’m dying to use on our servers!
  • Tech Fest – In which I turned up for dinner, took one drink, had a few conversations, saw it was going to be a booze party and left early.

Tech Ed topics on Day 3 that I attended were:

  • LABS .NET 4.0 – In which I did self-study because SOA205 was packed.
  • DEV205 A tour of CodePlex – In which Sara Ford talked about Open Source at Microsoft.
  • DEV307 Using Team Foundation Server in a Distributed World – In which Wayne Ewington (Microsoft NZ) demonstrated working offline with TFS.
  • DEV306 TFS for successful project management – In which Adam Cogan demonstrated collecting User Stories via INVEST.
  • DAT303 Managing database with VS – In which Greg Low gave a fuller presentation of my Data Dude Code Camp presentation.

Blessings
James Hippolite
MCPD (Web Developer), MCITP (Database Developer), MCT
Senior .NET Developer – Workgroup Solutions Team
Applications Development, Maintenance & Support – Shared Capability

Code Camp Auckland 2009 – Feedback from attendees

Over on Kirk Jackson’s Page of Words, he gives an overview of the feedback from attendees.  All very positive.

He also released individual speaker’s performances privately to each one of us speakers.  Here’re mine:

Becoming Certified. James Hippolite:

    • Dissatisfied: 1 (3%)
    • Satisfied: 11 (28%)
    • Satisfied++: 19 (49%)
    • Very satisfied: 8 (21%)

It was difficult to follow the structure in the Becoming Certified talk and the Secure Coding Practices talk.

I guess that’s because I had 1/2 an hour to cram 1 hour’s worth of presentation.

Kirk indicated that responses were on average about 50% of attendance, which implies I had 80 people in my talk.  Not bad, woo hoo!

Saturday, September 19, 2009

Conferences Overview

Last weekend, I attended three conferences over six days. I extensively blogged all sessions I attended. This page summarises them.

Date Time Conference Code Session Presenter Comment
11-Sep-09 19:00 Promise Keepers #1 Out of the Fire Peter Whaanga Gave a powerful testimony of a vision of Hell
11-Sep-09 20:00 Promise Keepers #2 Forged for the Future Nick Tuitasi Be open to change
12-Sep-09 9:00 Promise Keepers #3 Known By Name Ivan Bezzant You don't know who you really are, until the pressure goes on.
12-Sep-09 10:00 Promise Keepers #4 Following Instructions Geoff Wiklund Spend time listening to God, hearing His Truth about who you really are.
12-Sep-09 11:00 Promise Keepers   Leader Breakout Dean Comerford Ministry with men is the single most important thing your church can engage in.
12-Sep-09 14:00 Promise Keepers #5 Welded Together Mike Gorrie Welded together in marriage
12-Sep-09 15:00 Promise Keepers   Guard Your Heart Paul Subritzkey Panel Session: Sexual Purity
12-Sep-09 16:00 Promise Keepers #6 Apprenticeships Tim Sisarich It's our job, to teach our children to serve Him.
12-Sep-09 18:00 Promise Keepers   Altar Call Geoff Wiklund 12 men responded (second night, 50 on the first night)
12-Sep-09 19:00 Promise Keepers   A Transformed Heart Paul Subritzkey Panel Session: The seven promises of a Promise Keeper
12-Sep-09 20:00 Promise Keepers #7 Tomorrow's Man - God's Man David Dishroon Mentoring others
13-Sep-09 10:20 Code Camp NZ #CCNZ01 What's Happening in .NET Languages Ivan Towlson Functional languages can do you head in.
13-Sep-09 11:25 Code Camp NZ #CCNZ02 Behaviour Driven Development Owen Evans Given...when...then... conceptually brilliant
13-Sep-09 12:30 Code Camp NZ #CCNZ03 C# 4.0 Ivan Towlson Dynamic languages
13-Sep-09 12:40 Code Camp NZ #CCNZ05 Lightening Talks James Hippolite Data Dude: MS VSTS for Database Professional (GDR)
13-Sep-09 13:00 Code Camp NZ #CCNZ06 Becoming Certified James Hippolite MCPD for Visual Studio and MCITP for SQL Server
13-Sep-09 14:45 Code Camp NZ #CCNZ08 Silverlight with Prism Sky Sigal Missed: Registering for Tech Ed
13-Sep-09 15:50 Code Camp NZ #CCNZ17 .NET on the iPhone and beyond Grant Archibald Missed: Unpacking new HP Mini
14-Sep-09 9:00 Tech Ed NZ 09   Keynote Hon Steven Joyce Fibre to the home
14-Sep-09 10:40 Tech Ed NZ 09 DAT201 Overview of SQL Server 2008 R2 Mark Souza Enabling managed self-service Business Intelligence
14-Sep-09 12:05 Tech Ed NZ 09 DAT202 MS Business Intelligence Overview Myles Matheson BI Reporting Maturity Model
14-Sep-09 14:15 Tech Ed NZ 09 MVP Who Do You Have To Kill? Rose Stamell Missed: DEV420 was packed. Had impromptu one-on-one with MVP Lead
14-Sep-09 15:50 Tech Ed NZ 09 LAB ADO.NET James Hippolite Missed: DEV307 was postponed. Did self-study instead.
14-Sep-09 17:15 Tech Ed NZ 09 DEV302 What's Coming in .NET 4.0 John-Daniel Trask Including Visual Basic 10 language improvement
15-Sep-09 9:00 Tech Ed NZ 09 DEV204 What's new in TFS 2010 Adam Cogan Including Team Collections
15-Sep-09 10:45 Tech Ed NZ 09 VOC203 Databases, gods and maps Scott Campbell How Express Couriers are delivering us to the future
15-Sep-09 12:10 Tech Ed NZ 09 DEV301 Visual Studio 2008 IDE tips Sara Ford Not only is she CodePlex’s Queen of Open Source, but she’s also a VB-er!
15-Sep-09 14:20 Tech Ed NZ 09 LAB Azure James Hippolite Nothing else appealed; self-study.
15-Sep-09 15:45 Tech Ed NZ 09 DAT301 Building applications in SQL Azure Jeremy Boyd Avoid chatty calls = code for chunky calls
15-Sep-09 17:10 Tech Ed NZ 09 DAT305 Upgrading from SQL 2000 to 2008 Greg Low A practical approach
16-Sep-09 9:00 Tech Ed NZ 09 LAB .NET 4.0 James Hippolite Missed SOA205: Packed. Did self-study instead.
16-Sep-09 10:45 Tech Ed NZ 09 DEV205 A tour of CodePlex Sara Ford Open Source at Microsoft
16-Sep-09 12:10 Tech Ed NZ 09 DEV307 Using TFS in a Distributed World Wayne Ewington Working offline with Team Foundation Server
16-Sep-09 14:20 Tech Ed NZ 09 DEV306 TFS for successful project management Adam Cogan Collecting user stories via INVEST
16-Sep-09 15:45 Tech Ed NZ 09 DAT303 Managing databases with VS Greg Low Visual Studio Team Edition for Database Professionals

Wednesday, September 16, 2009

DAT303 Managing Databases with Visual Studio

Greg Low

  • Wed 9/16 | 15:45-17:00 | New Zealand Room 4
  • Developers have had a rich set of options for managing their projects, source code and dealing with change for a long time. Visual Studio Team Edition for Database Professionals (aka DataDude) now lets database developers streamline their development experience too. In this session, Greg will show how it can be used to manage database schema changes, compare schemas and data, assist with making schema changes and analyse T-SQL code for quality. He will also show how unit testing can be applied to database code and data can be automatically generated for testing.
  • Principal Mentor and MD, SolidQ Australia Pty Ltd
  • Greg Low is an internationally recognized consultant, developer and trainer. Greg is the country lead for Solid Quality, a SQL Server MVP and a Microsoft Regional Director for Australia. Greg also hosts the popular SQL Down Under podcast (www.sqldownunder.com), organizes the SQL Down Under Code Camp and co-organizes CodeCampOz. He is a board member of PASS (the Professional Association for SQL Server). He regularly speaks at SQL Server and Microsoft events around the world and is one of a handful of people to have achieved the new Masters level certification on SQL Server 2008.

Agenda

  • Manage change through Database Projects
  • Testing and Data generation
  • Building and Deployment

Visual Studio Team Edition for Database Professionals

  • Now supplied with Developer Edition
  • aka “DataDude’
  • Released as 2005 edition
  • 2008 edition basically a service pack
  • GDR (general distribution release) provided 2008 support
  • GDR2 release recently
VSTE-DBPro: Project Management
  • Model-based development
  • Team collaboration
    • TFS
    • Workitems and tasks
VSTE-DBPro: Change Management
  • SCCI source code management integration
  • Refactoring
  • Comparison tools
    • Schema
    • Data
VSTE-DBPro: Testing
  • Database Unit testing
  • MSTest integration
  • Automated data generation system
    • Extensible data generator
    • Seed-based generators
Build/Deploy
  • MSBuild integration
  • Command line tools
  • Allows for multiple inconsistent schema

Project System

  • Offline development
  • Reverse-engineer existing often easiest
  • Consists of series of .sql files
  • Projects can be included in other solutions
  • Project relates to a database

Managed Change

  • Changes are offline within project
  • Can compare project to database

Refactoring

  • Allows for cascading changes within DB
  • Also updates dependent project objects
    • Schema objects
    • Data generation plans
    • Unit tests
    • SQL scripts
  • Allows for atomic changes
  • Understands intent

GDR (RC and R2) Updates

  • Require VS2008SP1
  • Supports SQL Server 2008
  • RC must be uninstalled before R2
  • New architecture (not just an update)
    • Schema provider model (allows extensibility)
    • Build and Deploy separation
  • Integration of power tool features
    • Static code analysis
    • Dependency viewer

TFS Integration

  • Team Foundation Server for source code control
  • Team Projects

Unit Testing

  • Still uncommon in database development
  • Helps avoid painful rollbacks
Data Generation
  • Testing with meaningful data
  • Data generation plan
  • Customised data generators
    • Implement Generator

Session Summary

  • Outstanding new capability
  • GDR R2 re;ease much more flexible
  • Now extensible provider model
  • Should be more extensible in VS23010
  • Get control of your database projects
Online Resources
  • Gert Draper’s blog
  • Etc

Tuesday, September 15, 2009

DEV306 Team Foundation Server for Successful Project Management

Adam Cogan

  • Wed 9/16 | 14:20-15:35 | Ballroom 1
  • Visual Studio Team System (VSTS) and Team Foundation Server (TFS) are the best tools for Microsoft developers to have successful projects and smooth software development processes. In this talk the Chief Architect from SSW will show you:
    • The right way to use work items
    • The way to complete a work items and how to send a "done"
    • How to use templates for your standard work items
    • The extra work items that developers always forget
    • How TFS handles repetitive tasks
    • What is good and bad about Excel and Project integration
    • What you can use from the built in reporting as well as the Project portals available on SharePoint
    • The important reports to give to your Project Manager
    • The metrics to bother with
  • Chief Architect, SSW
  • Adam Cogan is the Chief Architect at SSW, a Microsoft Certified Gold Partner specializing in custom .NET, SharePoint and Business Intelligence solutions. At SSW, Adam is also a Team System MVP and Microsoft Regional Director.

Correct Process

  • Don’t give away freebie consulting/analysis of work: charge for scoping.
  • Confirm the Ball Park
  • Present the $ with the Plan: not a round figure. 
  • Ask for a signature

Kicking off the project

  • Choose your methodology (Microsoft, CMMI)
  • Problems with Work Items in 2008 – extraneous fields in the templates. 
  • Solution – roll your own
  • Good news – VS2010 Agile template is better
Reference
  • www.ssw.com.au
  • Rules to Better Project Management with TFS (Creating and Managing Release Plans)
Conchango Scrum
  • Developed in collaboration with Ken Schwaber (co-founder of Scrum)
  • Scrum Task Board
  • Lots of reports
    • Code churn
    • Velocity
    • Burndown
  • Plasma slide show

Talk to the Customer – Requirements workshopping

  • Collecting User Stories - INVEST
    • Independent: each feature is unique
    • Negotiable: technology independent
    • Valuable
    • Estimable
    • Small (<80 hours)
    • Testable (if you can’t test it, you haven’t defined it sufficiently)
  • As A <some role> I want <some goal> so that <some reason>
Demo
  • Using Excel to manage work items
  • Team Tab, New List
  • Decomposing work items into Tasks

Using Team Foundation Server in a Distributed World

Working Offline With VSTS

  • Wayne Ewington
  • Microsoft
  • DEV307

Going Offline

  • When TFS is not available
  • Remove the read-only attributes
  • Work with the files
  • Renaming Files!! Treated as a Delete and Add pair

TIP: Check-out All Artefacts

  • Check-out all artefacts
  • Go offline
  • “Do stuff”
  • Go back online
  • Check-in all artefacts: TFS will determine which artefacts have changed
  • Won’t work in a Team situation

TIP: Stopping TFS Auto-Connect

  • Registry Hack: HKCU\Software\Microsoft\VisualStudio\9.0\TeamFoundation\AutoLoadServer(Dword)

TFS Proxy Server

  • Architecture
    • Uploads go to TFS
    • Downloads come from proxy(ies)
  • Configuring
  • Tips & Tricks

TFS Over the Internet

  • VPN
    • All features of TFS work
    • Easiest to implement: no additional changes required
    • Requires infrastructure support
  • Publish using a Reverse Proxy
    • Reverse Proxy will Authenticate
    • Remote Users don’t require Domain access
    • Requires ISA Server 2006, TFS SP1
    • TFS is “chatty”
    • Disadvantages: can’t get Publishing Test Results, Accessing Build Reports
  • Extranet
    • Clear segregation
    • Internal Users must connect “remotely”
    • TFS is “chatty”
    • Won’t get Test Results and Build Reports

Fully Qualified Domain Names

  • Resolves the issue of getting the Test Results and Build Reports
  • Use on TFS Server, SharePoint (Sites and Central Admin), Reporting Services
  • TFSAdminUtil.exe Configure Connections
  • TFS Server needs to authenticate to itself
  • http://support.microsoft.com/kb/926642
How? By Enabling
  • Basic Authentication
  • SSL

TRICK: Enabling Team Build Logs

References

A tour of CodePlex

Open Source at Microsoft

  • Sara Ford
  • Program Manager, Microsoft
  • Sara Ford is the program manager for CodePlex, Microsoft’s open source project hosting site. Prior to CodePlex, she worked on the Visual Studio team for six years, where she ran the Visual Studio Tip of the Day on her blog. Her life-long goal is to become a 97 year-old weightlifter, so she can be featured on the local news.
  • DEV 205

Blurb

If you're a software developer interested in running an open source project or just looking around for a particular tool to download, come check out the latest from CodePlex. CodePlex is Microsoft's open source project hosting site. Launched in May 2006, CodePlex host thousands of open source projects. CodePlex users can start open source projects with support for source control, bug tracking, wiki pages, downloads, forums, and project statistics. Additionally, CodePlex supports the widest range of source control clients. This talk explores the top downloaded projects, outlines the CodePlex feature set, and explains how we build the CodePlex software.

Agenda

  • CodePlex & Customers
  • Open Source
    • How to consume
    • How to contribute
  • Under the Hood
  • Agile Development

CodePlex is About Customers

  • Voting for CodePlex features
  • Survey Comments
  • Tweets (#codeplex?)
  • Blog feedback
  • 1-1 engagement in conferences

Open Source

  • Models
    • Business
    • Licensing
    • Development
  • Open Source Initiative (OSI)
    • Open Source Definition
  • Basics
    • Source code provided
    • View, modify and redistribute code

Demo Projects

  • AJAX Control Toolbox
  • TweetMyPC
  • TweetCraft
  • Rawr
  • Image Resizer PowerToy Clone for Windows

Contribution Software to CodePlex

  • Features for hosting projects
  • Features for contributing updates

Agile Development

  • Iteration 1 (Feature)
  • Iteration 2 (Feature)
  • Iteration 3 (Stabilise)
  • Test Pass
  • Deploy

Monday, September 14, 2009

Upgrading from SQL 2000 to SQL 2008

A Practical Approach

  • Greg Low
  • Managing Director and Mentor – SolidQ Australia
  • MVP SQL
  • DAT 305
Expectations – Goals
  • 2008 Upgrade Options
  • Methodology tools and planning
  • Technical and non-technical considerations
  • Common issues, myths and mistakes
What have you already got?
  • Hardware and infrastructure review
  • Application and database domain
  • Features and editions
Upgrade Advisor
  • Analyses: Databases, Trace Files, Scripts
  • Reports on: Blocking issues, pre-upgrade issues; post-upgrade issues
  • Suggests how to fix/work around
Reporting Services
  • In-place upgrade supported for 2005 and 2000 p2
  • No upgrade support for
    • Report Server that users a remote 2000 database
    • 2000 Report Server Web Service – endpoint de-supported
    • Earlier versions of WMI provider
    • Anonymous authentication
Notification Services
  • Basically gone
  • SQL Server 2008 Feature Pack migrated
Data Transformation Services
  • Simple in-place upgrade for 2000 and 2005
  • DTS packages are retained – Need to run DTS Package Migration Wizard
  • No 64-bit design/run time for DTS packages
  • No 32-bit design/run time support for DTS packages on Itanium based systems
  • Consider 64 bit driver issues

Considerations

  • Upgrade Motivations
  • Stakeholder Considerations
  • Prepare the Environment
  • Locate Dependencies
  • Third-party dependencies
  • Verification Tests
  • Mismatched SIDs (Demo)

The Upgrade

  • Prepare
  • Execute
  • Post-Upgrade tasks

Some common upgrade issues

  • *=
  • System table access
  • Service master key not backed up
  • Forgetting to re-enable DAC
  • Poorer performance after upgrade
  • Changes to log shipping from 2000
  • TOP 100 PERCENT
  • tempdb sizing
  • Avoid staying in order dbcompat levels!

Summary

  • Upgrades are conceptually simple
  • Easy to make human errors
  • No one right way
  • Application Compatibility Testing highly recommended
  • A tested rollback plan is critical
  • Lots of resources
  • Feedback to Microsoft via Connect will drive improvements in product and upgrade process/tools

Building applications on SQL Azure

SQL Azure – Database as a Service

  • Jeremy Boyd
  • Mindscape
  • DAT301

SQL Data Services

  • Previous incarnation
    • Entity-Value style
    • Provided REST based access to resources
  • Matched similar competitor offerings
  • Lacked familiar SQL Server syntax and capabilities
  • Use Azure Table+Blob Storage as replacement
SQL Azure Database
  • Clear feedback
  • I want RDBMS in the cloud
Provisioning Model
  • Account = zero or more servers
  • Server = each server has one or more databases
  • Database = each database has standard SQL objects
Compatibility Goals
  • Version 1: Address the needs of 95% or more standard application functionality (web/enterprise)
  • Support common application patterns
  • Consistent patterns for Azure and SQL
  • Multi-tenancy considerations
Building Applications
  • Can target SQL Azure either remotely from on-premise or from Windows Azure
  • Can promote existing applications or build new applications
  • SQL Azure offering currently favours:
    • Cacheable data sets
    • Blah
    • Blah
On Premise over Azure
  • Data is typically located outside the firewall from where your application runs
  • Be aware of latency (~150ms from NZ to US)
  • Try to pre-fetch as much as possible
Impact on System Design
  • Expect poor latency
  • Avoid chatty calls = code for chunky calls
Windows Azure over SQL Azure
  • Application Code runs within the Azure network that your data resides on
  • Same connection string as with remote
  • Check that your SQL and App instances are on the same location group (e.g. US – Southwest)
  • Note: Caching may still be appropriate
  • SQL Azure and Windows Azure will generally provide a “better together”: experience
Synchronisation
  • Azure offers a great data synchronisation point: high availability, scalable
  • Sync Framework “Project Huron” for sync
  • Common Scenarios
    • Mobile device access to corporate data
    • Business to business sharing
    • Secure digital data hub
Database Size
  • Max single db size is currently 10GB
  • Database size calculation
    • Includes: primary replica data, objects and indexes
    • Does NOT include: logs, master database, system tables, server catalogues or additional replicas
  • V does not support auto-partitioning
  • Use Scale Out (Sharding) approach to solve if needed and applicable
Sharding with SQL Azure
  • Several databases are used to store a portion of the application's data
  • Blah
Costs
  • Two plans
    • US$9.99 per month for 1GB (Web Edition
    • US$99.99 per month for 10GB (Business Edition)
    • SLA – 99% availability
  • Price is per database
    • Each database gets a server instance
    • No limits on CPU/RAM consumption unlike Azure
    • Automatically replicated, no admin cost
  • Best to think of price in “per day” terms
Release Plan
  • Currently in CTP
  • Commercial availability in November 2009
    • Launches alongside Windows Azure
Futures

Visual Studio 2008 IDE Tips & Tricks

  • Sara Ford
  • Program Manager
  • CodePlex

Random Thoughts

Databases, Gods & Maps

How Express Couriers are delivering us to the future

  • Mike Farrell
  • Programme Manager
  • Courier Express Ltd

Agenda

  • Business View & Background
  • Partners & Partnerships
  • Solutions & Functional Overview
  • Architecture

Current Environment

  • Increasing volumes nationwide
  • Changing customer needs – More for less
  • The competition have invested in technology
  • Numerous, inconsistent operational datasets
  • Legacy systems are now outdated, unsupported and don’t fit future direction
  • New Auckland depot opened in 2009, NZ’s first automated parcel sortation system.

Business Requirements

  • Customer Service remains our No1 priority
  • Deliver parcels within agreed service levels
  • Move to service orientated architecture
  • Automate current operational processes
  • Improve maintenance processes and national datasets
  • Exploit the relationships between location and the corresponding activities
  • 95% of our information has a geographical position

The Vision

  • To exploit location intelligence to differentiate the manner in which Express Couriers Limited delivers time certain services and is recognised as New Zealand’s leading express courier, logistics and distribution business
  • Location Intelligence is the capacity to organise and understand complex business operations and relationship through the use of location …

Strategic Approach

  • Develop capabilities within ECL – support improvement of data content & quality
  • Establish technical and personnel capabilities – exploit location intelligence
  • Create centrally maintained address database – one source of the truth
  • Introduce mapping applications – define, establish and manage critical datasets
  • Use external vendors – support delivery of location intelligence
  • Undertake programme of work – eliminate address data from other information systems
  • Use web based technologies – deliver location intelligence throughout organisation

Benefits

  • One source of the truth
  • One view across the business
  • Improved operational process
  • Informed business decisions & discussions
  • Centralised maintenance
  • Improved data quality
  • Future proofed infrastructure
Partners
  • Eagle Technology Group Ltd – Hardware
  • Microsoft – Software
  • e-Spatial Limited – Location Intelligence (GIS expertise)
Solution = Database + Application
  • Atlas = Carrying the World
    • ESRI ArcGIS Server
    • .NET Web A[pp
    • SOAP Web Services
    • Cached Mapping
    • e-SAM Searching
  • Athena = goddess of wisdom
    • SQL Server 2008
    • SSRS
    • etc
Left Early
  • Matti tried valiantly, and almost managed to save this session from his fellow presenters.

What’s New in Team Foundation Server 2010

A Lap Around

  • Adam Cogan
  • Chief Architect
  • DEV204
  • www.ssw.com.au
  • Sydney User Group Convenor

Pain Points

  • Better Merging
  • Better Branching
  • Better Project
  • Better Scrum
  • Better Build Server
  • (already has) Better bug tracking = work items = linking requirements to code changes
  • (not) Better integration with Project
Problems
  1. How do you know where the project is at?
  2. Why don’t developers do unit tests?
    • Estimate
    • Work
    • Work
    • Overtime
    • Run out of time
  3. MS Project is not used
  4. SharePoint

Agenda

  • TFS Admins
  • PM
  • Developers
  • Testers
TFS Admins
  • No VS 2005 Support – until RTM
  • No test management publishing
  • No office integration
The multi-tenanted Problem
  • You want to share a TFS server with multiple companies
  • You need complete isolation
  • how do you do this in TFS2008?
  • e.g. TFS Now
The solution – Team Collections in TFS2010
  • Team projects can now be grouped into Team Collections
  • Each collection has it’s own database
Database Changes
  • TFS 2008 had 7 database
    • TfsBuild
    • TfsIntegration
    • TfsVersionControl
    • TfsWorkItemTracking
    • TfsWorkItemTrackingAttachments
    • TfsActivityLogging
    • TfsWarehouse
  • Now: A database per collection
    • TFS_DefaultCollection
    • TFS_<Collections>
    • TFS_Warehouse
    • TFS_Configuration
Gated Check-ins
  • Can’t check in code that breaks the build
  • Can’t override the policy!
Visual Branch Management
  • Merging changes back into the trunk is a lot easier (visually drag a branch back into the trunk)
  • Visually see which branches are in sync with the trunk

Sunday, September 13, 2009

What's coming in .NET 4.0

John-Daniel Trask

  • Co-founder
  • Mindscape
  • DEV302

Agenda – Upcoming bits and pieces

  • .NET in review
  • New CLR Goodness
  • Code contracts
  • C#4.0
  • Visual Basic 10
  • Windows Foundation
  • ASP.NET 4.0

Anti-agenda – what we won’t be covering

  • · Parallel Extensions
  • · Entity Framework
  • · F#
  • · VS.NET 2010

.NET CLR Enhancements

  • · Side by side in process support
  • · DLR Inclusion
  • · Crazy ass language support
    • System.Numerics, Tuples
  • · Parallel extensions
  • · Code contracts
  • · New security model

Code Contracts

  • · Manage the expectations of software
  • · System.Diagnostics.Contracts
  • · Both runtime and compile time checking
  • · Specify contracts on interfaces

C# 4.0 – Language improvements

  • · Dynamic typing
  • · Generic variance
  • · Optional parameters
  • · Named arguments
  • · COM Interop Enhancements

Visual Base 10 – Language improvements

  • · Implicit line continuation support
  • · Lambda improvements
    • Multi-line lambdas
    • Lambdas do not require return values
    • Multiple statement lambda expressions
  • · Automatic properties
  • · Collection initializers
  • · Generic variances supporters

Windows Presentation Foundation – Framework improvements

  • · Improved font rendering
  • · Windows 7 multi-touch support
  • · Windows 7 task bar extensibility
  • · Ribbon control
  • · Data grid control
  • · Many other improvements
  • · Slack demoware L

Summary – our time is coming to an end

  • · Many nice improvements
  • · Explore code contracts
  • · Start exploring Beta 2 when released

Who do you have to kill?

…in order to be nominated for an MVP award?

That was the tongue-in-cheek question I posed to a couple of MVP Leads, here at the Microsoft TechEd conference.

Background

I knew that it was awfully bad taste to go seeking this reward for oneself.  That it should be bestowed upon one by others who have recognized your contribution to the community through voluntary efforts.  However, after not being shoulder tapped (after many years of dedicated service, IMHO), I decided to ask the question.

Problem

Turns out, I’d been too generalist.  Which is natural for a New Zealander, but works against you in this case.  Because I’m both Web Dev and DB Dev, I’d been straddling the two streams, and contributing to both camps.  However, the MVP programme is structured along Product lines, and you must demonstrate in-depth knowledge, skill and dedication in that one area, in order to qualify.

Hence, I don’t qualify.

Solution

Question now is, do I want to bother refocussing on only one area?  Or am I basically happy to continue as I am, knowing that that particular gong is out of reach?

Thoughts and/or opinions?

As a matter of interest, the two areas that strike me as interesting, in which I feel I “had a shot” would be VB and/or SQL BI.

Microsoft Business Intelligence Overview

Myles Matheson

  • Solution Specialist – Application Platform
  • DAT202

Today’s Session

  • Microsoft BI Vision
  • The BI Reporting Maturity Model
  • Integration Services Overview
  • Demo of Integration Services
  • Business User BI Tools
  • Demo of Analysis Services
  • Demo of Re[porting Services and Performance Point
  • BI Road Map

Microsoft Business Intelligence Stack

  • Data Infrastructure & BI Platform – SQL Server 2008
  • Business Collaboration Platform – Office SharePoint Server 2007
  • Business User Experience – Office

BI Demystified - It’s simpler than you might think

  • Your existing systems – Data collected in your systems like CRM, ERP, Finance, etc.
  • Data collection – Data repository
  • Dashboards & Scorecards

Integration Services – Enterprise Data Integration Platform

  • Scalable Platform
  • Comprehensive transformations
  • Extensible Platform

Analysis Services 2008 – Drive Pervasive Insights

  • Design Scalable Solutions
  • Extend Usability
  • Deliver Actionable Insight

Reporting Services 2008 – Deliver Enterprise Reports

  • Author Impactful Reports
  • Manage Enterprise Workload
  • Deliver Personalized Reports

Integrated Predictive Analysis – Predictive KPIs

  • Integration with Microsoft Office PerformancePoint Server 2007
  • Analytics

BI Roadshow for Business Decision Makers

  • November 16-18 in NZ

Kimball University

  • Microsoft Data Warehouse in Depth 20-23 Oct 2009
  • Kimball University courses 2010

Microsoft Data Warehouse in Depth

  • Sydney
  • Hosted by Altis Consulting
  • AU$3700
  • Taught by Joy Mundy & Warren Thornthwait, co-authors of the best selling Microsoft Data Warehouse Toolkit

SQL Server 2008 R2

Code Name Kilimanjaro

  • Mark Souza
  • Director, SQL Server

It starts by building on a strong base: SQL Server 2008

  • Trusted Platform
  • Productivity
  • Business Intelligence

The SQL Server 2008 R2 Journey

  • The origins of Kilimanjaro
  • Self-service Business Intelligence
  • Application & Multi-server Management
  • Scaling for the next generation enterprise
    • High End Scale out Data Warehouses
    • CEP – Complex Event Processing
  • Reaching the summit
What’s in a name...
  • Gemini means twins
  • The corporate Twins: IT Pro/End User
  • A widening gap between these two
Enabling managed self-service BI
  • Empowered and Managed
Excel is key for IW/Users
  • It has to be Excel
  • Use Excel as a catch all tool
  • Easy sharing of insights is critical
Sneak Peak
  • Nicholas Dritsas
  • Head of project Gemini
  • Demo: BI
IT manage the “Spreadmarts”
  • Excel is the IW tool of choice, but for IT: Excel is a problem
  • Why not make Excel part of the solution?
Challenges: People vs. Hardware
  • Number of database apps increases faster than the number of DBA’s
Synthesis Vision
  • The vision of Synthesis is to bring together a set of new and existing technology investments that enable a much more efficient way to develop, deploy and management application development
Introducing a better way
  • Control server sprawl with 1 to many management – setup is fast and easy
  • Manage capacity through policies – save time, optimize resource
  • Single unit of deployment - increase deployment and upgrade efficiency
Deploy Data-tier application
  • Select the DAC package to deploy
  • Update Configuration
  • Deploy!
Application & Multi-server Management
  • Productive database application development and management via DAC
  • Multi-server Management made easier through (lots of stuff)
Data Distribution with Replication
  • Madison Appliance Nodes
Summary
  • Kilimanjaro has the 6 volcanic mountain ranges:
    • Gemini – IMBI
    • Synthesis – Multi-Server management integrated with Application management
    • Madison – Massively scale out DW
    • Orinoco – Complex Event Processing
    • SSRS – New report Builder enhancements and integration with SharePoint enhancements
    • >64 Cores
  • SQL Server 2008 R2 – 1st half CY10

Welcome to TechEd

Scott Wiley

  • Head of Developer Stuff
  • This is the Windows 7 TechEd
  • His second to lead
  • New Zealand’s 14th

What does TechEd mean to you?

  • He showed several tweets
  • He gave some housekeeping
  • He introduced first speaker

Honourable Steven Joyce

  • Minister for Communications & Information Technology
  • So-called “CIO for the Government”
Speech Contents
  • “Need to deliver fibre to the home”
  • From a discussion I (James) had last night after Code Camp, the Geek perspective is that both Labour and National have missed the point.  It’s not fibre to the home that matters.  It’s the pipe to the outside world.
  • “Government has partnered with others (such as Microsoft) to improve computer literacy.  Outside of this audience, the average kiwi doesn’t have sufficient skill to make use of ICT”
  • “Be encouraged.  Your country needs you to succeed.”
  • Keep up the fine work.  Enjoy it. 

Chris Liddell

  • Microsoft’s CFO
  • Kiwi!
Innovating for the Future
  • We’re a small country, but we have access to everything that’s good in the world.
  • 2000 out of 4 million, per capita, is the biggest Tech Ed in the world

Comparison to Previous Bears

  • Here he descended to finance-speak
  • I’ll post this now and pick up again later

TechEd NZ 2009 Keynote

Monday 14 September 9AM

Excitement is mounting; I estimate there are 2000 geeks surrounding me.  The light is dimming (except for the hundreds of HP Mini notebooks and others that are open).  A green man drumming on bongo/percussion just walked in from back.  Very avant guard.

Gonna enjoy the show.  Catch you later.

Saturday, September 12, 2009

Tweets from Code Camp

5:47 PM listening to Sky Sigal #ccnz08 #codecampnz
5:47 PM just registered and picked up HP Mini - woo hoo #tenz09
2:46 PM just gave 30min presentation on Certification #ccnz06 #codecampnz
2:46 PM just gave 5min lightening talk about Data Dude #ccnz05 #codecampnz
2:46 PM c#4.0 with Ivan #ccnz03 #codecampnz
2:46 PM RSpec? Cucumber? more buzzwords to Google, @blackmael #ccnz02 #codecampnz
2:46 PM Given...when...then... conceptually brilliant #ccnz02 #codecampnz
11:46 AM started Behaviour Driven Devt with @buildmaster #ccnz02 #codecampnz
11:46 AM score! he did! yes @blackmael there will be slides. i don't see a camera #codecampnz
11:46 AM functional languages can do your head in, i wonder if Ivan will do his dance today? #codecampnz
10:30 AM listening to Ivan Towlson #codecampnz
09:30 AM touchdown! #codecampnz

Tuesday, September 1, 2009

How I Choose To Use Data Dude

Data Dude was the old name for Microsoft Visual Studio Database Professional Edition, now also known as the GDR version. It allows you to add Server and Database projects to your Solution, which help synchronize your various environments. It can be tricky to get your head around. Here’s how I choose to use it.

  1. I make my database modifications using the visual designers as much as possible, because I’m lazy and like it that way. So, I maintain a local copy of my new database, with edits.
  2. I run a schema compare between my local database and the Solution’s database project. This generates all necessary CREATE scripts.
  3. I maintain a Post Deployment script which populates the newly dropped and recreated tables.
  4. I deploy the database updates from the Database project to the DEV (and/or TEST) server.

This has the added benefit of not-dropping and recreating my local database copy, so I don’t keep losing my lovely Database Diagram!