Planning a Global Microsoft Office SharePoint Server 2007 Deployment

A new article is available on Microsoft TechNet that highlights steps and best practices to plan a global MOSS 2007 deployment. The key topics covered include what global MOSS solutions are supported, how to extend global MOSS solutions with Outlook 2007 and Groove, designing global information architecture and governance, planning for global enterprise search, planning for bandwidth requirements, optimizing MOSS for WAN environments, and optimizing custom web parts for WAN environments. The article can be found at

Introduction to Microsoft Office SharePoint Server 2007 Architecture

I will be a guest speaker tonight at the Southern California chapter of IASA meeting. My presentation will cover an introduction to the architecture behind Microsoft Office SharePoint Server 2007. Please feel free to stop by and say hello.

Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies

The Microsoft® SQL Server™ 2005 Reporting Services Add-in for SharePoint Technologies is a Web download that provides features for running a report server within a larger deployment of Microsoft Windows® SharePoint® Services 3.0 or Microsoft Office SharePoint Server 2007. The Reporting Services Add-in provides the following functionality:

  • A Report Viewer Web Part, which provides report viewing capability, export to other rendering formats, page navigation, search, print, and zoom.
  • Web application pages so that you can create subscriptions and schedules, set model item security, and manage reports, models, and data sources.
  • Support for standard Windows SharePoint Services features including document management, collaboration, security, and deployment with report server content types. You can use alerts, versioning (check in/out), and Filter Web Parts with reports. You can add the Report Viewer Web Part to any page or dashboard on a SharePoint site and customize its appearance. You can use SharePoint permission levels and roles to control access to report server content. You can also use SharePoint forms authentication to support access over Internet connections.
  • Support for additional languages. The Web application pages, Report Builder, and ReportBuilder.chm are available in the standard SQL Server languages (Chinese Simplified, Chinese Traditional, English, French, German, Italian, Japanese, Korean, Russian, and Spanish), and the following additional languages: Czech, Danish, Dutch, Finnish, Greek, Hungarian, Norwegian (Bokmal), Polish, Portuguese (Portugal), Portuguese (Brazilian), Swedish, and Turkish.

The Reporting Services Add-in works together with updated program files that are in SQL Server 2005 Service Pack 2 (SP2). SP2 is required on the report server and provides the following functionality for a report server that is configured for SharePoint integrated mode:

  • Synchronization from SharePoint content databases to the report server database.
  • A custom security extension that uses SharePoint permissions to control access to report server operations.
  • A new delivery extension that you can use in subscriptions to deliver reports to SharePoint libraries.
  • A revised Reporting Services Configuration tool that you can use to configure a report server for SharePoint integrated operations.
  • Publish reports and models from Report Designer and Model Designer to a SharePoint library.
  • Open reports and models in Report Builder from a SharePoint library, and save reports to SharePoint libraries across the site.
  • A new SOAP endpoint for managing report server content in SharePoint integrated mode.

The add-in is available as a download from Microsoft.

Configuring and Customizing the Content Query Web Part

A co-worker of mine linked me to this wonderful post with tips and tricks on configuring and customizing the lovely content query web parts in MOSS.

Adding table headers and/or footers to a Content Query Web Part Layout

A good post about playing with the ItemStyle.xsl and ContentQueryMain.xsl files can be found here:

Creating a MOSS 2007 VPC

The best resource that I have found to help in creating a MOSS 2007 VPC is found at

Microsoft Certified Techincal Specialist: Microsoft Office SharePoint Server 2007 (Application Development) Exam

During March 2007, Microsoft released exam 70-542 (TS: Microsoft Office SharePoint Server 2007 – Application Development). For my professional development, my boss has asked me to complete this exam in order to become certified in MOSS 2007 development. After doing some research, I found that there are no Microsoft endorsed courses for this exam and only a single book that covers some of the material covered by the exam. So, I am going to attempt at putting together a series of posts to help me prepare for the exam.

 The topics covered by the exam include:

  1. Managing Enterprise Content
  2. Creating Business Intelligence Solutions by Using Office SharePoint Server 2007
  3. Integrating Business Data with Office SharePoint Server 2007 by Using the Business Data Catalog (BDC)
  4. Accessing Office SharePoint Server Application Platform Services
  5. Searching Data by Using the Search Service
  6. Targeting Content Based on Audience Membership
  7. Customizing Functionality by Using Profiles

The target audience for the exam are MOSS 2007 consultants and developers who have the following experience:

  1. Six months to one year of experience developing applications by using Microsoft Office SharePoint Server 2007
  2. Experience using the following related technologies
    1. The Microsoft .NET Framework (at least six months with ASP.NET 2.0)
    2. Windows SharePoint Services development (six months to one year)
  3. Experience working with XML documents
  4. Experience with XML Web services development and consumption
  5. Working knowledge of Windows WorkFlow Foundation
  6. Working knowledge of IIS 6

There a number of skills that are measured by the exam. In the near future, you will find links to posts that cover the measured skills. Keep your eyes peeled.