FEBRUARY 28th 2008 meeting

1. Arizona SharePoint Professionals Group FEBRUARY 28th 2008meeting

2. Agenda Survey Results Community News Quest for Better Tools March Meeting Madness Let’s Talk About Deployment Use it if you got it!!! Raffle

3. Today’s Sponsor http://www.quest.com

5. Community News • Windows Server 2008, Visual Studio 2008 and SQL Server 2008* Launch • Office SharePoint Conference 2008 (3-3-08) (Sold Out) • TechEd (6-10-08) • MOSS Faceted Search • SPConfigurator • Deployment Guide and Checklist • SDK Updates for SP1 & Post SP1 Hotfix • Next AZSPG - 3-27-08 • Office Interactive Developer Map • SharePoint Inventory Asset Tracker

6. MOSS Faceted Search http://www.codeplex.com/FacetedSearch Grouping search results by facet Displaying a total number of hits per facet value Refining search results by facet value Update of the facet menu based on refined search criteria Displaying of the search criteria in a Bread Crumbs Ability to exclude the chosen facet from the search criteria Flexibility of the Faceted search configuration and its consistency with MOSS administration

7. Capacity Planning Tool RTM SharePoint Capacity Planning Model http://www.microsoft.com/downloads/details.aspx?FamilyId=DBEE0227-D4F7-48F8-85F0-E71493B2FD87&displaylang=en Microsoft Capacity Planner http://technet.microsoft.com/en-us/sccp/bb969059.aspx

8. Deployment Guide and Checklist http://office.microsoft.com/download/afile.aspx?AssetID=AM102552101033

9. SDK Updates for SP1 • SharePoint Server 2007 SDK v1.3 • http://www.microsoft.com/downloads/details.aspx?FamilyId=6D94E307-67D9-41AC-B2D6-0074D6286FA9&displaylang=en • WSS SDK v1.3 • http://www.microsoft.com/downloads/details.aspx?familyid=05E0DD12-8394-402B-8936-A07FE8AFAFFD&displaylang=en • Post SP1 Hotfixes • WSS - http://support.microsoft.com/kb/941422 • MOSS - http://support.microsoft.com/kb/941274

10. Office Interactive Developer Map http://msdn.microsoft.com/office/devmap

11. March Meeting • Community News • What You Need to Know: Windows 2008 & WSS 3.0 • How to do team development with TFS, WSS, MOSS & Visual Studio • Search Server 2008 and MOSS Search Enhancement Pack • Rapid-Fire for Five – 5 Tips and Tricks from the field

12. Introducing…

13. Let’s Talk About Deployment…

14. Brief Poll How many of you are already deployed on a version of SharePoint? How many of you are using SharePoint for more than intranet collaboration? Extranet? Internet? How many of you have more than 100 users? 1,000 users? 10,000 users? 100,000 users? How long did you spend planning? 1 month? 3 months? 6 months? More?

15. Pitfall #1 • Know why you’re deploying SharePoint! • Collaboration • Application platform • Extranet • Content Management • Search

16. Pitfall #2 • Don’t underestimate information architecture! • Landing pages • Search pages • Departmental or Functional or Both? • Site map(s) • Content types and metadata

17. Pitfall #3 • Don’t forget the basics • Communications • SLAs • Change management • Support • Cost • Team • Sponsorship – high-level or grassroots

18. Pitfall # 4 • Operations, operations, operations how did we forget operations! • Backup and Restore…make sure it works! • Counters • Alerts • Events • Patching • Deploying

