Some content databases are growing too large (SharePoint Foundation 2010)

Edit the rule definition to prevent new sites from being added to these databases, and then move some site collections to other databases.

1. Verify that the user account that is performing this procedure is a member of the Farm Administrators group.

2. On the Central Administration Home page, click Monitoring.

3. On the Monitoring page, in the Health Analyzer section, click Review rule definitions.

4. On the Health Analyzer Rule Definitions page, in the Availability category, click the name of the rule (Some content databases are growing too large).

5. In the Health Analyzer Rule Definitions dialog box, click Edit Item, and then select the Repair Automatically check box.

6. Click Save. You can no longer add new sites to databases that exceed 100 GB.

7. Move some site collections to smaller databases.  See

   How To Move A Site Collection To A Different Content Database for more information.

 Move-SPSite <http://ServerName/Sites/SiteName> -DestinationDatabase <DestinationContentDb> 

1. Open the following file:
   C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\Template\1033\XML\webtemp*.xml
2. Find the template that you would like to hide and change the following line “Hidden” property of the <Configuration> element to “TRUE”.
3. You may have to do an IISReset in order for the changes to take effect.

Resources

• http://blogs.msdn.com/b/hsalvi/archive/2010/07/03/farm-wide-hide-templates-sharepoint-2010.aspx
• http://sharepoint.microsoft.com/Blogs/fromthefield/Lists/Posts/Post.aspx?List=0ce77946-1e45-4b43-8c74-21963e64d4e1&ID=34&Web=5170eb8a-912d-4024-814a-81e94b9d34ce
• http://msdn.microsoft.com/en-us/library/ms447717.aspx

Below are a list of the web parts that are available when creating a team site in the various editions:

