December 2011 - SharePoint Tips

  • How to Use a SQL Alias in Your SharePoint Farm

    SharePoint depends on its connections to one or more SQL Server instances for the overwhelming majority of its content and configuration data. The loss of a SQL Server can spell disaster for SharePoint, particularly if the lost SQL Server can’t be restored and a new SQL Server instance (with a new name) must be used. The use of SQL Server names and/or addresses in difficult-to-alter SharePoint database connection strings is what makes this situation...
  • Use Dashboards to Quickly Communicate

    For an Intranet, determining key company metrics and showing them graphically can help keep staff focused on the same goals. SharePoint provides a Key Performance Indicator (KPI) web part which is set up by default in a site created using the Reports template. This web part is also available in other site templates such as Team / Collaboration. Setup a KPI list and a data source such as Excel, a SharePoint list or any external data source to hold...
  • How to Add List Items using PowerShell

    SharePoint 2010 offers over 500 new cmdlets that we can use to automate the SharePoint 2010 environment through Windows PowerShell. The cmdlets go as deep as SPWeb, everything beyond SPWeb requires additional scripting, such as adding fields, views and items. Here’s an example showing how to add an item to the Announcements list in SharePoint 2010: $spWeb = Get-SPWeb -identity http : // SP $spList = $spWeb . GetList ( “ Lists / Announcements...
  • How to Quickly Access SharePoint Hives

    If you use SharePoint on a daily basis, you are probably familiar with the SharePoint hive. In SharePoint 2010, the hive is called the SharePoint root. The SharePoint root is used by SharePoint to store features, logs, binary files, templates and much more. It’s commonly used when performing administrative tasks in SharePoint. Changing location to the path is fun, the first time, but after typing the path 100 times, it gets a bit tedious. In...
  • KPI Values

    Previous versions of SharePoint had limitations to folders support for the KPI Lists. Whenever you tried to set Folder as a source of your KPI, SharePoint gave you an error that the folder can't be selected. To avoid such situation you had to maintain KPI values in different list or use Views. The issue with Views is that they don't allow you to assign the permissions per View, so you can't have groups of data and assign different permission...
  • Backup and Restore a Site Collection in SharePoint using PowerShell

    In SharePoint 2010 you can take a backup of a site collection using the Backup-SPSite cmdlet: Backup-SPSite http : // SP – Path C:\Backup\siteCollection.bak Restoring a site collection in SharePoint 2010 is just as simple: Restore-SPSite http : // SP – Path C:\Backup\siteCollection.bak ReTweet this Tip!
  • Use max-age Attribute with BLOB Caching to Reduce the Number of Client Requests to a SharePoint Server

    When configuring BLOB caching for MOSS 2007 and SharePoint 2010, it is possible to specify an optional max-age attribute in the web.config element. This attribute determines the amount of time, in seconds, that SharePoint clients should cache resources locally (typically in the browser’s temporary files area) that are served from a WFE’s BLOB cache. For example, the following web.config element instructs clients to locally store .GIF and...
  • Using a Custom Column to Improve Search Results

    Categorizing content helps users effectively find documents within the site. This can be done via SharePoint through the use of custom columns or meta data. Create these columns at the global level of the site collection and add them to the required content types. The document libraries or lists associated with these content types will then inherit these custom columns. These custom columns can also be set as required fields. For example, you may...
  • Managing a site in SharePoint Using PowerShell cmdlets

    In SharePoint 2010 you can manage sites through Windows PowerShell. You can create new sites in a site collection using the New-SPWeb cmdlet: New-SPWeb http : // SP / TeamSite -Template "STS#0" – Name "Team Site" ` -Description "Description of Site" – AddToTopNav – UseParentTopNav You can retrieve an existing site using the Get-SPWeb cmdlet: Get-SPWeb http : // SP / TeamSite You can configure a site...
  • SharePoint BLOB Caching to increase performance

    BLOB caching, or disk-based caching, is an out of the box (OOTB) caching mechanism that is built into the MOSS 2007 and SharePoint Server 2010 platforms. It is commonly used to speed-up access to large and relatively static resources that are stored in content databases, such as images, videos, javascript files, and more. Performance improvements are gained by storing these assets on web front-ends (WFEs) once they’ve been requested by a client...
  • Using "Send To" to Route Document

    Anjali Sharma -Expert in Residence Documents are not always created in the location where they should finally be routed to. For example, documents may be created in one site but routed to a different site for final review by clients or customers. This can be easily achieved in SharePoint 2010 via simple short cut menus that can be set up for a document library. This is done by enabling the content organizer features and configuring ‘send to’...
  • Find information faster with Metadata navigations

    Mattias Karlsson -Expert in Residence Metadata navigation is a new feature in SharePoint 2010 that allows you to quickly find and filter content in large document libraries. End users will get a new navigation pane in the left-hand side navigation of the document library when they enable the Metadata navigation. The entries displayed in the pane are the columns that are specified in the Metadata Navigation settings. Clicking on any of the items in...
  • Sync Users Information from Active Directories

    Niklas Goude -Expert in Residence You can sync User information from the User Directory Store. Simply, use the Set-SPUser cmdlet and use the SyncFromAD switch parameter to enable syncing. PS > Set-SPUser -Identity powershell\user3 ` >> -Web http : // sp01 -SyncFromAD ReTweet this Tip!
  • Create a template of your list

    Mattias Karlsson -Expert in Residence Some SharePoint lists could be useful to reuse at other locations in your SharePoint environment. Customized SharePoint lists can easily be created as templates so the customized list will be available when other users are creating new lists. You can browse the List, select the List tab in the Ribbon, and click List settings to create a template of a list in SharePoint 2010. ,. Under Permissions and Management...
  • Add existing users to Groups

    Niklas Goude -Expert in Residence You can add an existing SharePoint User to a group using the Set-SPUser cmdlet. Simply specify the group using the Group parameter as shown in the example below. PS > Set-SPUser -Identity powershell\user3 ` >> -Web http : // sp01 -Group "Design" ReTweet this Tip!
1 2 Next >
Idera SharePoint Reviews SMBology, Inc. Rackspace Hosting Sponsored by Idera and SharePoint Reviews and SMBology and EPCGroup.net
Copyright 2011 SecretsOfSharePoint.com. All rights reserved.