19. Objects and Counters • Objects • Excel Calculation Services • Excel Services Web Front End • Excel Web Access • Office Server Search Gatherer • Office Server Indexer Catalogs • Shared Service Provider • Web Service • Web Service Cache • Counters • Document Conversions Pending Conversions • Document Conversions Incoming E-Mail Messes Process • Excel Calculation Services Active Requests • Excel Calculation Services Average Request Processing Time • Excel Calculation Services Cached Charts Requested/sec • Excel Calculation Services Average Session Time • Excel Calculation Services Current Size of memory cache • Excel Calculation Services Workbook Cache Size • Excel Calculation ServicesRendered Charts Requested per second • Excel Calculation ServicesRequests received per second • Excel Calculation ServicesRequest with error per second • Excel Calculation Services Sessions per second • Excel Services Web Front End Active Requests • Excel Services Web Front End Average Requests Processing Time • Excel Services Web Front End Requests Per Second • Excel Web Access Average Chart Image Request Time • Excel Web Access Chart Image Requests Per Second • Excel Web Access Request Time • InfoPath Forms Services # Business Logic Assemblies in Memory • InfoPath Forms Services # of Cached Form Templates • InfoPath Forms Services # of Form Templates in memory • InfoPath Forms Services # of Forms in Memory • InfoPath Forms Services Avg. Data Adapter Query Duration • InfoPath Forms Services Avg. Data Connection Submit Duration • InfoPath Forms Services Data Connection Query Completed Rate • InfoPath Forms Services Data Connection Query Failure Rate • InfoPath Forms Services Data Connection Query Started Rate • InfoPath Forms Services Data Connection Submit Completed Rate • InfoPath Forms Services Data Connection Submit Started Rate • InfoPath Forms Services Data Connection Submit Failure Rate • InfoPath Forms Services Session Started Rate • InfoPath Forms Services Transactions Complete Rate • InfoPath Forms Services Transactions Started Rate • Office Server Search Gatherer Accessing Robots.txt file • Office Server Search Gatherer Active Queue Length • Office Server Search Gatherer Admin Clients • Office Server Search Gatherer All Notificatoins received • Office Server Search Gatherer Delayed Documents • Office Server Search Gatherer Document Entries • Office Server Search Gatherer Documents Delayed Retry • Office Server Search Gatherer Filtered • Office Server Search Gatherer Filtered Rate • Office Server Search Gatherer Documents Successfully Filtered • Office Server Search Gatherer Documents Successfully Filtered Rate • Office Server Search Gatherer Ext. Notifications Rate • Office Server Search Gatherer Ext. Notifications Received • Office Server Search Gatherer Filter Objects • Office Server Search Gatherer Filter Process Created • Office Server Search Gatherer Processes • Office Server Search Gatherer Processes Max • Office Server Search Gatherer Filtering Threads • Office Server Search Gatherer Heartbeats • Office Server Search Gatherer Heartbeats Rate • Office Server Search Gatherer Idle Threads • Office Server Search Gatherer Notification Sources • Office Server Search Gatherer Notifications Rate • Office Server Search Gatherer Performance Level • Office Server Search Gatherer reason to back off (love that one!!) • Office Server Search Gatherer Robots.txt Requests • Office Server Search Gatherer server objects • Office Server Search Gatherer server objects created • Office Server Search Gatherer servers currently unavaible • Office Server Search Gatherer unavailable • Office Server Search Gatherer Stemmers cached • Office Server Search Gatherer system IO Traffic rate • Office Server Search Gatherer Threads Accessing Network • Office Server Search Gatherer Threads blocked due to back off • Office Server Search Gatherer Threads in plug-ins • Office Server Search Gatherer Time Outs • Office Server Search Gatherer Word Breakers cached • Office Server Search Indexer Catalogs Active Connections (AnchorProject, Portal_Content) • Office Server Search Indexer Catalogs Document Filtered • Office Server Search Indexer Catalogs Index Size • Office Server Search Indexer Catalogs L0 Indexes • Office Server Search Indexer Catalogs L0 Merge • Office Server Search Indexer Catalogs L0 Merge (flush) - Count • Office Server Search Indexer Catalogs L0 Merge (flush) – Speed Average • Office Server Search Indexer Catalogs L0 Merge (flush) – Speed Last • Office Server Search Indexer Catalogs L0 Merges (flushes) Now • Office Server Search Indexer Catalogs L1 Merge Count • Office Server Search Indexer Catalogs L1 Merge Speed Average • Office Server Search Indexer Catalogs L1 Merge Speed Last • Office Server Search Indexer Catalogs L1 Merges Now • Office Server Search Indexer Catalogs L2 Merge Count • Office Server Search Indexer Catalogs L2 Merge Speed Average • Office Server Search Indexer Catalogs L2 Merge Speed Last • Office Server Search Indexer Catalogs L2 Merges Now • Office Server Search Indexer Catalogs L3 Merge Count • Office Server Search Indexer Catalogs L3 Merge Speed Average • Office Server Search Indexer Catalogs L3 Merge Speed Last • Office Server Search Indexer Catalogs L3 Merges Now • Office Server Search Indexer Catalogs L4 Merge Count • Office Server Search Indexer Catalogs L4 Merge Speed Average • Office Server Search Indexer Catalogs L4 Merge Speed Last • Office Server Search Indexer Catalogs L4 Merges Now • Office Server Search Indexer Catalogs L5 Merge Count • Office Server Search Indexer Catalogs L5 Merge Speed Average • Office Server Search Indexer Catalogs L5 Merge Speed Last • Office Server Search Indexer Catalogs L6 Merges Now • Office Server Search Indexer Catalogs L6 Merge Count • Office Server Search Indexer Catalogs L6 Merge Speed Average • Office Server Search Indexer Catalogs L6 Merge Speed Last • Office Server Search Indexer Catalogs L6 Merges Now • Office Server Search Indexer Catalogs L7 Merge Count • Office Server Search Indexer Catalogs L7 Merge Speed Average • Office Server Search Indexer Catalogs L7 Merge Speed Last • Office Server Search Indexer Catalogs L7 Merges Now • Office Server Search Indexer Catalogs L8 Merge Count • Office Server Search Indexer Catalogs L8 Merge Speed Average • Office Server Search Indexer Catalogs L8 Merge Speed Last • Office Server Search Indexer Catalogs L8 Merges Now • Office Server Search Indexer Catalogs Master Index Level • Office Server Search Indexer Catalogs Master Merge Progress • Office Server Search Indexer Catalogs Master Merges Now • Office Server Search Indexer Catalogs Master Merges to Date • Office Server Search Indexer Catalogs Out-of-date Document ID Files • Office Server Search Indexer Catalogs Persistent Indexes • Office Server Search Indexer Catalogs Persistent Indexes 1 • Office Server Search Indexer Catalogs Persistent Indexes 2 • Office Server Search Indexer Catalogs Persistent Indexes 3 • Office Server Search Indexer Catalogs Persistent Indexes 4 • Office Server Search Indexer Catalogs Persistent Indexes 5 • Office Server Search Indexer Catalogs Persistent Indexes 6 • Office Server Search Indexer Catalogs Persistent Indexes 7 • Office Server Search Indexer Catalogs Persistent Indexes 8 • Office Server Search Indexer Catalogs Queries • Office Server Search Indexer Catalogs Queries Failed • Office Server Search Indexer Catalogs Queries Succeeded • Office Server Search Indexer Catalogs Shadow Merge Levels • Office Server Search Indexer Catalogs Shadow Merge Levels Threshold • Office Server Search Indexer Catalogs Unique Keys • Office Server Search Indexer Catalogs Up-to-date Document ID Files • Office Server Search Indexer Catalogs Work Items Created • Office Server Search Indexer Catalogs Work Items Deleted • Project Server:QueueGeneral (and a lot more Project server, but not here) • Shared Services Provider DL Import Rate • Shared Services Provider Number of DLs imported • Shared Services Provider Number of Users imported • Shared Services Provider Personal Site Latency • Shared Services Provider Personal Site Throughput • Shared Services Provider Profile Sync Change Process Rate • Shared Services Provider Profile Sync Content Database Process Count • Shared Services Provider Profile Sync Copy Rate • Shared Services Provider Profile Sync Count Columns Created • Shared Services Provider Profile Sync Site Collection Process Count • Shared Services Provider Public Site Latency • Shared Services Provider Public Site Throughput • Shared Services Provider SSP Job Excecution Rate • Shared Services Provider Usage data processing time (ms) • Shared Services Provider User profile import rate • SharePoint Publishing Cache Publishing flushes / sec • SharePoint Publishing Cache Publishing hit count • SharePoint Publishing Cache Publishing hit ratio • SharePoint Publishing Cache Publishing hits / sec • SharePoint Publishing Cache Publishing miss count • SharePoint Publishing Cache Publishing misses / sec • SharePoint Publishing Cache Total Blob Disk Size • SharePoint Publishing Cache Total Blob index writes • SharePoint Publishing Cache Total number of cache compactions • SharePoint Publishing Cache Total number of cache flushes • SharePoint Publishing Cache Total number of objects added • SharePoint Publishing Cache Total objects discards • SharePoint Publishing Cache Total Objects