Web Parts by Category	SharePoint Foundation	SharePoint Server 2010 Standard	SharePoint Server 2010 Enterprise	Description
Business Data
Business Data Actions			x	Displays a list of actions from Business Data Connectivity.
Business Data Connectivity Filter			x	Filters the contents of Web Parts using a list of values from the Business Data Connectivity.
Business Data Item			x	Displays one item from a data source in Business Data Connectivity.
Business Data Item Builder			x	Creates a Business Data item from parameters in the query string and provides it to other Web Parts.
Business Data List			x	Displays a list of items from a data source in Business Data Connectivity.
Business Data Related List			x	Displays a list of items related to one or more parent items from a data source in Business Data Connectivity.
Chart Web part			x	Helps you to visualize your data on SharePoint sites and portals.
Excel Web Access			x	Use the Excel Web Access Web Part to interact with an Excel workbook as a Web page.
Indicator Details			x	Displays the details of a single Status Indicator. Status Indicators display an important measure for an organization and may be obtained from other data sources including SharePoint lists, Excel workbooks, and SQL Server 2005 Analysis Services KPIs.
Status List			x	Shows a list of Status Indicators. Status Indicators display important measures for your organization, and show how your organization is performing with respect to your goals.
Visio Web Access			x	Enables viewing and refreshing of published Visio diagrams.
Content Rollup
Categories		x	x	Displays categories from the Site Directory
Relevant Documents	x	x	x	Displays documents that are relevant to the current user
RSS Viewer		x	x	Displays an RSS feed.
Site Aggregator		x	x	Displays sites of your choice
Sites in Category		x	x	Displays sites from the Site Directory within a specific category
Table of Contents		x	x	Displays the navigation hierarchy of your site.
Web Analytics web part		x	x	Displays the most viewed content, most popular search queries, or most popular clicked search results as reported by Web Analytics for the site or site collection
WSRP Viewer			x	Displays portlets from web sites using WSRP 1.1.
XML Viewer	x	x	x	Transforms XML data using XSL and shows the results
Filters
Choice Filter			x	Filters the contents of Web Parts using a list of values entered by the page author
Current User Filter			x	Filters the contents of Web Parts by using properties of the current user.
Data Filter			x	Filter the contents of Web Parts by allowing users to enter or pick a date.
Filter Actions			x	Use the Filter Actions Web Part when you have two or more filter Web Parts on one Web Part Page, and you want to synchronize the display of the filter results
Page Field Filter			x	Filters the contents of Web Parts using information about the current page.
Query String (URL) Filter			x	Filters the contents of Web Parts using values passed via the query string.
SharePoint List Filter			x	Filters the contents of Web Parts by using a list of values.
SQL Server Analysis Services Filter			x	Filters the contents of Web Parts using a list of values from SQL Server Analysis Services cubes.
Text Filter			x	Filters the contents of Web Parts by allowing users to enter a text value.
Forms
HTML Form Web Part	x	x	x	Connects simple form controls to other web parts
InfoPath Form Web Part			x	Use this Web Part to display an InfoPath browser-enabled form.
Media & Content
Content Editor	x	x	x	Allows authors to enter rich text content
Image Viewer	x	x	x	Displays a specified image
Page Viewer	x	x	x	Displays another Web page on this Web Page. The other Web page is presented in an iFrame
Picture Library Slideshow Web Part	x	x	x	Use to display a slideshow of images and photos from a picture library
Silverlight Web Part	x	x	x	A web part to display a Silverlight application
Outlook Web App
My Calendar		x	x	Displays your calendar using Outlook Web Access for Microsoft Exchange Server 2003 or later
My Contacts		x	x	Displays your contacts using Outlook Web Access for Microsoft Exchange Server 2003 or later
My Inbox		x	x	Displays your inbox using Outlook Web Access for Microsoft Exchange Server 2003 or later
My Mail Folder		x	x	Displays your mail folder using Outlook Web Access for Microsoft Exchange Server 2000 or later
My Tasks		x	x	Displays your tasks using Outlook Web Access for Microsoft Exchange Server 2003 or later
Search
Advanced Search Box		x	x	Displays parameterized search options based on properties and combinations of words
Dual Chinese Search		x	x	Used to search Dual Chinese document and items at the same time.
Federated Results		x	x	Displays search results from a configured location
People Refinement Panel		x	x	This webpart helps the users to refine people search results
People Search Box		x	x	Presents a search box that allows users to search for people
People Search Core Results		x	x	Displays the people search results and the properties associated with them
Refinement Panel		x	x	This webpart helps the users to refine search results
Related Queries		x	x	This webpart displays related queries to a user query
Search Action Links		x	x	Displays the search action links on the search results page
Search Best Bets		x	x	Displays high-confidence results on a search results page.
Search Box		x	x	Displays a search box that allows users to search for information
Search Core Results		x	x	Displays the search results and the properties associated with them
Search Paging		x	x	Display links for navigating pages containing search results.
Search Statistics		x	x	Displays the search statistics such as the number of results shown on the current page, total number of results and time taken to perform the search.
Search Summary		x	x	Displays suggestions for current search query.
Search Visual Best Bet			x	Displays Visual Best Bet
Top Federated Results		x	x	Displays the Top Federated result from the configured location.
Social Collaboration
Contact Details		x	x	Displays details about a contact for this page or site
Note Board		x	x	Enable users to leave short, publicly-viewable notes about this page
Organization Browser		x	x	This Web Part displays each person in the reporting chain in an interactive view optimized for browsing organization charts.
Site Users	x	x	x	Use the Site Users Web Part to see a list of the site users and their online status
User Tasks	x	x	x	Displays tasks that are assigned to the current user.
Tag Cloud		x	x	Displays the most popular subjects being tagged inside your organization

There are also a large amount of web parts that appear either when you enable certain features, or add them to the web part gallery manually. Some common examples are the Content Query Web Part and the Media Web Part (added automatically for sites based on the publishing or collaboration site templates). There are a large amount of these so I’m only showing a few to give you an indication of what else is available. To have a look at the full list navigate to Site Actions > Site Settings > Galleries | Web parts from the site collection root and then select Documents > New Document from the ribbon. This will give you a list of all web parts available to add to the new web part menu.

Some of the additional web parts available in SharePoint 2010:

