S

sales approach, 446

same server, restoring, 134–138

Sarbanes-Oxley (SOX), 170, 200

SCAMPI (Standard CMMI Appraisal Method for Process Improvement) evidence, 157, 162

scenario

Agile Software Development, 154

capacity planning, 9

end user interaction with system, 277

use case versus, 154

schemas, database. See also Team Edition for Database Professionals

importing, 203–205

managing, 205

Schema Compare feature, 209–210

scope creep, 167

scripts, build

deploying to existing database, 208–209

transferring to Team System, 26

Scrum Process Template (Conchango)

classification, 173

described, 172

downloading, 169

groups and permissions, 173–175

process templates, 172–179

SCVs (special cause variations), 158

SDLC (software development lifecycle), 200

seamless tool integration, 381

searching work item store

My Queries folder, 291–292

query results, 292

Team Explorer window, 289–290

Team Queries folder, 290–291

Secure Socket Layer (SSL), 396

security

access problems

MSDN Forums, 117

Team Foundation Server, user cannot connect to, 117

team project, user cannot create, 117

best practices, 117–119

described, 95

HTTPS and SSL, 95

Internet Explorer, 59

Internet Explorer, authenticating with, 265

managing groups

adding users to groups with command line, 64, 110

adding users to groups with GUI, 108–109

adding users to groups with Team Explorer, 108–109

creating new groups with command line, 106–107

creating new groups with GUI, 103–106

model overview, 97

planning security, 14

security permissions, setting for groups with GUI, 110–112

security permissions, setting from Team Explorer window, 63, 64

security permissions, setting with command line, 112–113

model overview

default Allow permissions, 102–103

global groups, built-in, 97–99

managing groups, 97

other groups, managing, 100

permissions, 96–97

project groups, built-in, 99–100

Version Control Permissions, 101–102

Work Item Tracking Areas and Iterations, 102

permissions, setting on reports, 439–441

Team Foundation Build Server permissions, 92

Team Foundation Core Services

authorization object for interacting with, 236–237

described, 229, 231

IGroupSecurityService, 243–244

TFVC, 320

user and group authentication, 96

version control, 114–115

VSSConverter with Visual SourceSafe, 327

Work Item Tracking Areas permissions, 115–116

Security folder, 267

Semeniuk, Joel (process template editor creator), 172

server

restoring

to different, 138–143

to same, 134–138

Team Foundation Server Proxy, 401–403

/server option, Permissions command, 113

Service Pack 1 (SP1), Microsoft Windows Server 2003, 17

services

Team Foundation Core Services

authorization object for interacting with, 236–237

described, 229, 231

IGroupSecurityService, 243–244

TFSOM, accessing, 235–236

SetupWarehouse tool, 438–439

Shadow Modeling, 151

shared model, 310

shared networking option for Virtual PC, 58

shared repositories, 397

SharePoint Services 2.0 (SP2), Microsoft Windows

multiserver, 42–43

ProcessTemplate.xml, 171

single server, 48

SharePoint Services (Microsoft Windows)

components, 270

Conchango Scrum Process Template, 176–177

described, 125

firewall modifications, 45

site, 396–397

SharePoint Team Portal (Microsoft Windows)

browser, viewing reports, 13

components, architecture of, 256–257

customizing

document template schema, 268–269

logo, adding new, 267–268

name, changing, 272

process, 265–267

SharePoint components, 270

site contents, 270

themes, applying new, 270–271

using browser, 269–272

work products, adding, 269

described, 255–256

extensibility and customization overview, 257

Microsoft Office 2003, 257

template, incorporating design into custom

integrating site template within process template, 273–274

portal customizations, verifying, 274

steps, 272–273

users, granting access to, 65

verifying installation, 46

Web Parts

architecture, 256

ASP.NET work item application, 259–262

creating, 258

existing components, adding, 270

integrating ASP.NET work item application, 263–265

shelved changes and worksets, permissions to alter, 320

shelvesets, 320

shelving

best practices, 336

TFVC, 322–323

Shewhart, Walter A. (assignable cause variation, creator of), 168