20. Events • Crawler cannot read from registry • Crawler exception • Failed to load index • Failed to load protocol handler • Failed to load word breaker • Index is corrupt • Instance of search could not be initialized • Insufficient disk space • Internal plug-in error • Locale ID has changed • Master merge error • Plug-in failed to connect to SQL Server • SQL Server database error • Event handler failed to load • Failed to load safe control assembly path • Access denied for writing to disk • Access denied for writing to registry • An error occurred while communicating with the SMTP server • Cannot connect to the SMTP host • Cannot resolve name of the outbound SMTP server • Unable to create a log file • Unable to write to trace log • Alternate access mappings update failed • Failed to create a SharePoint site • Insufficient permissions to write to the configuration data cache • Service instance provisioning failed • SharePoint Administration services is disabled • Cannot connect to SQL Server • Insufficient SQL Server database permissions • SQL Server database is full • SQL Server database login failed • Backup failed due to insufficient permissions • Backup failed due to timer job failure • The second stage recycle bin has reached 90% capacity • The application pool account must be registered as a Kerberos service provider • Unable to load authentication provider • The Active Directory organization unit registered in Windows SharePoint Services does not exist • The application pool account has insufficient permissions to add user accounts to Active Directory • The application pool account has insufficient permissions to read user data from Active Directory • Administration site for the Shared Services Provider is missing • Enabling features failed on some sites • Enabling features on existing sites failed • Failed to connect to parent server farm • Shared Services Provider provisioning failed • Shared Services Provider synchronization failed • Site Directory scan job failed • The Microsoft Single Sign-On Services is not running • The Office Document Conversion Launcher Services is not running • The Office Document Conversions Load Balancer Services is not running • The Office SharePoint Server Search is not running • A Content Query Web Part failed to return content • Spelling checker failed to load • The page editing toolbar detected missing or corrupted configuration files in the Master Page Gallery • Cannot initialize disk-based cache because the specified location is inaccessible • Could not parse the regular expression for disk-based cache • The disk-based cache exceeded the specified limit • The location specified for the disk-based cache is no longer accessible • The object cache exceeded its maximum assigned size • A site copy operation has failed, leaving the site structure in an unusual state • A site deletion operation has failed, leaving the site structure in an unusual state • A site move operation has failed, leaving the site structure in an unusual state • Error communicating with Excel Calculation Services • Excel Calculation Services is not running locally • Excel Calculation Services not available • Incorrect URL for Excel Calculation Services • Invalid File Access method configured • Invalid SessionID in the request • Maximum memory configured for Excel Calculation Services has been exceeded • Memory allocation failed • Single Sign-On failure • SSL is required but not configured • Unable to delegate credentials • Unable to establish a connection with Excel Calculation Services • Unauthorized attempt to access a session • Workbook disk cache cannot be created • Workbook disk cache is full • A form template’s business logic caused an OutOfMemory exception • Exception occurred while processing an InfoPath form template request • InfoPath form templates have conflicting business logic assembly identities • InfoPath Forms Services business logic attempted to store a nonserializable object • InfoPath Forms Services business logic exceeded the maximum limit of operations • InfoPath Forms Services business logic exception occurred while loading a form template • InfoPath Forms Services calculations exceeded the maximum limit • InfoPath Forms Services cannot find or load ifsFileNames.xml • InfoPath Forms Services event counter mismatch • InfoPath Forms Services failed to load a form template • InfoPath Forms Services found an unexpected session state version • InfoPath Forms Services postback failure • InfoPath Forms Services rules exceeded the maximum limit • InfoPath Forms Services user has exceeded the maximum number of actions per postback • InfoPath Forms Services user has exceeded the maximum session state size • InfoPath Forms Services was running business logic when ASP.NET request timed out • User has exceeded the maximum allowable number of postbacks • Database out of space • Error backing up registry to Shared Services Provider database • Failure to commit to SQL • Instance of search could not be initialized • Insufficient disk space • Locale ID has changed • SQL Server Database Error • Crawl failed because no contact e-mail is set • Crawler cannot read from registry • Crawler exception • Encountered errors while indexing anchor text • Failed to load index • Failed to load protocol handler • Failed to load word breaker • Index is corrupt • Internal plug-in error • Internal plug-in error – Consolidator • Master merge error • Plug-in failed to connect to SQL Server • Publication of ranking information failed • Propagation failed to communicate with a query server • Propagation of the content index paused because of a lagging query server • Query server removed from rotation • The last query server was removed from rotation • Error adding enterprise application definition • Error adding enterprise application definition - Consolidator • Error deleting enterprise application definition • Error deleting enterprise application definition - Consolidator • Error retrieving credentials • Error retrieving credentials - Consolidator • Error retrieving cryptographic sign • Error retrieving cryptographic sign – Consolidator • Failed to load Single Sign-On configuration settings • Internal Single Sign-On service error • Microsoft Single Sign-On service failed to start • Microsoft Single Sign-On service failed to stop • Remote Procedure Call service failed to start • Remote Procedure Call service failed to stop • Single Sign-On audit failure • Audience Compilation failed • Content Database Synchronization failed • Membership Import failed • My Site Creation failure • Profile Import Failed • Site Synch failed • Sweep Synch failed • Synch Job Scheduler failed • User Profile Commit failure • User Profile Property Conversion failed