Web Parts by Category	SharePoint Foundation	SharePoint Server 2010 Standard	SharePoint Server 2010 Enterprise	Description
Publishing
Media Web Part		x	x	Use to embed media clips (video and audio) in a web page.
Content Query		x	x	Displays a dynamic view of content from your site.
Summary Links		x	x	Allows authors to create links that can be grouped and styled.
Miscellaneous
List View Web Part	x	x	x	Use to display a view of a list or document library
Blog Year Archive	x	x	x	Displays the blog archive of the previous three years.
Document Set Contents		x	x	Displays the contents of a Document Set
Document Set Properties		x	x	Displays the properties of the Document Set
Enter a Document ID		x	x	Finds a document by its Document ID
My Links		x	x	Displays a list of a users ‘My Links’
What’s New	x	x	x	This Web Part shows new information from specified lists and libraries.
Whereabouts	x	x	x	Use to display Whereabouts information
PerformancePoint
PerformancePoint Filter			x	This web part displays PerformancePoint filters. Filters may be linked to other web parts to provide an interactive dashboard experience. Filter types include lists and trees based on a variety of data sources.
PerformancePoint Report			x	This web part displays PerformancePoint reports. Reports may be linked to other web parts to create an interactive dashboard experience. Report types include: Analytic charts & grids, Strategy Maps, Excel Services, Reporting Services, Predictive Trend charts, and web pages.
PerformancePoint Scorecard			x	This web part displays a PerformancePoint scorecard. Scorecards may be linked to other web parts, such as filters and reports, to create an interactive dashboard experience.
PerformancePoint Stack Selector			x	This web part displays a PerformancePoint Stack Selector. All PerformancePoint web parts, such as filters and reports, contained in the same zone will be automatically stacked and selectable using this web part.

Site names, subsite names, or site group names

