2014 09-20 - spsnj - worst practices of sharepoint

70
SPSNJ

Upload: dan-usher

Post on 25-May-2015

325 views

Category:

Technology


1 download

DESCRIPTION

Just starting off in the field of SharePoint? Check this session out to avoid the mistakes I've made.

TRANSCRIPT

Page 1: 2014 09-20 - SPSNJ - Worst Practices of SharePoint

SPSNJ

Page 2: 2014 09-20 - SPSNJ - Worst Practices of SharePoint
Page 3: 2014 09-20 - SPSNJ - Worst Practices of SharePoint
Page 4: 2014 09-20 - SPSNJ - Worst Practices of SharePoint

Dan Usher

Senior Lead Engineer

Booz Allen Hamilton

[email protected]

http://www.sharepointdan.com

@binarybrewery

Page 5: 2014 09-20 - SPSNJ - Worst Practices of SharePoint
Page 6: 2014 09-20 - SPSNJ - Worst Practices of SharePoint
Page 7: 2014 09-20 - SPSNJ - Worst Practices of SharePoint
Page 8: 2014 09-20 - SPSNJ - Worst Practices of SharePoint
Page 9: 2014 09-20 - SPSNJ - Worst Practices of SharePoint
Page 10: 2014 09-20 - SPSNJ - Worst Practices of SharePoint

What about…

Making an Internet site…

Page 11: 2014 09-20 - SPSNJ - Worst Practices of SharePoint

Maybe I could use it for…

Point of sales…

Page 12: 2014 09-20 - SPSNJ - Worst Practices of SharePoint

http://bit.ly/1kROl1L

http://bit.ly/1ksExqa

Page 13: 2014 09-20 - SPSNJ - Worst Practices of SharePoint

Good thing those are the only challenges…

Right?

Or maybe not…

Page 14: 2014 09-20 - SPSNJ - Worst Practices of SharePoint
Page 15: 2014 09-20 - SPSNJ - Worst Practices of SharePoint
Page 16: 2014 09-20 - SPSNJ - Worst Practices of SharePoint
Page 17: 2014 09-20 - SPSNJ - Worst Practices of SharePoint
Page 18: 2014 09-20 - SPSNJ - Worst Practices of SharePoint
Page 19: 2014 09-20 - SPSNJ - Worst Practices of SharePoint
Page 20: 2014 09-20 - SPSNJ - Worst Practices of SharePoint
Page 21: 2014 09-20 - SPSNJ - Worst Practices of SharePoint
Page 22: 2014 09-20 - SPSNJ - Worst Practices of SharePoint
Page 23: 2014 09-20 - SPSNJ - Worst Practices of SharePoint
Page 24: 2014 09-20 - SPSNJ - Worst Practices of SharePoint
Page 25: 2014 09-20 - SPSNJ - Worst Practices of SharePoint
Page 26: 2014 09-20 - SPSNJ - Worst Practices of SharePoint

Cloud

Provider-hosted

SharePoint

Existing sites and services

app web (optional)

Dedicated server / hosting service

REST + OAuth or client object models

SharePoint-hostedSharePoint

Existing sites and services

app web

Page 27: 2014 09-20 - SPSNJ - Worst Practices of SharePoint
Page 28: 2014 09-20 - SPSNJ - Worst Practices of SharePoint

So

urc

eSean M

cDo

no

ug

h@

spm

cd

ono

ug

h

Page 29: 2014 09-20 - SPSNJ - Worst Practices of SharePoint
Page 30: 2014 09-20 - SPSNJ - Worst Practices of SharePoint
Page 31: 2014 09-20 - SPSNJ - Worst Practices of SharePoint
Page 32: 2014 09-20 - SPSNJ - Worst Practices of SharePoint
Page 33: 2014 09-20 - SPSNJ - Worst Practices of SharePoint
Page 34: 2014 09-20 - SPSNJ - Worst Practices of SharePoint
Page 35: 2014 09-20 - SPSNJ - Worst Practices of SharePoint
Page 36: 2014 09-20 - SPSNJ - Worst Practices of SharePoint
Page 37: 2014 09-20 - SPSNJ - Worst Practices of SharePoint
Page 38: 2014 09-20 - SPSNJ - Worst Practices of SharePoint
Page 39: 2014 09-20 - SPSNJ - Worst Practices of SharePoint
Page 41: 2014 09-20 - SPSNJ - Worst Practices of SharePoint
Page 42: 2014 09-20 - SPSNJ - Worst Practices of SharePoint
Page 43: 2014 09-20 - SPSNJ - Worst Practices of SharePoint
Page 44: 2014 09-20 - SPSNJ - Worst Practices of SharePoint

Capacity requirements for the Web Analytics Shared Service in SharePoint Server 2010

Page 45: 2014 09-20 - SPSNJ - Worst Practices of SharePoint

