What is Entity Service Object? How it is related to Business Data Connectivity model? You can read the terms in business connectivity services here. The Entity Service Object is equivalent to ADO.NET provider for SQL Server and Entity class represents the row of data. Create Business Model Project in Visual Studio 2010 to create a service object. Create a Business Data Connectivity Model Project...
List Throttling in SharePoint 2010
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...
SQL Server High Availability Solutions Overview
This post discusses about high-availability solutions for SQL servers databases. High Availability solution addresses hardware or software failure and maintains the availability of applications with minimum downtime to users. It also discuss the considerations for choosing the available options. Options for High Availability solution for a SQL Server or Database are • Failover...
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...
SSIS Deployment Models in SQL Server 2012
SQL Server 2012 supports two different SSIS deployment models one is Package Deployment model and another is Project Deployment model. This post describes the characteristics and compares the two different models. Package Deployment Model This model was used in previous versions of Integration Services, Unit of deployment in this model is package and it is stored as DTSX file...
Integration Services Catalog in SQL Server 2012
Integration Services Catalog is a new feature in SQL Server 2012 which supports the centralization of storage of packages and configuration files. You can host only one catalog for one SQL Server Instance. When you deploy your project using project deployment model all project components stored in catalog. This post describes how to create a catalog and set the properties.
General Interface Changes in SQL Server 2012 SSIS
The Visual Studio Environment introduces some user-interface changes from previous version of Business Intelligence Development Studio(BIDS). The new interface contains the enhanced appearance of tasks and dataflow components with rounded edges and icons. Change in New Project Dialogue Project There are only two templates available for Integration Service Projects now Integration Service...
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...