The New World of SharePoint 2010 Administration

1. The New World of SharePoint 2010 Administration Mike Watson Sr. Product Mgr Quest Software Joel Oleson Sr. Architect Quest Software

2. Microsoft SharePoint 2010The Business Collaboration Platform for the Enterprise and the Web Sites Connect and Empower People Composites Communities Cut Costs with a Unified Infrastructure Insights Content Rapidly Respond to Business Needs Search

3. Was it Just Marketing???

4. You asked for… • Ability to Recover a file from the database… • Control over list sizes… • Better Disaster Recovery… • Easier to Manage… • Easier to Host… • More Insight and Extensible Reporting… • Health Management…

5. Agenda • A Day in the Life of A SharePoint Admin • Planning – Services, Hosting, Authentication • Operating – Throttling, Reporting, Improved Central Admin UI • Maintenance – Powershell, Import, Export, Granular Recovery, DR • Optimization – Performance, Health Rules, Dev Dashboard!

6. Planning Architecture Changes • SSP -> Service Apps • Search architecture changes – FAST! • Better Search Scalability • Redundant for Indexing – Integrated no longer single point of failure • DB changes • Office Web Apps • Tennant Admin • Claims based authentication

7. Server 2008 Style UI • Easier to find. • Contextual • Ribbon Improved Central Admin UI

8. New Databases

9. Farm Configuration Demo

10. SharePoint Best Practices Analyzer • Overview • Timer Based Scheduled Rules Check • Category based • Ability to self heal and take action automatically! • Example: Daily fix fragmented databases

11. Health Rules Runs on a Timer Job • Create your own! Best Practices Analyzer Repair Auto-magically!

12. Maintenance • Import/Export Lists • Backup a site collection with Central Admin • Recover from an unattached content database • Config backup • 400+ PowershellCommandlets to do essentially anything, and extensible for those they didn’t think of…

13. Powershell Your New Best Friend • Best way to learn powershell & SharePoint… get-help cmdlet-full • run Import-SPWeb-?. • $webapp = Get-SPWebApplication <web app url> • get-help get-SP* / get-help *Add* / get-help *Remove* - the * is wildcard. • get-help new-SPSite-examples • Things to know get-help, –examples, -full • 500+ Commands

14. Migration Comparisons…

15. Granular Restore/Export Options

16. Disaster Recovery Enhancements • Mirroring Aware! • No more SQL Aliases (unless u want them) • Failover connection string property fully supported - http://technet.microsoft.com/en-us/library/cc917713.aspx • Configuration based backup • Indexing - No Single Point of Failure!! • Mirroring support for DB’s • Redundant and assignable crawl components

17. Index Redundancy Enhancements

18. 2010 Backup & Recovery Enhancements demo Mike Watson

19. Insight on Upgrade • Binary Upgrade • In Place (New Continue on failures) • Database Attach (new! parallel) • No Gradual Upgrade (Side by Side Installation) • Visual Upgrade • Delegation

20. Less Abrasive Upgrade Process Enables compatibility check before committing.

21. Performance • Large List throttling - web app level control how users query and view data, set throttle controls on number of items returned • Developer Dashboard – Identify slow and resource intensive components on any page where they are rendered DB queries • SharePoint Workspace – Differencing Algorithm

22. Large List Throttling Configurable List Throttling And Thresholds You control when and how much! List throttling controls forces end users to create more efficient views with < x number of items.

23. Better Management of Dev Resources… • Sandboxing • Dev Dashboard (Really not just for devs) • Consistent 64 bit Dev and Prod

24. Turn on the Developer Dashboard • STSADM • C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\BIN>stsadm -o setproperty -pn developer-dashboard -pvondemand • Powershell • Run Powershell from the start menu as administrator by right clicking. • Execute a Dashboard.ps1 script file containing this: • $ddSettings = [Microsoft.SharePoint.Administration.SPWebService]::ContentService.DeveloperDashboardSettings; • $ddSettings.DisplayLevel = ‘OnDemand’; • $ddSettings.RequiredPermissions =’EmptyMask’; • $ddSettings.TraceEnabled = $true; • $ddSettings.Update() • Display Options = “On”, "Off" or "OnDemand"

25. Web Part Performance Dashboards

26. Reporting & Troubleshooting • Usage Reporting & Logging - enhancements and extensibility

27. Logging Database • CA > Monitoring > Configure Diag Logging • Powershell turn on Logging levels: • In PowerShell/OM you can configure the level of logging as well as specific events: • $prov=Get-SPDiagnosticsProvider job-diagnostics-uls-provider • $prov.ExcludedEventIDs=… • $prov.IncludedEventIDs=… • $prov.Level=…

28. Logs & Reporting to the DB Extensibility for reporting and possibilities are limitless

29. Quest Solutions for SharePoint Site Administrator for SharePoint Understand, manage and secure your SharePoint environment Quest SQL Server Solutions Maximize SQL Server performance while simplifying tasks and providing visibility and control • Quest Web Parts • Enable rapid development of SharePoint applications Recovery Manager for SharePoint Granular SharePoint recovery for enterprise-level needs Migration Manager for SharePoint SharePoint to SharePoint migration File Migrator for SharePoint File shares to SharePoint migration Public Folder Migrator for SharePoint Exchange Public Folders to SharePoint migration Notes Migrator for SharePoint Notes application content to SharePoint migration

30. What is Deployment Advisor Specifically?

31. Features

32. Credits • Screenshot Contributions: Henry Ong

33. © 2009 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.