Dataset Characteristics Value

SharePoint components 30k

Unique users 117k

Unique queries 68k

Unique assets 500k

Reporting DB data size? 200GB per day

Capacity requirements for the Web Analytics Shared Service in SharePoint Server 2010

Page 46: 2014 09-20 - SPSNJ - Worst Practices of SharePoint

Dataset Characteristics Value

SharePoint components 30k

Unique users 117k

Unique queries 68k

Unique assets 500k

Reporting DB data size? 73TB per year

Capacity requirements for the Web Analytics Shared Service in SharePoint Server 2010

Page 47: 2014 09-20 - SPSNJ - Worst Practices of SharePoint

Dataset Characteristics Value

SharePoint components 30k

Unique users 117k

Unique queries 68k

Unique assets 500k

Reporting DB data size? 511TB for 7 years

Capacity requirements for the Web Analytics Shared Service in SharePoint Server 2010

Page 48: 2014 09-20 - SPSNJ - Worst Practices of SharePoint
Page 49: 2014 09-20 - SPSNJ - Worst Practices of SharePoint
Page 50: 2014 09-20 - SPSNJ - Worst Practices of SharePoint

> $webApp = Get-SPWebApplication("http://intranet.contoso.com")> $webApp.AllowedInlineDownloadMimeTypes.Add("application/pdf")> $webApp.Update()

Page 51: 2014 09-20 - SPSNJ - Worst Practices of SharePoint
Page 52: 2014 09-20 - SPSNJ - Worst Practices of SharePoint
Page 53: 2014 09-20 - SPSNJ - Worst Practices of SharePoint
Page 54: 2014 09-20 - SPSNJ - Worst Practices of SharePoint
Page 55: 2014 09-20 - SPSNJ - Worst Practices of SharePoint
Page 57: 2014 09-20 - SPSNJ - Worst Practices of SharePoint
Page 58: 2014 09-20 - SPSNJ - Worst Practices of SharePoint

TechNet

CodePlex

> $passphrase = ConvertTo-SecureString -asPlainText -Force> Set-SPPassPhrase -PassPhrase $passphrase -Confirm

Page 59: 2014 09-20 - SPSNJ - Worst Practices of SharePoint

<psuedocode>if (!server.HasInternetConnectivity()) {

server.DisableCRLCheck();}

</psuedocode>

Certificate Revocation List Check and SharePoint 2010 without an Internet Connection

SOFTWARE\Microsoft\Windows\CurrentVersion\WinTrust\Trust Providers\Software Publishing

Page 60: 2014 09-20 - SPSNJ - Worst Practices of SharePoint
Page 61: 2014 09-20 - SPSNJ - Worst Practices of SharePoint
Page 62: 2014 09-20 - SPSNJ - Worst Practices of SharePoint

Account Purpose Requirements

SQL Server Runs SQL Server • Domain user account

• No rights in SharePoint

Setup Account Installs the bits and performs initial

configuration

• Domain user account

• Member of Local Admins on each server in the farm

• securityadmin and dbcreator on SQL instance

Farm Account Used for configuring and managing

the farm and runs primary services (e.g. SPTimerV4)

• Domain account

• Additional rights are automaticallygranted as part of installation (both

server and SQL)

Page 63: 2014 09-20 - SPSNJ - Worst Practices of SharePoint

Account Purpose Requirements

MySites Application

Pool

Worker process identity for MySites • Domain user account

• Managed account

Content Application

Pool

Worker process identity for Content web

applications

• Domain user account

• Managed account

Services Application

Pool

Worker process identity for Service

Application Pools

• Domain account

• Managed account

Search Service Process Process identity for SharePoint Foundation

(Help) search service and SharePoint

Search service

• Domain account

• Managed account

Search Service Default

Content Access

Used to crawl content specified in content

sources

• Domain account

User Profile Import

Account

Account used to import (and optionally

export) user data from an identity store

• Domain account

• Replicate Directory Changes in AD

Page 64: 2014 09-20 - SPSNJ - Worst Practices of SharePoint

Account Purpose Requirements

Object Cache Super

User

Processes items in the object cache of

a web application

• Domain user account

• Managed account• Full Control User Policy on target web

application(s)

Object Cache Super

Reader

Processes items in the object cache of

a web application

• Domain user account

• Managed account• Full Read User Policy on target web

application(s)

Page 65: 2014 09-20 - SPSNJ - Worst Practices of SharePoint
Page 66: 2014 09-20 - SPSNJ - Worst Practices of SharePoint
Page 67: 2014 09-20 - SPSNJ - Worst Practices of SharePoint
Page 68: 2014 09-20 - SPSNJ - Worst Practices of SharePoint
Page 69: 2014 09-20 - SPSNJ - Worst Practices of SharePoint