Archive

Archive for February, 2010

Excel Services cmdlets (SharePoint Server 2010)

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.

Ee906545.note(en-us,office.14).gifNote:

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

February 21st, 2010 Neal McFee No comments

Microsoft Office 2010 Professional Plus t-shirt giveaway

To celebrate the launch of my blog I have a t-shirt to give away.

Along with the t-shirt I will include two pens and two notepads.

The t-shirt is size XL and is a high quality cotton t-shirt with a graphic on the front.
Unworn and brand new.

Office2010blog_giveaway_close

Office2010blog_giveaway_wide

To enter the giveaway:

Follow sharepointmcts on Twitter

Step 1: Follow me on twitter
Step 2: Comment on this blog post that you have completed step 1.

For each new follower please come back and comment on this blog post that you completed the step of following me on twitter.

Giveaway rules:

The giveaway will start on 02/21/2010 6pm CST and end on 2/28/2010 6pm CST.
I will choose at random the winner from entrants that complete both steps of following me on twitter and commenting on this blog post that you completed step 1.

Giveaway delivery:

I will ship at my own expense the prize outlined in this giveaway.
I will contact the winner to obtain location for shipment.
Please make sure your profile includes an email address or other means of contacting you for your delivery location.
International locations included but keep in mind that you will be responsible for import duties or applicable tariffs.

Thanks and I hope to collaborate with everyone!!

Neal McFee

February 21st, 2010 Neal McFee 8 comments

Windows PowerShell compiled Help for SharePoint Server 2010

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

The links in this section correspond to separate files available in this download. Download the files most appropriate for you.
 
File Name:File Size 

AccessServicesCmdlets.chm

51 KB

Download

ECMCmdlets.chm

60 KB

Download

ExcelServicesApplicationCmdlets.chm

107 KB

Download

InfoPathCmdlets.chm

85 KB

Download

MetadataCmdlets.chm

63 KB

Download

PerformancePointCmdlets.chm

60 KB

Download

SearchCmdlets.chm

278 KB

Download

SecureStoreCmdlets.chm

70 KB

Download

SharePointFoundationSearchCmdlets.chm

44 KB

Download

SharePointProductsCmdlets.chm

459 KB

Download

StateServiceCmdlets.chm

71 KB

Download

UserProfileCmdlets.chm

60 KB

Download

VisioServicesCmdlets.chm

59 KB

Download

WebAnalyticsCmdlets.chm

46 KB

Download

WordServicesCmdlets.chm

46 KB

Download
February 21st, 2010 Neal McFee 1 comment

Search Architectures for Microsoft SharePoint Server 2010 interactive presentation

Search in SharePoint Server 2010 is re-architected with new components to create greater redundancy within a single farm and to allow scalability both horizontally and vertically.

In this presentation you will see:

Physical and logical components
Scale-out decision points

Example scaled-out architectures

  • Limited deployments
  • Small farm architecture
  • Medium shared architecture
  • Medium dedicated search architecture
  • Virtualized topologies
  • Large dedicated search farm

 

View Presentation

created with Seadragon

February 21st, 2010 Neal McFee No comments

Design Search Architectures for Microsoft SharePoint Server 2010 interactive presentation

This presentation will help you go through the initial design steps to determine a basic design for a Microsoft SharePoint  Server 2010 search architecture. Each successive step will help you refine the initial design by identifying key design drivers, starting with business requirements and metrics. You can use the outputs of each step to inform the next set of questions. After going through each step in this presentation, you will be able to map business requirements and key performance metrics to a baseline search architecture.

1. Identify corpus volume and key performance metrics

2. Map key metrics to logical topology and search components

3. Map logical topology to a physical architecture design

4. Stage, test, and iterate

View Presentation

created with Seadragon

February 21st, 2010 Neal McFee No comments

SharePoint 2010 server deployment interactive presentation

  • Software requirements
  • Best Practices for maintaining multiple environments
  • Installation and configuration

Deployment stages and example topologies

  • Planning
  • Development
  • Proof of Concept (POC)
  • Pilot
  • User Acceptance Test (UAT)
  • Production

 

View Presentation

created with Seadragon

February 21st, 2010 Neal McFee No comments

SharePoint 2010 Content Deployment Interactive Presentation

Overview of Content Deployment

  • What is content deployment?
  • What are paths and jobs?
  • When to use content deployment
  • Alternatives to content deployment

How many farms do you need?

Examples:

  • Authoring, staging,and production farm
  • Single publishing farm
  • Authoring and production farm

View Presentation

created with Seadragon

February 21st, 2010 Neal McFee No comments

SharePoint Developer credit class at DePaul University in Chicago

This looks like a great option to learn SharePoint 2007 and SharePoint 2010 development while earning college credit at a well known University in Chicago.

It is rare to see universities offering classes on very current technologies not to mention offering college credit for a very current version and the future version of SharePoint.

http://www.cdm.depaul.edu/ipd/Programs/Pages/SharePointDeveloperProgram.aspx

Overview
A 10-week comprehensive program covering Microsoft SharePoint development. The program exposes students to SharePoint architecture and the use of SharePoint as a development platform for building customized solutions, focusing on SharePoint as a collaboration framework and content management system.

The program will begin with an overview of the various product editions and their features as well as a refresher of the .NET 2.0+ fundamentals that SharePoint is built upon. The program will then provide in-depth coverage of the core development constructs of SharePoint to enable the student to understand how the pieces fit together in common use cases. Finally, the program will expose the student to current development trends and how they will carry over into the next release of the product, SharePoint 2010.

Admission Requirements
Applicants must have a solid programming background (at least two years of professional experience is preferred), including some experience building dynamic websites using ASP.NET and C#, and knowledge of basic HTML/CSS.

Dates & Location: Spring Quarter 2010
Application deadline: Mar. 12, 2010
Tuition deadline: Mar. 18, 2010
Classes begin: Mar. 30, 2010 
Classes end: Jun. 3, 2010
Classes meet on Tuesday and Thursday evenings (5:45pm-9pm) at DePaul University’s Loop Campus at 243 South Wabash Avenue, Chicago, IL.

Online Section:
Students may elect to register for an online section of the course. For more information about the online section, click here.
DePaul University reserves the right to cancel any program prior to that program’s first class meeting.

Course Credit

The SharePoint Developer Program is an accredited course of DePaul University, which follows the quarter system (as opposed to the semester system).
Course #: IPD 358
Credit hours: 10 undergraduate

For a complete program description, download the program brochure.

February 20th, 2010 Neal McFee No comments

SharePoint Server 2010 Deployment interactive presentation

In this presentation you will see topics on

  • Deployment stage and environment
  • Example topologies
  • Installation and Configuration
  • Best Practices for Managing Large Environments


View Presentation

Created with Microsoft Seadragon

February 16th, 2010 Neal McFee No comments

SharePoint 2010 Business Connectivity Services Model interactive presentation

Topics covered in this interactive presentation

  • What are Business Connectivity Services?
  • Business Connectivity Services Architecture
  • Business Connectivity Services Security

Creating Solutions Based on Business Services Connectivity Services 

View Presentation

created with Seadragon

February 16th, 2010 Neal McFee No comments