Steven Borg | Co-founder & Strategist, Northwest Cadence

1. 03a | Manage Team Foundation Server Steven Borg | Co-founder & Strategist, Northwest Cadence Anthony Borton | ALM Consultant, Enhance ALM

2. Module Overview • Manage Team Project Collections • Configure for backup and recovery • Monitor server health and performance • Operate Lab Management • Manage security • Manage reporting for Team Foundation Server

3. Manage Team Project Collections

4. What the Study Guide says… • Manage Team Project Collections. • moving project collections • managing team collections and projects • creating and configuring Team Project Collections • creating a team project using SharePoint and SQL Server Reporting Services (SSRS) • splitting and partitioning team project collections

5. MSDN Resources

6. Team Project Collection Architecture

7. Create a Team Project Collection • Use the TFS Admin Console • Follow the Wizard

8. Create a Team Project (w/ SharePoint and SSRS) • Use VS 2012 TeamExplorer • Follow theWizard

9. Move a Team Project Collection • Move the Site Collection Database • Restore the Collection Database • Attach the Collection • Move Reports • Reconnect Resources for the SharePoint Web Application • Configure the Moved Team Project Collection • Configure Lab Management Resources • Configure Project Server Integration • Configure Projects • Required Permissions • Save Reports • Delete Lab Management Resources • Unmap the Collection from Microsoft Project Server • Detach the Collection • Back Up the Collection Database • Rebuild the Data Warehouse and Analysis Services • Prepare to Move the Site Collection Database

10. Split a Team Project Collection • Start the Collections • Rebuild the Data Warehouse and Analysis Services • Reconfigure Team Project Portals • Configure Lab Management Resources • Configure Users and Groups for the Split Team Project Collections • Configure Users and Groups for Projects • Split the Original Site Collection to Support the Split Team Project Collections • Synchronize Integration with Microsoft Project Server • Delete Lab Management Resources • Detach the Collection • Back Up the Collection Database • Restore the Collection Database With A Different Name • Attach the Original Collection Database • Attach the Renamed Collection Database • Delete Projects From the Split Collections • Reconnect SharePoint Web Application Resources • Split Reports

11. Split a Team Project Collection - Simple • Detatch Original TPC • Copy Original DB and restore with New DB name • Attach Original TPC • Attach New TPC • Clean up Team Projects

12. TfsConfig.exe Collections

13. Manage Team Project Collections

14. Configure for backup and recovery

15. What the Study Guide says… • Configure for backup and recovery. • backup and recovery of Team Foundation Server and related components • recovering a failed application tier • recovering a failed database tier • implementing a disaster recovery plan

16. MSDN Resources

17. Databases needed for Backup and Recovery

18. Backing up TFS • Manually backing up TFS • HARD • http://examcr.am/15hOm4P • Using the Database Backup Tools (TFS 2012 Power Tools) • EASY – Follow the wizard • (But not on exam since it’s part of the power tools) • Using the Scheduled Backup feature (Update 2) • EASY – Follow the wizard • (But not on exam since it’s part of Update 2) • http://examcr.am/11n8LED

19. Recover an application tier • Simply install a new application tier • Be sure to create the right security accounts on the new hardware • All TFS Administrators must be added to the AT’s local Administrators group • Run the Application-Tier Only wizard from the TFS 2012 install media • Run the TFS Administration Console • Choose Application Tier -> Change URLs • Enter the URL to the new Application Tier Pro Tip: You can also use the Change URLs window to allow TFS to use a fully qualified name such as tfs.nwcadence.com

20. Recover a data tier • Restore the databases to a new SQL Server • Run the TFSConfigRemapDBscommand Pro Tip: With Update 2, this is now much easier since you can use the Scheduled Backup feature TFSConfigRemapDBs /DatabaseName:ServerName;DatabaseName /SQLInstances:ServerName1,ServerName2 [/AnalysisInstance:ServerName] [/AnalysisDatabaseName:DatabaseName] [/preview] [/continue] [/usesqlalwayson]

21. Refreshing Data Caches on Client Computers • If Work Item caches are causing errors, invoke the StampWorkitemCache web method • On the New Server, and only once for entire organization • http://{tfsName}:8080/WorkItemTracking/v3.0/ClientService.asmx • Invoke StampWorkitemCache method • If Version Control cache is causing errors, invoke the tf.exeworkspaces command • On every client computer in the organization • tf workspaces /collection:http://{tfsName}:8080/tfs/CollectionName

22. Configure for backup and recovery

23. Monitor server health and performance

24. What the Study Guide says… • Monitor server health and performance. • monitoring the server for performance issues (monitoring activity logging database and Team Foundation Server manager) • monitoring the job infrastructure for failed jobs (monitoring warehouse adapters and warehouse jobs) • cleanup of stale workspaces and shelvesets • setting up Team Foundation Build to use a version control proxy server

25. MSDN Resources

26. Monitoring warehouse adapters and jobs • WarehouseControlWebService • http://localhost:8080/tfs/TeamFoundation/Administration/v3.0/WarehouseControlService.asmx

27. Performance of individual commands • Dbo.tbl_Command • Found in Tfs_Configuration database • Measures performance of individual commands • http://localhost:8080/tfs/_oi • Activity log • Job monitoring

28. Cleaning up stale workspaces and shelvesets • Tfshelvesets • Lists information about shelvesets • Tf shelve • Create or delete a shelveset • Tf status • Displays information about pending changes • Tf workspaces • List all the workspaces for a person • Update user name or computer name • Tf workspace • Create or delete workspace • Change workspace properties

29. Configure Team Build to use a Proxy Server • On the server that is running Team Foundation Build Service, click Start, click Run, type regedit, and then click OK. • In the browser pane, expand HKEY_CURRENT USER to HKEY_CURRENT_USER\Software\Microsoft\VisualStudio\10.0\TeamFoundation\SourceControl\Proxy. • In the details pane, set Enabled to True, and then set URL to http://ProxyServer:Port. • ProxyServer is the name of the proxy server that you want Team Foundation Build Service to use, and Port is the number of the port on which the proxy server is listening for requests. (By default, this number is 8081.) • On the File menu, click Exit to close Registry Editor.

30. Monitor server health and performance

31.  EXAM BEST BETS • Focus on what’s possible rather than the deep technical details • Learn the basics for Splitting a TPC rather than the set of steps or commands • Understand the command line tools that are related to TFS administration • TfsConfig.exe • Tf.exe – selected commands (workspaces, workspace, status, shelve, shelvesets, undo, etc) • Realize that the tools you really use to manage performance and health of TFS aren’t on the exam • You have to study other approaches that are infrequently, if ever, used in real life