21. Pitfall #5 • Don’t underestimate security and how long it might take • Kerberos is hard! • Managing groups is hard! • Using non-AD authentication source is hard!

22. Pitfall #6 • Governance is not all it’s cracked up to be! • Governance is a great idea • Creating a governance plan is like having a cavity filled without novocain • Don’t forget the basics • Managing changes and customization • Retention policies • Provisioning and de-provisioning….including users!

23. Governance Resources

24. Steps to a Successful Deployment • Consistency of platform, browsers, collaboration and enterprise search strategy. • Manage as centrally as possible with a tight team with a means to communicate to the Cxos that have a vested interest. • Have a killer backup strategy that meets the needs of your business and make sure it works before day one. • End-user training and education in addition to good content and search is the key to end user adoption. • Have a Governance and Information Management Plan. Branding consistency with a corporate style guide and consistent taxonomy. Make approved master pages available in site galleries for consistency which will inform users they are on the corporate Intranet. • Enforce workflows and approval on document centers and pages where official documentation comes together. Leverage version history and version control to maintain a history and master document that all can refer to. • Life cycle managed site collections, and document libraries with information management policies such as content types with auditing and expiration. • Properly secure corporate assets. Sites with (PII) personally identifiable information should be appropriately flagged and secured and audited. • A corporate browse and search strategy for the enterprise will ensure you are making the most out of your intranet assets as well as encourage culture change, best practices and adoption. • Platform Usage Policies and development and test environments ensure only the code you want to introduce follows corporate guidelines and will ensure the environment is supportable and able to maintain SLAs (Service Level Agreements).