How to Create a Site Collection in a Specific Content Database

You can follow the below steps if you have a requirement of creating a Site Collection in to a Specific Database when you have multiple Content Db for a Particular web application .

1. Under the Application Management section access the “Content Databases” link.


2. In the upper right hand corner make sure you are in the correct Web Application. If you aren’t then change to the correct one.


3. Click the link for each Content Database you have listed under the “Database Name” heading.


4. When the “Manage Content Database Settings” page opens set the “Database Status” to “Offline” and then click “OK”. After you click ok you’ll be taken back to the “Manage Content Databases page where the database you just changed should now show as “Stopped”.


5. Click the “Add a Content Database” link and create a new content database. Do not make any changes to the “Database Status” setting. It will show as “Started” in the list of Content Databases. You will also notice that the “Current Number of Sites” will be equal to 0.


6. Navigate to the SharePoint Site Management section and create your new site collection.


7. Go back to the Manage Content Databases list and you will now see that the Content Database you just created now shows that the Current Number of Sites is equal to 1.

You have just created a new site collection in the content database of your choice.

SharePoint 2010 useful links

Manage Excel Services trusted locations  

This article explains how to manage the default trusted location for a SharePoint Server 2010 farm. It also explains how to add, configure, delete, and edit existing trusted locations for Excel Services in Microsoft SharePoint Server 2010.

http://technet.microsoft.com/en-us/library/ff191194(office.14).aspx

Manage Excel Services connections  

This article explains how to deploy Excel workbooks with external data connections using Excel Services. It provides details for managing both trusted data connection libraries and trusted data providers.

http://technet.microsoft.com/en-us/library/ff191200(office.14).aspx

Manage Excel Services authentication  

This article explains how to manage Excel Services settings using the Central Administration site.

http://technet.microsoft.com/en-us/library/ff191192(office.14).aspx

Manage Excel Services with Windows PowerShell  

This article explains how to use the Windows PowerShell commands with Excel Services. It also provides several sample commands.

http://technet.microsoft.com/en-us/library/ff191201(office.14).aspx

Configure Secure Store Service for Excel Services  

This article explains how to configure and manage the Secure Store Service for Excel Services. It also provides details for setting permissions and accounts to use the unattended account with Excel Services.

http://technet.microsoft.com/en-us/library/ff191191(office.14).aspx

Plan visual upgrade (SharePoint Server 2010)  

This article discusses the new visual upgrade feature in SharePoint Server 2010. You can choose to preserve the look and feel of sites during an upgrade from Microsoft Office SharePoint Server 2007, or you can move all sites to the new user interface.

http://technet.microsoft.com/en-us/library/ff191199(office.14).aspx

Create a PowerPivot data connection (PerformancePoint Services)  

This article describes how to create a data source connection to PowerPivot using PerformancePoint Services.

http://technet.microsoft.com/en-us/library/ff191197(office.14).aspx

Create a SharePoint List data connection (PerformancePoint Services)  

This article describes how to create a data connection to a SharePoint Server 2010 using PerformancePoint Services.

http://technet.microsoft.com/en-us/library/ff191195(office.14).aspx

Create a SQL Server table data connection (PerformancePoint Services)  

This article describes how to create a data source connection to a SQL Server table using PerformancePoint Services.

http://technet.microsoft.com/en-us/library/ff191190(office.14).aspx

Create an Analysis Services data connection (PerformancePoint Services) 

This article describes how to create an Analysis Services data connection in PerformancePoint Services.

http://technet.microsoft.com/en-us/library/ff191198(office.14).aspx

Create an Excel Services data connection (PerformancePoint Services)  

This article describes how to create a data source connection to Excel Services using PerformancePoint Services.

http://technet.microsoft.com/en-us/library/ff191193(office.14).aspx

Create an Excel Workbook data connection (PerformancePoint Services)  

This article describes how to import a workbook using PerformancePoint Services.

http://technet.microsoft.com/en-us/library/ff191202(office.14).aspx

Create data connections (PerformancePoint Services) 

This article provides an overview on creating data connections to external sources using PerformancePoint Services.

http://technet.microsoft.com/en-us/library/ff191196(office.14).aspx

Plan for backup and recovery (SharePoint Server 2010)  

This article has been updated to include a link to a planning worksheet, and includes updated information about choosing a backup solution.

http://technet.microsoft.com/en-us/library/cc261687(office.14).aspx

