Tuesday, November 16, 2010

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

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
  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

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:
  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

  • 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
  • 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

  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
    nDeleted = nDeleted + 1
    'start 20100630 schneiderbi
    wscript.echo arFiles(n).path
    'end 20100630 schneiderbi
  end if
  on error goto 0

'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

  if bIncludeSubFolders then
    for each fldr in folder.subfolders
      SelectFiles fldr.path,vKillDate,arFilesToKill,true
  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"

Monday, March 15, 2010

Process SQL Query On All Database

declare @sqlstring nvarchar(1024)


SELECT @sqlstring;

exec master.dbo.sp_MSforeachDB @command1=@sqlstring

Monday, February 22, 2010

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


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

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


End If

End If


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

bFirstIteration = True

bFirstIteration = False

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

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

Tuesday, January 26, 2010

Backup SharePoint Site With Date In Filename

set webApp=
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