short build cycles, 415

simple recovery mode, 124

single server installation, Team Foundation Server

described, 11

IIS, 48

.NET Framework 2.0 HotFix, 48

prerequisites, 47

process outlined, 47

SQL Server 2005, 48

SQL Server 2005 HotFix, 48

Team Foundation Server Services, 48–49

user permissions, setting, 47–48

verifying and completing, 49

Windows SharePoint Services 2.0 (SP2), 48

site contents, Windows SharePoint Team Portal, 270 64

-bit support, Team Foundation Server, 17

small development team, 414

small-to-medium deployments, 10

SOAP request and response, 400

software

infrastructure data, 7

projects, failure rate of, 155–156

software development lifecycle (SDLC), 200

Software Engineering with Microsoft Visual Studio Team System (Guckenheimer), 347

software requirements

Team Foundation Server

Microsoft Windows Server 2003 with Service Pack 1 (SP1), 17

required service packs and software components, 17

Team Foundation Build, 18

test controller, 19

unsupported software, 19

Visual Studio 2005 and Team Explorer, 18

Virtual PC, 52–53

source code, documenting, 7

Source Control Explorer

described, 320–321

security, setting, 321–322

Source Control Settings, TFVC, 323–324

source files, 318–319

SOX (Sarbanes-Oxley), 170, 200

SP1 (Service Pack 1), Microsoft Windows Server 2003, 17

SP2 (Windows SharePoint Services 2.0)

multiserver, 42–43

ProcessTemplate.xml, 171

single server, 48

Spanish language support, 417

special cause variations (SCVs), 158

spreadsheet software

administration, 293–294

checklist of software, hardware, and necessary tasks, 8

Choose Team Project button, 352

as client component, 6

connecting to Team Foundation Server, 13

team portal, integrating, 257

Team Project areas and iterations, modifying, 196

work item

summaries, viewing with pivot tables, 364–367

tracking system, 275, 293–294

SQL Reporting Services, 65

SQL Server 2005

data tier

authentication, caution against, 117–118

backing up, 126–131

described, 9

instance license, 36

dual-server scenario, 16

installation

databases, 39–40

firewall modifications, 39

HotFix, 38–39

starting, 36–38

verifying, 46

multiserver installation, 36–40

single server, 48

software requirements, 17

template information, storing, 257

SQL Server 2005 Backup and Restore, 123–124

SQL Server 2005 Enterprise Edition, 438

SQL Server 2005 HotFix, 48

SQL Server Analysis Server database, 125

SQL Server Reporting Services

architecture, 420–421

Conchango Scrum Process Template, 175

custom Team System reports

described, 429

project data, mining with Excel pivot table report, 429–431

Report Builder, 432–433

Report Designer, creating with, 431–432

custom VSTS reports, 428

customization and extensibility, advanced, 433–434

data warehouse

administering and refreshing, 438

common problem, 437

core components, 422–423

operational stores and adapters, 423

relational database (fact tables), 424–425

Warehouse Setup Tool (SetupWarehouse), 438–439

deploying reports in Team System, 434–436

described, 26, 419–420

details, 427

dimensions, 426–427

managing reports, 436–437

measures, 425–426

MSF documentation, 427–428

OLAP, 421–422

security permissions, setting on reports, 439–441

SSL (Secure Socket Layer), 396

SSL security, 95

standalone build server, 73

Standard CMMI Appraisal Method for Process Improvement (SCAMPI) evidence, 157, 162

Standish Group "CHAOS Report," 155

star schema, data warehouse, 424

Start date, 362

status, tracking via Outlook, 389–392

Stebner, Aaron (Visual Studio 2005, installing on pre-Service Pack 2 system), 18

stopping services, application tier, 141

stored procedures, retrieving credit card numbers, 206–207

string literals, 298

STS_Config database, 125

STS_Content_TFS database, 125

subscribing to events, 231–232, 241–242

subversion, TFVC, 303

summary tasks

managing, 356–358

synchronization, disabling, 357

synching redundant files and folders, 93