New 2010 Stuff to Learn

1. Farm Passphrase
2. Upgrade Methods
3. Health Analyzer
4. Admin Reports
5. IMP Usage Reports
6. Web Analytics Reports
7. Managed Accounts
8. Farm Backup and Restore
9. Granular Backup and Restore
10. Inline Editing of List
11. Tabular View
12. Compliance Details
13. Folders in Custom Lists
14. Custom View in SharePoint Desinger
15. Page Edit Mode
16. Add Web Part
17. Solution Gallery at top of Sie Collection
18. Multilingual UI
19. Search Server 2010 Express
20. Search Server 2010
21. Fast Search Server 2010
22. Incoming Email
23. SMS Service
24. NLB
25. Blocking Rogue Deployments
26. Registering SharePoint in AD
27. List Throttling
28. Install Prerequisites from custom location
29. Scripted Install
30. Creating Farm Accounts
31. White Wizard
32. Secure Store Service
33. Upgrade In-Place, Database Attach, Hybrid, and AAM Redirect
34. Service Applications
35. Information Policy
36. External Service Connections
37. InfoPath Forms Services
38. Site Directory
39. SharePoint Designer Options
40. Content Deployment
41. Service Application Groups
42. Service Application Connection
43. Service Application Services
44. Connecting across farms - service applications
45. Delegated Administrator
46. Setup Farm Trust
47. Publishing a Service Application
48. Multi-Tenancy and Partitioning
49. Site Subscription
50. Web Application Policy
51. Claims Identity
52. Anonymous Access
53. PowerShell
54. Portal Site Connection
55. Quick Launch
56. Publishing Navigation
57. Export and Import: sites, lists and libraries
58. Restoring Content with Unaattached Content Database
59. Backup and Restore Content Database
60. Backup and Restore Farm
61. Manage Feature via command line
62. Manage Solution via command line
63. Index Partition
64. Search Redundancy
65. Scale Crawl Database
66. Host Distribution Rule
67. Search Center
68. Enterprise Search Center
69. SharePoint Publishing

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

• http://www.sharepointdevwiki.com/display/sp2010/Building+a+SharePoint+2010+Development+machine
• http://www.sharepointnutsandbolts.com/2010/05/tips-for-building-sharepoint-2010-base.html
• http://blogs.msdn.com/b/jorman/archive/2010/01/01/setting-up-laptop-for-sharepoint-2010-and-sharepoint-2007.aspx
• http://blog.incworx.com/blog/john-petrutis-incworx-consulting-blog/0/0/planning-on-running-a-sharepoint-2010-virtual-machine-on-your-laptop
• http://thepointyheads.com/2009/09/sharepoint-2010-a-quest-for-a-development-environment/

Optimize

• http://blogit.create.pt/blogs/andrevala/archive/2010/03/06/Optimizing-a-VM-for-SharePoint-2010.aspx
• http://merill.net/2010/05/limit-sql-server-memory-usage-on-your-workstation-laptop-or-vm/

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

1. install and configure smtp service
2. configure to accept email for a domain for example sharepoint.test.com
3. configure MX record for domain in DNS
4. 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

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:

1. In-place
2. 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

DOs Command To Set AD Domain Password

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

Delete Files Older Than X Days Recursely

1. Save as vbs - deletefiles.vbs
2. 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

Process SQL Query On All Database

declare @sqlstring nvarchar(1024)


SET @sqlstring='use ?;DBCC SHRINKFILE (?, TRUNCATEONLY);DBCC SHRINKFILE (?_log, TRUNCATEONLY);BACKUP LOG ? WITH TRUNCATE_ONLY;DBCC SHRINKFILE (?_log, TRUNCATEONLY);';

SELECT @sqlstring;

exec master.dbo.sp_MSforeachDB @command1=@sqlstring

AutoBackupEvent Logs and Move

1. Windows 2003/2008 server will archive the event logs when they become full (see url)

• add these registry settings

Windows Registry Editor Version 5.00 [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application] "AutoBackupLogFiles"=dword:00000001 [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\System] "AutoBackupLogFiles"=dword:00000001 [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Security] "AutoBackupLogFiles"=dword:00000001

2. Create Batch File to Move Archive to Different Drive and schedule daily task

REM Barry Schneider 20100155

moveLocation="[drive:\path]"

move /Y c:\windows\system32\config\Archive-*.evt %moveLocation%

3. Delete Logs After Retention Expires and create daily task

Dim fso, f, f1, fc, folder, ext

archiveFolder="Drive:\Path\"
fileExtension="evt"
Set fso = CreateObject("Scripting.FileSystemObject")

Set f = fso.GetFolder(archiveFolder)

Set fc = f.Files

For Each f1 in fc

fileExt = fso.GetExtensionName(f1.Path)

If fileExt = fileExtension Then

If DateDiff("d", f1.DateLastModified, Now) > 181 Then

f1.Delete

End If

End If

Next

Set fso = Nothing

Set f = Nothing

Set fc = Nothing

Modified iisweb.vbs to just list web applications

1. find iisweb.vbs
2. make a copy of iisweb.vbs
3. rename
4. modify

From:
bFirstIteration = True

To:
bFirstIteration = False

From:
line = Server.ServerComment & " (" & Server.Name & ")" & _
Space(firstLen) & strState & _
Space(secLen) & strIP & Space(thirdLen) & strPort & _
Space(fourthLen) & strHost

To:
line = strHost&":"&strPort

5. Save file

REM Barry Schneider 20100222
REM Add AD Group to all SharePoint Web Application with permissionlevel Full Control
REM List of Web Application are in the file ListWebApplication.txt
REM example http://www.msih.com

set stsadmPath="C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\BIN\"

FOR /F "tokens=1 delims= " %%G IN (ListWebApplication.txt) DO %stsadmPath%stsadm -o addpermissionpolicy -url %%G -userlogin [AD Group] -permissionlevel "Full Control"

Managment Plan

1. Activity Management

• Projects (Start and End Date)
• Issues/Problems/Risk
• Maintenance
• Administration

1.1 Activity Management Data Model

• Name
• Descirption
• Notes
• Status
• Proposed Start Date
• Proposed End Date
• Priority
• Lead
• Stateholder
• Resources

2. Task Management

2.1 Task Management Data Model

• Name
• Requested Start Date
• Proposed End Date
• Link to Project
• Assigned to
• Notes
• Status

3. Policy Managmenet

4. Communication Management

Backup SharePoint Site With Date In Filename

set webApp=
backupFolder=F:\STSADM\
Set YYYY-MM-DD=%DATE:~6,4%-%DATE:~0,2%-%DATE:~3,2%

rem echo Get the current date and time in YYYY-MM-DD-HH-MM-SS format
SET isodt=%date:~10,4%%date:~4,2%%date:~7,2%-%time:~0,2%%time:~3,2%%time:~6,2%
rem echo %isodt%

md %backupFolder%\%webApp%
stsadm -o setsitelock -url http://%webApp% -lock readonly
stsadm -o backup -url http://%webApp% -filename %backupFolder%%webApp%\%webApp%-%isodt%.datstsadm -o setsitelock -url http://%webApp% -lock none
stsadm -o enumsolutions > %backupFolder%%webApp%\enuSolutions-%isodt%.txt
pause