Your resource quota is 300 server resources

Updated: 2009-12-14

[This article is pre-release documentation and is subject to change in future releases.]

Excel Services Application is a service application in Microsoft SharePoint Server 2010 that you can use to share, secure, and manage Microsoft Excel 2010 workbooks (.xlsx, .xlsb, and .xlsm extensions) as interactive reports in a consistent way throughout the enterprise.

All Excel Services Application settings will support backup and recovery regardless of whether there is a UI setting in the Central Administration Web site. This means that all global settings, trusted locations, user-defined-functions, data connection libraries, and trusted data provider settings will support backup and recovery. However, the following items will not be backed up as part of the backup and recovery process:

• User-defined function assemblies. These assemblies will not be backed up or restored because they are binary files and not simply settings; however, the data in the list of trusted user-defined functions is backed up.
• Trusted data provider binaries. (The full list of trusted data providers and all associated properties, however, are backed up.)
• Any Excel Web Access (EWA) Web Part properties.
• Office data connection (.odc extension) files and workbook files.

Note:

URLs of any kind (that is, URLs to trusted locations, user-defined functions, or data connection libraries) must be manually fixed after a restore operation because they may no longer be valid.

In addition to using Windows PowerShell for Excel Services Application backup and recovery functionality, you can use Windows PowerShell to provision the service application from scratch or provision a new instance that uses settings from a previous backup, and manage and configure trusted file locations, data providers, data connection libraries, and settings for user-defined function assemblies. You can also change global settings for Excel Services Application.

The following cmdlets are available for Beta.

Cmdlet Name

Get-SPExcelBlockedFileType

New-SPExcelBlockedFileType

Remove-SPExcelBlockedFileType

Get-SPExcelDataConnectionLibrary

New-SPExcelDataConnectionLibrary

Remove-SPExcelDataConnectionLibrary

Set-SPExcelDataConnectionLibrary

Get-SPExcelDataProvider

New-SPExcelDataProvider

Remove-SPExcelDataProvider

Set-SPExcelDataProvider

Get-SPExcelFileLocation

New-SPExcelFileLocation

Remove-SPExcelFileLocation

Set-SPExcelFileLocation

Get-SPExcelServiceApplication

New-SPExcelServiceApplication

Set-SPExcelServiceApplication

Get-SPExcelUserDefinedFunction

New-SPExcelUserDefinedFunction

Remove-SPExcelUserDefinedFunction

Set-SPExcelUserDefinedFunction

To download the ExcelServicesApplicationCmdlets.chm file, see Windows PowerShell for SharePoint Server 2010 Beta (http://go.microsoft.com/fwlink/?LinkId=179124).

Here is the Microsoft Download center URL to a series of .chm files that contain the overview, use, and syntax for using PowerShell when administrating SharePoint Server 2010

Microsoft Download Center

Files in This Download

Updated: 2009-12-14

[This article is pre-release documentation and is subject to change in future releases.]

Access Services is a service in Microsoft SharePoint Server 2010 that lets an administrator view, edit, and configure a Microsoft Access application within a Web browser.

All Access Services settings support backup and recovery, regardless of whether there is a UI setting in Central Administration. However, backup and recovery only apply to service-level and administrative-level settings; end-user content from the Access application is not backed up as part of this process.

Access Services has Windows PowerShell functionality that you can use to provision the service or provision a new instance that uses settings from a previous backup; configure and manage macro and query setting; manage and configure session management; and configure all the global settings of the service.

The following cmdlets are available for Beta.

Cmdlet name

New-SPAccessServiceApplication

Get-SPAccessServiceApplication

Set-SPAccessServiceApplication

To download the AccessServicesCmdlets.chm file, see Windows PowerShell for SharePoint Server 2010 Beta (http://go.microsoft.com/fwlink/?LinkID=179124).

Updated: 2009-12-14

[This article is pre-release documentation and is subject to change in future releases.]

Enterprise content management (ECM) is the strategies, methods, and tools used to obtain, retain, and deliver content and documents related to processes within an organization. In Microsoft SharePoint Server 2010, Windows PowerShell cmdlets focus on two aspects of content deployment functionality.

Content deployment copies content from a source SharePoint Server 2010 site collection to a destination site collection. You can copy the entire source site collection or a subset of sites.

Note:

Make sure that you run the initial content deployment as a full deployment. After you complete a full deployment, you can run an incremental deployment, which deploys only changed pages and related assets.

The Windows PowerShell cmdlets that are related to content deployment focus on two areas:

• Content deployment path   A content deployment path defines the relationship between a source and destination site collection for content deployment. After you create a path, you can create jobs and associate them with the path to begin deploying content.
  Use the Windows PowerShell noun, SPContentDeploymentPath, to retrieve, set, and create deployment paths.
• Content deployment job   A content deployment job is associated with a content deployment path. It defines the specific content to be deployed from the source to the destination, and the schedule on which the deployment should occur.
  The Windows PowerShell noun, SPContentDeploymentJob, lets the administrator retrieve, set, and create deployment jobs.

There are also cmdlets that support administration of metadata.

The following cmdlets are available for Beta.

Cmdlet name

Get-SPContentDeploymentJob

New-SPContentDeploymentJob

Remove-SPContentDeploymentJob

Set-SPContentDeploymentJob

Start-SPContentDeploymentJob

Get-SPContentDeploymentPath

New-SPContentDeploymentPath

Remove-SPContentDeploymentPath

Set-SPContentDeploymentPath

Clear-SPMetadataWebServicePartitionData

Export-SPMetadataWebServicePartitionData

Import-SPMetadataWebServicePartitionData

Get-SPSiteSubscriptionMetadataConfig

Remove-SPSiteSubscriptionMetadataConfig

Set-SPSiteSubscriptionMetadataConfig

Get-SPTaxonomySession

Get-SPMetadataServiceApplication

New-SPMetadataServiceApplication

Set-SPMetadataServiceApplication

Get-SPMetadataServiceApplicationProxy

New-SPMetadataServiceApplicationProxy

Set-SPMetadataServiceApplicationProxy

To download the ECMCmdlets.chm or MetadataCmdlets.chm file, see Windows PowerShell for SharePoint Server 2010 Beta (http://go.microsoft.com/fwlink/?LinkID=179124).

Enable the Developer Dashboard with the following command in the SharePoint 2010 Management Shell:

STSADM –o setproperty –pn developer-dashboard –pv ondemand

Use the above command for activating the Developer Dashboard via the icon in the upper-right of the site (on-demand mode):

or use:

STSADM –o setproperty –pn developer-dashboard –pv on

to always have a Developer Dashboard output

(Note: there is no icon in the upper right when the Developer Dashboard is always on)

To disable the Developer Dashboard use the following command:

STSADM –o setproperty –pn developer-dashboard –pv off

Here is an example of the Developer Dashboard

Here is a site that is a repository for PowerShell scripts.

As a SharePoint Server 2010 administrator I find this site to be very useful.
A codeplex for powershell.

Link – PowerShell code repository