Make Sure IT Happens: October 2010

Sunday, October 10, 2010

SharePoint 2010 Development VM

http://www.google.com/search?source=ig&hl=en&rlz=1G1TSNACENUS394&q=sharepoint+2010+dev+vm&aq=f&aqi=&aql=&oq=&gs_rfai=CA8dMxmCxTNKGOIveggTltOTzDgAAAKoEBU_Q5GnT

Optimize

Thursday, October 7, 2010

SharePoint 2010 - Architecture

SharePoint Foundation

Included with Windows server
features include

list
document library
blogs
wiki
RSS
alerts

interface with Workflow Foundation
accessible through object model, api, and web services

SharePoint Server 2010

offers additional collaboration capabilities
better aggregation of content
SharePoint Foundation is installed with SharePoint Server 2010
Standard

social
search
content management

Enterprise

business intelligence
line o business integration
reporting

Search Server 2010

Provide full scale enterprise search to SharePoint Foundations

Search Server 2010 Express

free from Microsoft
add content sources

file shares
other sharepoint sites
web sites
exchange public folders
cannot be configured for high availability

Windows Server

requires 64-bit
server 2009 SP2 or 2008 R2
cannot be installed on

Server Core
Web Edition

needs to be included as a member of an Active Directory Domain

does not support local accounts for farm deployment

let the SharePoint install wizard install and configure additional software and services

Windows Vista and 7

for development purpose can be instaleed on 64-bit editions
Vists SP1

business
enterprise
ultimate

Windows 7

professional
enterprise
ultimate

SQL Server

requires 64-bit
SQL 2005 SP1
SQL 2008 SP1
SQL 2008 R2

Email Server

smtp server need to allow anonymous relay from SharePoint
cannot be configured to autenicate

Incoming Email

route email to list or library

Configure Incoming email

install and configure smtp service
configure to accept email for a domain for example sharepoint.test.com
configure MX record for domain in DNS
from Central Admin, enable incomeing email and specify domain

see http://technet.microsoft.com/en-us/library/cc262947(office.14).aspx

SMS Service

send alerts to sms
scope at farm or web application level
need to provide URL to SMS sending service

Hardware Recommendations

Moss 2007: 2core /3Ghz, 2G ram
Server 2010: 4 core / 2.5ghz, 8G ram

Web Servers

refered to a web front end (wfe)
responsible for rendering the page
normally not too high of cpu load
do use substancial amount of ram for caching and processing

Application Server

Query server - responding to search requests

large index requires cpu and memory
requires local optimize storage for teh query file

Index Server - also referred to a crawl server

does not store any information locally, so no storage requirements
additional cpu capacity for large environments

SQL Server

the main bottleneck in sharepoint farms is sql performance
8G min and 16G to 32G
disk configuration is important for performance
store mdf and ldf on different disk. log file optimized for write
optimize as follows

tempdb
search db
content db

see http://technet.microsoft.com/en-us/sqlserver/default.aspx planning and sizing dsql deployment

Tuesday, October 5, 2010

SharePoint 2010 - Service Applications

Service Application represent the evolution of the SSP.

all service applications are seperate
all service application can be turned on and off
all service applications have unique user access permissions. central administration is security trimmed; users only see what they have access to

SharePoint 2010 - Upgrade

There are two methods to upgrade from SP2007:

In-place
database attach

read-only content dabase can be rendered during upgrade
sp2010 can redirect to sp2007 farm until upgrade completes
visual upgrade allows site upgraded to sp2010 to use look and feel of sp2007

SharePoint 2010 Installation

Installation

must be installed on 64-bit operating system.
must be installed on Windows 2008 SP2 or R2, or later
requires 64-bit version of SQL 2005 SP2 or 2008, or later
reprequisite installer will download and install all required software, configure IIS and other components
requires a farm passwphrase; needed to add or remove server from farm. Also used for encryption between farm members.
AD Group Policy Objects can be used to block installation

Upgrade

stsadm -o preupgradecheck; interrogates sp2007 content databases and alerts of potential roadblocks

server
amount of content
search configuration
features
solutions
site definitions
alternate access mappings
langage packs
large lists
orphaned data
view and content types that use CAML
database with modified schemas

the check is read-only; makes no changes to any database
powershell cmdlet test-SPContentDatabase

Monday, October 4, 2010

DOs Command To Set AD Domain Password

dsmod user "CN=,OU=,DC=" -pwd XXX

Delete Files Older Than X Days Recursely

Save as vbs - deletefiles.vbs
to use pass in number folder and number of days

For example deletefiles.vbs c:\temp 60

' Pass the arguments
Set objFSO = Wscript.CreateObject("Scripting.FileSystemObject")
path = Wscript.Arguments.Item(0)
' folder to start search in... You can just use static
'path = "C:\Temp\test"

' delete files older than 2 days...
mDays = Wscript.Arguments.Item(1)
killdate = date() - mDays

arFiles = Array()
set fso = createobject("scripting.filesystemobject")

' Don't do the delete while you still are looping through a
' file collection returned from the File System Object (FSO).
' The collection may get mixed up.
' Create an array of the file objects to avoid this.
'
SelectFiles path, killdate, arFiles, true

nDeleted = 0
for n = 0 to ubound(arFiles)
'=================================================
' Files deleted via FSO methods do *NOT* go to the recycle bin!!!
'=================================================
on error resume next 'in case of 'in use' files...
arFiles(n).delete true
if err.number <> 0 then
    wscript.echo "Unable to delete: " & arFiles(n).path
else
    nDeleted = nDeleted + 1
    'start 20100630 schneiderbi
    wscript.echo arFiles(n).path
    'end 20100630 schneiderbi
end if
on error goto 0
next

'msgbox nDeleted & " of " & ubound(arFiles)+1 _
' & " eligible files were deleted"

sub SelectFiles(sPath,vKillDate,arFilesToKill,bIncludeSubFolders)
on error resume next
'select files to delete and add to array...
'
set folder = fso.getfolder(sPath)
set files = folder.files

for each file in files
    ' uses error trapping around access to the
    ' Date property just to be safe
    '
    dtlastmodified = null
    on error resume Next
    dtlastmodified = file.datelastmodified
    on error goto 0
    if not isnull(dtlastmodified) Then
      if dtlastmodified < vKillDate then
        count = ubound(arFilesToKill) + 1
        redim preserve arFilesToKill(count)
        set arFilesToKill(count) = file
      end if
    end if
next

if bIncludeSubFolders then
    for each fldr in folder.subfolders
      SelectFiles fldr.path,vKillDate,arFilesToKill,true
    next
end if
end sub

MOSS 2007 - Policy for Web application Script

This is DOS script

REM Grant AD group full Control to each sharepoint web application listed in file wal.txt
REM 20101003

set ADgroupName=""
set url=""

rem this is for single web application
rem stsadm -o addpermissionpolicy -url %url% -userlogin %%ADgroupName%% -permissionlevel "Full Control"

FOR /F %%G IN (wal.txt) DO stsadm -o addpermissionpolicy -url %%G -userlogin %%ADgroupName%% -permissionlevel "Full Control"
pause