• You cannot use the following characters anywhere in a site name, in a subsite name, or in a site or Active Directory group name:
• tilde (~)
• number sign (#)
• percent (%)
• ampersand (&)
• asterisk (*)
• braces ({ })
• backslash (\)
• colon (:)
• angle brackets (< >)
• question mark (?)
• slash (/)
• plus sign (+)
• pipe (|)
• quotation mark (")
• You cannot start a site name, subsite name, or a site group name with an underscore (_) character or with the period character.
• You cannot use the period character consecutively in the middle of a site name, a subsite name, or a site group name.
• You cannot use the period character at the end of a site name, a subsite name, or a site group name.

Folder names

• You cannot use the following characters anywhere in a folder name or a server name:
• tilde
• number sign
• percent
• ampersand
• asterisk
• braces
• backslash
• colon
• angle brackets
• question mark
• slash
• pipe
• quotation mark
• You cannot use the period character consecutively in the middle of a folder name.
• You cannot use the period character at the end of a folder name.
• You cannot start a folder name with the period character.

File names

• You cannot use the following characters anywhere in a file name:
• tilde
• number sign
• percent
• ampersand
• asterisk
• braces
• backslash
• colon
• angle brackets
• question mark
• slash
• pipe
• quotation mark
• You cannot use the period character consecutively in the middle of a file name.
• You cannot use the period character at the end of a file name.
• You cannot start a file name with the period character.
• In addition, file names and folder names may not end with:
• .files
• _files
• -Dateien
• _fichiers
• _bestanden
• _file
• _archivos
• -filer
• _tiedostot
• _pliki
• _soubory
• _elemei
• _ficheiros
• _arquivos
• _dosyalar
• _datoteke
• _fitxers
• _failid
• _fails
• _bylos
• _fajlovi
• _fitxategiak

SharePoint users and likewise other application users that use WebDav Explorer mode on Windows 7 and Windows Vista PC’s may experience very slow file browsing, opening and modification (e.g. SharePoint Explorer View using WebDAV).

How simple would it be to just uncheck a certain option in IE and fix this brain busting issue, especially for Network Admins and SP Admins?

Solution

1. Open Internet Explorer
2. Go to the Menu “Tools” > “Internet Options” then go to the “Connections” tab
3. Click on button “LAN Settings”
4. Uncheck the box “Automatically detect settings” (culprit)
5. Close and restart all running Internet Explorer processes
6. Restart the “Web Client” Service, if needed.
7. Start browsing again…!

Now for a bit of knowledge building

What is the “Automatically Detect Settings” option in IE?

The “Automatically detect settings” option is there to help the user in configuring a web proxy automatically. It actually makes use of the WPAD protocol to discover a web proxy.

1. If the PC is configured to do DHCP, then it will query the server. If the response includes a string with id 252, then it uses this to retrieve a configuration file.

2. If this fails, then the PC will attempt to resolve the name wpad. It will start in its current domain, and work back through. Eg, if the PC is called bob.cs.anu.edu.au, it will attempt to resolve wpad.cs.anu.edu.au, followed by wpad.anu.edu.au, etc. If this resolves the name wpad, then IE will attempt to retrieve wpad.dat via http from the root of the server. You should probably redirect this to the configuration file.

3. If this yields no success, then IE goes direct.

Now here is your delay, when Step 1 and Step 2 are running, time-out – finally deciding to open your WebDav folders directly. Phew!

Skip it… if you do not require the auto-discovery feature. Ask your network admin to push a GPO to turn-it-off or uncheck it by default!

Summary:

1. SharePoint is a tool like Word or Excel. Have you branded them?
2. Increase cost/user
3. Keep UI consistent from site to site
4. Possible increase in training costs because of inconsistent UI
5. Possible increase in support costs because of inconsistent UI
6. Increased amounts of time wasted by managers and team leads trying to be web designers
7. Inconsistent site content, workflow and audit trails
8. Increased complexity in the auditing process
9. Rather than spending time/money on branding use it for planning and governance
10. Branded sites are usually less able to be upgraded cleanly

Have you branded SharePoint?  Was it worth it?

Team site
This is the template that most users build sites from, and you will recognize it from the pictures of random office workers on the right hand side.

As with most SharePoint site templates it has two key elements:

• A number of predefined lists
• A number of predefined webparts on the page

A team site will give you the following lists to play with – Announcements, Calendar, Links, and Tasks. You also get the a number of libraries – Shared Documents, Site Assets, and Site Pages. Oh and their is a ‘Team Discussion’ board as well.

The main page of the team site is a wiki page, new to SharePoint 2010, which means you can edit directly onto the page. It is split into two columns (roughly 2/3 and 1/3) and contains some text and images and a document library webpart.

Blank site
A blank site is a team site (same two column layout) with all lists and webparts stripped out. Its blank. Hence the name.

Document workspace
This site is designed to make working with documents a little easier and more intuitive for groups of people.

The standard lists and libraries here are the same as a team site, minus the site asset and page libraries.

The page layout is a full width column at the top, with the familiar 2/3 1/3 column split below. You get the following webparts – Announcements, Shared Documents, Tasks, and Members.

The Members webpart shows people with permissions on this site, but it can be configured to show people in a particular SharePoint group.

Meeting workspace
The meeting workspace template stands out as it doesn’t use the popular ‘quicklaunch’ bar that most site templates uses. As a result the page content spans the full width of the screen. SharePoint is often trumpeted as a collaboration platform, and it is templates like this one that go some way to fulfilling this role.

Included are a single document library and the following lists – Agenda, Attendees, and Objectives. It is easy to see that these lists are designed to help run a meeting. The idea is the site can be used to prepare for, or during the running of, a meeting.

All the lists respective webparts are included on the page, which is split into three vertical columns.

There are a number of alternative versions of this site template:

• Decision meeting workspace – Adds Decision and Task lists
• Social meeting workspace – Adds a Picture Library, Directions list, Things to Bring list, and a discussion board. This site template is aimed at face to face meetings.
• Multipage meeting workspace – Same as the main meeting workspace template but this site supports multiple pages, and brings back the quicklaunch bar to help with navigation. 
• Blank meeting workspace – Same as the main meeting workspace, but no lists or webparts

Blog template
This is an improved version of the SharePoint 2007 blog template.

This template really shows off the power of what a SharePoint site template can do. Whilst there are lists for things like post, comments, and links, this site doesn’t really break down into our usual lists and webparts groups. Instead it feels very much like a custom site unlike any other. In this context it works well as a blog. If you are expecting Blogger or WordPress then you might want to think again. However if you are looking to give teams or individuals a voice on your SharePoint Intranet then you should find everything you want.

1. Select the root element in the tree on the left – it contains the name of the server.
2. Click on the "Change .NET Framework Version" link on the right panel. You will now see the "Change .NET Framework Version" dialog.
3. Select the .NET 4.0 framework from the drop down list.
4. Click [OK].

I hope that helps!

via Deploying .NET 4.0 applications using IIS 7.x

Setup your Remote Server
There are a few steps you have to take on your server to initialize and set it up running for remoting. once.
First, you need to run the following command on your server — Enable-PSRemoting

Next you need to let powershell know that your server machine or remote machine will act as the server.

Enable-WSmanCredSSP -Role Server

Setup your Client Computer
There are also a few one time setup steps you need to take on your client computer. You only have to do this once. The first thing to do, if you are going to use the logged in user’s credentials to make a remote session in powershell, is to enable client credentials delegation. This can be achieved by changing the group policy.
First, edit group policy on your client computer to all credential delegation. Using gpedit.msc, enable both of the following (Under Local Computer Policy–> Computer Configuration–> Administrative Templates–> System–> Credentials Delegation):

• Allow Delegating Fresh Credentials
• Allow Delegating Fresh Credentials with NTLM-only Server Authentication

Note: In case you are going to explicitly specify the credentials, you can skip the above step.

Second, run the following command
Enable-PSRemoting

Third, enable WSMan CredSSP with the following command:
Enable-WSManCredSSP -Role Client –DelegateComputer “NameOfServer”

Once you have configured remote powershell, now you are all set to run remote commands.

Create and enter a remote session of Windows PowerShell
If your current user on client machine has permission to the SharePoint farm and Windows PowerShell on the remote box, you can use Enter-PSSession to create and enter the remote session.
For example, connecting to machine SpServer…

Enter-PSSession -ComputerName SPServer
If it works, the command prompt will be changed to [SPServer]: PS C:\Users\Administrator\>.
The session will be closed when you type exit or Exit-PSSession.

To connect to a machine with CredSSP and a different credential, you can use
Enter-PSSession -ComputerName SPServer -Authentication CredSSP –Credential domain\username
This will open up a dialogue for you to type in password. Type in the password and press enter and your remote session will be created.

Store and use credentials for scripting

First, use the following command to covert password from keyboard input to a secure string in a text file.

Read-Host -AsSecureString | ConvertFrom-SecureString | out-file C:\crd-sharepoint.txt

As soon as you type the command, start typing the password.

When you need to create a credential object, read this password (the secure string) from the file and create the credential with the following command:

$pwd = Get-Content C:\crd-sharepoint.txt | ConvertTo-SecureString

then create the credential (replace #### with your domain\username):

$crd = New-Object -TypeName System.Management.Automation.PSCredential -ArgumentList "####",$pwd

Then you will be able to use this credential in the command line without any dialogue.

$session = New-PSSession -computername "SPServer" -Authentication CredSSP -Credential $crd

Start Remoting on you Client Computer

Now your client computer is ready to actually create the session and import the SharePoint commands from the Server.

The next command adds the SharePoint PowerShell commands to your session.

Invoke-Command -Session $session -ScriptBlock{Add-PsSnapin Microsoft.SharePoint.PowerShell}

Note, that at this point, you can run whatever administrative PowerShell commands you need to run by using the Invoke-Command -Session $session -ScriptBlock{} syntax.

Importing remote commands into local session

Let’s see how one can import a remote command into a local session. First – let’s ask Import-PSSession cmdlet to look in the remote session $s, take all the remote commands matching "*-SPFarm" wildcard, add a "Remote" prefix to their noun, and then present them to me as if they were local commands:

Import-PSSession -Session $session -CommandName *-SPFarm -Prefix Remote

So, now we can run Get-RemoteSPFarm

Thanks again Configure Remote PowerShell in SharePoint 2010