Backup and recovery overview (SharePoint Server 2010)  

This article has been updated to more fully describe granular backup, and how SharePoint Server 2010 backup works with the SQL Server FILESTREAM remote BLOB storage provider.

http://technet.microsoft.com/en-us/library/ee663490(office.14).aspx

Configure and use the Lotus Notes connector (SharePoint Server 2010)  

This article describes the process for installing and configuring the Lotus Notes connector for SharePoint Server 2010.

http://technet.microsoft.com/en-us/library/ff463593(office.14).aspx

Language packs (SharePoint Server 2010)  

This technical reference article lists the language packs that are available for SharePoint Server 2010.

http://technet.microsoft.com/en-us/library/ff463597(office.14).aspx

Restrict or enable access to a service application (SharePoint Server 2010)  

This article describes how to restrict access to a service application by assigning and removing service accounts. It also describes how to reestablish local farm-wide service access to a service application.

http://technet.microsoft.com/en-us/library/ff463596(office.14).aspx

Diagnostic logging in Business Connectivity Services overview (SharePoint Server 2010)  

This article describes how to use diagnostic logs on servers that are running SharePoint Server 2010 and on Microsoft Office 2010 client applications to troubleshoot issues related to Microsoft Business Connectivity Services. It also describes how to use Activity IDs to trace issues to external systems.

http://technet.microsoft.com/en-us/library/ff463594(office.14).aspx

Versioning, content approval, and check-out planning (SharePoint Server 2010) 

This article describes how to plan to use versioning, content approval, and check-out functionality in SharePoint Server 2010 to control document versions throughout their lifecycle.

http://technet.microsoft.com/en-us/library/cc262378(office.14).aspx

Records management overview (SharePoint Server 2010)  

This article describes records management and provides an overview of the process of planning for records management.

http://technet.microsoft.com/en-us/library/cc261982(office.14).aspx

Create a file plan to manage records in SharePoint Server 2010  

This article describes the contents of a file plan and summarizes how to create one for your organization.

http://technet.microsoft.com/en-us/library/cc261708(office.14).asp x

Plan how records are collected (SharePoint Server 2010)  

This article reviews techniques that you can use to declare active documents to be records.

http://technet.microsoft.com/en-us/library/cc263464(office.14).aspx

Physical records planning (SharePoint Server 2010)  

This article describes how to plan to use SharePoint Server 2010 to manage physical records.

http://technet.microsoft.com/en-us/library/cc263416(office.14).aspx

Planning for eDiscovery (SharePoint Server 2010)  

This article describes how SharePoint Server 2010 supports eDiscovery.

http://technet.microsoft.com/en-us/library/ff453933(office.14).aspx

Plan Visio Services security (SharePoint Server 2010)  

This article describes security for Visio Services in Microsoft SharePoint Server 2010. It has been updated to provide additional information about available security options.

http://technet.microsoft.com/en-us/library/ee663483(office.14).aspx

Create a Visio Graphics Service application proxy (SharePoint Server 2010)  

This article describes how to create a Visio Graphics Service application proxy. It has been updated to clarify when such a proxy can be created by using the SharePoint Central Administration Web site.

http://technet.microsoft.com/en-us/library/ee524060(office.14).aspx

Configure Visio Graphics Service global settings (SharePoint Server 2010)  

This article describes the various global settings for Visio Graphics Service. It has been updated to include more information about cache and recalculation options.

http://technet.microsoft.com/en-us/library/ee524061(office.14).aspx

Configuring Visio Graphics Service trusted data providers (SharePoint Server 2010)  

This article describes Visio Graphics Service trusted data providers configuration. It has been updated to provide more detailed information about the included trusted data providers.

http://technet.microsoft.com/en-us/library/ee524056(office.14).aspx

How to add a Video on Sharepoint Site

 A Very Simple way to Embed a video on your sharepoint site.  

1. Upload a media file to a standard SharePoint Document Library


2. Navigate to the site where you want to embed the video


3. Edit the page and select Add a Web Part


4. Under Miscellaneous, insert a Content Editor Web Part


5. From the Web select Open the Tool Pane


6. From Tool Pane, select Source Editor


7. Copy in the following code (replace http://link to video here with the actual link to the video in the library):

<div align="center">

   <embed src="http://link to video here"

      autoplay="true"

      loop="false"

      width="200"

      height="200"

   </embed>

</div>

Click Apply and Voila :)