June 21, 2006

Session A1: Server Development Overview

This anchor session surveys the range of development opportunity present in Windows SharePoint Server (version 3) and the 2007 Microsoft Office System server products. This is the big picture, “how-it-all-fits-together” talk, and should serve as a good overview of the technologies and road map to help select which detailed breakout sessions to attend for the rest of the event.

Session A2: New Office XML File Formats (Introduction, Schemas and Solution Development) Learn about the huge change that will affect the role Office documents can now play in business processes and solutions. Learn how the new OpenXML formats allow documents to serve as a first class source of data as they travel through workflow and other processes. This session will allow you intimate details of the XML schemas that have been created to fully represent Word, PowerPoint, and Excel documents in a fully accessible and interoperable way and the tools and methods used to develop with the Office Open XML formats.

Session A3 Microsoft Office Excel 2007

Building Business Intelligence Solutions Using Excel and SQL Server 2005 Analysis Services

Learn how to use Office Excel 2007 and SQL Server 2005 Analysis Services to build end-to-end business intelligence solutions. This session covers creation of an Analysis Services 2005 UDM (Unified Dimensional Model) that can be consumed with Excel, and demonstrates how to use the new features in Excel 2007 to take advantage of the metadata exposed by the UDM. We build a BI solution that explores some of the new functionality available in PivotTables, a set of seven new OLAP Formulas that can be used to retrieve data from Analysis Services 2005, and conditional formatting improvements that can be used to visualize your BI data.

12:30-1:15pm: Lunch

Session B1: Developing in Windows SharePoint Services Part 1

The first of two sessions focusing on what .NET developers need to know to take advantage of SharePoint Products and Technologies to their fullest. This session covers key object models and related Web services, and focuses on how to add your own Web services, event handlers, and other custom code modules to SharePoint sites. It also covers list and library metadata, then moves on to one of the most sweeping advancement to SharePoint technology: content types, the means by which metadata can be shared across lists, libraries, sites, and site collections.

Session B2: Microsoft Office Word 2007 Structured Solution Authoring and XML

Office Word 2007 brings a robust development platform for solution providers who would rather spend their time hooking into existing business processes and backend databases, rather than worry about unnecessary client-side code for handling basic usability. Office Word 2007 brings a data model that allows for the data and views to be managed separately. In this session, we introduce these new capabilities, then dive into the functionality of the Office XML data store (which provides custom XML storage), and how it can be leveraged to build solutions that will strongly tie Word documents to your business processes.

Session B3: Microsoft Office Sharepoint Server 2007: Building Custom Solutions With Excel Services and Business Scorecard Manager 2005.

