Heavy database operations on SharePoint server may sometimes affects the user experience; SharePoint 2010 introduced a concept of List Throttling which prevents your server being going down. List Throttling allows an administrator to specify the maximum number of items that can be retrieved in a single request. For example, if user creates a view with page size 5000 but if administrator limits...
Adding Search functionality for external list in SharePoint
This post describes adding search functionality to external list that created using SharePoint designer. Create a list based on external content type and give a name, when you browse this list for editing, you will notice that values can be selected from the data picker control as shown below It is not user-friendly search; you can give better search functionality by browsing to model...
Useful PowerShell Commands in SharePoint 2010
Using PowerShell is very useful and powerful approach for many SharePoint activities. Microsoft officially recommends to you use PowerShell as it intended to deprecate STSADM in the future. This post explains PowerShell cmdlets(commandlets).Scripting is easier when using PowerShell, you can access every method and property of every object. You have to use right shell to write the...
Physical Deployment Options SharePoint 2010
Physical deployment in SharePoint is something you are determining how many servers you will deploy in Server Farm. You can read my previous post on SharePoint farm topologies here. The common question when you deploying your solutions is How many servers I will need? How do I know? Simple answer is consider your usage plan, uptime needs, number of users and application processing demands...
Privileges to setup and run SharePoint 2010
This post provides the information about service accounts and administrative privileges to setup and run the SharePoint 2010. The below table describes the required Privileges that required to install the SharePoint 2010 Account Description SQL Server Service Account It has to be either a local system account or a domain user account. This account is for SQL server services named MSSQLSERVER and...
PowerShell Command to backup SharePoint Service Application
Typically, Service Applications will be backed up as part of a full farm back-up, along with all other components of the farm, If you want to backup individual service applications such as Managed Metadata service, User Profile Service then you can use Windows PowerShell to back up the SharePoint service application, below steps describes the procedure. You are required to have farm...
Business Data Connectivity Service Example
This post explains surfacing the Adventure Works table data in SharePoint. You can read my previous post on Business Data Connectivity Service terms here. Business Connectivity Services is the set of services and components that enables the connectivity between heterogeneous business systems. SharePoint 2010 Business Connectivity Services can be used to connect any data source to present the...
File type in FAST Search Server for SharePoint 2010
Microsoft FAST Search Server 2010 has enhanced search capabilities, content processing features and integration capabilities. You can configure the FAST Search Server in Farm or can install on multiple servers to meet your search demanding requirements. FAST Search Server crawls and extracts metadata from different file types. Scenario – Assume you have a document library which contains several...
Business Data Connectivity Service terms in SharePoint 2010
Business Connectivity Services is the set of services and components that enables the connectivity between heterogeneous business systems. SharePoint 2010 Business Connectivity Services can be used to connect any data source to present the business data as SharePoint content. Now it is easy to create business applications which involves read, write operations using a single data access platform...
Protecting SharePoint from Viruses
General assumption that file-system anti-virus software also scans the SharePoint document libraries. Wrong! It will not detect viruses stored in document libraries so install an antivirus solution for SharePoint. SharePoint does include any type of antivirus protection, you must purchase this separately. This post discuss about available products and configuring the antivirus feature in...