This session explains Excel services basic concepts and architecture, shows Excel Web Access (browser access to live, interactive server spreadsheets), and then covers the excel web Services API (a programatic interface to excel Services' calculation engine), that enables developers to build custom solutions. In addition it will teach you how to centralise management of dashboards and scorecards across Office server, SQL server Reporting services and your existing deployments of Windows SharePoint Services and leverage the Office platform to embed Scorecards and KPIs in your custom .NET applications.

2:30-2:45pm: Break

Session C1: Workflow in Windows SharePoint Services and the Microsoft Office System

This session discusses the integration of Windows Workflow Foundation into Windows SharePoint Services (version 3), how workflows are designed, stored, and used, and which capabilities are enhanced by taking advantage of client and server technology in the 2007 Microsoft Office system. Different authoring tools and techniques will be explained, including how to create no-code workflows using Microsoft Office SharePoint Designer 2007,, and how to build workflow forms with Microsoft Office InfoPath 2007. This session focuses on the power and developer productivity of workflow solutions built on Windows Workflow Foundation (WF).

Session C2: VSTOA Roadmap Session

Visual Studio tools for Applications (VSTA) provides a developer experience for both professional developers using Visual Studio, and end-user developers who will use the VSTA integrated development environment to customize applications. Either environment enables developers to access the rich .NET Framework. This session will provide developers with an understanding of Microsoft's VSTA strategy roadmap

Session C3: Microsoft Office Excel 2007: Programming Business Intelligence Features Learn more about new business intelligence features in Office Excel 2007, and how to programmatically enhance these features. Conditional Formatting, Filter/Sorting, Pivot Tables

and Data Connections Management have all been enhanced in Excel 2007 UI, and in this session you will learn how to take greater advantage of the new feature set. This session also covers some of the Big Grid and Multi-threaded Recalculation ramifications in Excel 2007.

4:00-4:15pm: Break

Session D1: Microsoft Windows SharePoint Services (version 3): Email, Directory, Tracking, and Other Collaboration Applications

This session covers feature overviews and extensibility options for the out-of-box collaboration solution delivered with Windows SharePoint Services (version 3). In particular, directory integration, list versioning, email enablement, and custom alerts are discussed and demonstrated.

Session D2: Information Protection Overview

This session offers an end-to-end look at the information protection technologies in the 2007 Microsoft Office system. It includes coverage of digital signatures, custom file encryption, client and server support for Windows Rights Management, and more.

Session D3: Microsoft Office Visio 2007: New Data Visualisation Capabilities and Solutions Your application deals with huge amounts of data, and making sense of that information and communicating it broadly is vital to making your users successful. Learn how to incorporate dynamic views of data into your smart client application using the new data visualisation capabilities in Office Visio 2007. Stepping through the creation of an example application, topics covered include connecting to data sources (i.e., Excel, Access, SQL Server, SharePoint lists, and XML), programmatically mapping that data to shapes, and surfacing the

data on the diagram using the Data Graphics API.

June 21, 2006

Session E1: Dynamics Snap-in development for Office

An introduction to Microsoft Dynamics Snap-ins: A collection of applications that connects data from Microsoft Dynamics directly to the widely-familiar Microsoft Office System. Snap-in applications enables developers to build custom solutions and Dynamics add-ins as custom items and task panes within the familiar environments of Microsoft Office applications, such as Microsoft Office Outlook, Word, and Excel. Developers will discover how to build upon existing snap-in software programmes such as Timesheet Management, Vacation Management, Business Data Lookup for Microsoft Dynamics CRM 3.0 and Business Data Lookup for Microsoft Dynamics AX 3.0.

Session E2: Building and Branding Web Sites Using the Web Content Management Capabilities of Microsoft Office SharePoint Server 2007

This session demonstrates the technologies and features that will help you keep your site looking consistent. It also covers the design of the page rendering model using master pages, page layouts, and content pages, as well as some more advanced features like variations (used to simplify creating sites for multiple languages or device formats). It covers how to build custom field controls for authoring and presenting new types of content, the creation and use of custom document converters for creating pages from existing content.

Session E3: Microsoft Office Project Server 2007: Architecture Overview

Learn how to customize the Project Server OLAP database by using enterprise custom fields and details on how to create intelligent enterprise reports using SQL Server Reporting, Office Server, and Business Scorecard Manager. This session also includes an overview of the Reporting extension capabilities. This session provides you with an overview of the functionality of and architecture behind Microsoft Office Project Server 2007, including

how it improves on previous releases and where development opportunities exist.

10:45-11:00am: Break

Session F1: Microsoft Office Access 2007: A Rich Client for Windows SharePoint Services 3.0

Office Access 2007 works very well with Windows SharePoint sites to enable applications that utilise the best of the rich client and the best of the collaboration server. In addition, administrators can use SharePoint technology to make their users’ applications more manageable. This session discusses linking to SharePoint lists, support for all the SharePoint data types, including Access reports in the SharePoint list of views, and automatically installing Access front-end databases from Share- Point sites. In addition, we discuss building applications that leverage server-side workflows, combine Access components with custom server pages, and taking SharePoint applications offline.

Session F2: Visual Studio Tools for Office (VSTO) 2005: Creating Multi-Tier Application

Enterprise applications require distributed architectures. Learn how to create multi-tier applications using Web services, business objects, data objects, SQL server, and VSTO 2005. Integrate the power and rich UI of an Office application, with the security, flexibility, and maintainability of a middle-tier and an enterprise-level database.

Session F3: Programming with Office Project Server 2007

Project Server is a first-class platform for building work management solutions. In this session, learn the programmability basics to get started with developing Office Project Server 2007 solutions. In this session, learn advanced programming concepts for building project management directly into your business process applications.

12:15-1:45pm: Lunch

Session G1: Developing in Windows SharePoint Services – Part 2 The second session on what .NET developers need to know to take advantage of SharePoint Products and Technologies to their fullest. This session covers how to write Web Parts that know about SharePoint site content and navigation. It also shows you how to add new ASP.NET pages to SharePoint sites, how to work with master pages, and how to create SharePoint forms and custom field types. The session will also cover how to take advantage of the improved search facilities in Microsoft Office SharePoint Server 2007. This includes how search has improved, how to customize and extend the search user interface, and how to make use of the search engine and APIs within your own code.

Session G2: Visual Studio Tools for Office (VSTO) Technical Preview for the 2007 Microsoft Office System

Learn about the VSTO v3 Technical Preview. This technical preview includes large parts of the core infrastructure and feature set for the VSTO v3 release, and allows you to build VSTO solutions for the new Microsoft Office system. In this session, find out what’s coming up in VSTO v3 and learn how to create application-level add-ins, application-level task panes, and custom ribbons using the VSTO v3 Technical Preview.

Session G3: Microsoft Office InfoPath 2007: Development Tools for Forms Solutions

This session introduces the different tools available to build manage code InfoPath form solutions. It covers Visual Studio 2005 Tools for Microsoft Office (VSTO) and Visual Studio Tools for Applications (VSTA), introduces the new object model, template parts, and how to build server and client compliant InfoPath forms solutions. It highlights best practices on how to design forms in Visual Studio, how to hookup code to events and how to debug your solution. It also introduces add-ins and the new importer/exporter framework. In addition this session addresses how to tightly integrate InfoPath forms into Web pages. and learn best practices on how to use the hosted form control to build powerful but easy to use solutions.

3:00-3:15pm: Break

Session H1: Microsoft Office SharePoint Server 2007 Business Data Catalog The Business Data Catalog (BDC) in Office SharePoint Server 2007 allows Web services and data sources from a variety of systems to be integrated into SharePoint. BDC-registered metadata can be used to auto-provision Web Parts, to import/ export data into/out of editable lists, to import user profile information, and to index structured business data for use in enterprise search queries. This session explains how the BDC works, how to connect it to Web services and data, and how to make use of the resulting cataloged business resources.

Session H2 : Microsoft Office Groove 2007: Developing Applications

In this session, learn how Groove’s Web Services API provides programmers and professional developers with access to the collaborative services of Groove 2007, including Groove Forms, InfoPath Forms and files within Groove workspaces. Groove Data Bridge Groove Data Bridge provides a server-based integration platform and framework for connecting business applications and data sources with Groove workspaces. Whether you need to exchange and work on files,track tasks and manage meetings, or create a custom solution that integrates with your business systems, you can easily customize Groove workspaces to meet the unique requirements of each of your projects.

Session H3: Microsoft Office InfoPath 2007: Integrating InfoPath Forms into Workflow Solutions and Business Processes

Forms are the end user interface to workflows and business processes. This session covers best practices on how to connect InfoPath forms to SharePoint site-based workflows and drive the form based on workflow state. Learn how digital signatures, IRM, and archiving can be incorporated in these processes. Learn about data connections for client and browser forms, and how forms can connect to Excel Services, the Business Data Catalog, and SQL Server 2005.