SharePoint 2010 database model has been changed significantly in the way of distributing data across several databases that makes horizontal distribution of SharePoint 2010 solutions very feasible. There are three areas of changes - architecutre changes, new databases and new tables. Architecture Changes SharePoint 2007 stored all content in large tables (for example lists, site collects end etc were represented as a huge table), and the performance were affected by SQL Server locks, esp...

When you start new SharePoint project it's very important to understand the size of a farm you are planning to end up, because it impacts on : SharePoint farm topology SQL Server hardware Staff needs Capacity planning SharePoint Farm Topology size There are 3 farms topologies, you choose between - Small, Medium and Large. Your farm topology choice is usually dictated by the number of users and content your plan to use inside SharePoint. They recommend the following va...

Sometimes you have a already created site but wanted to know the site definition of that site, or gets the name of the site definition from which the site template that was used to create the site is derived. There are several steps to get that template First method Navigate to the “Central Administration –> Application Management –> Site Collection List” and choose the site you are trying to find the template for Write down site "Title” and “Database name” values ...

SharePoint provides OOTB support for document versioning, allowing user to check-in/check-out files, and keep history of changed documents. But unfortunately, versioning system doesn't provide inbuilt method to find these all check-out items made by users. For some administrative task and farm maintenance it's recommended to have all files to be check-in before making changes. And this task became daunting task for administrators, because you need to check all site collection and list collecti...

The administrative way of getting SharePoint version is navigating to “Central Administration > Operations > Servers in Farm”. But what if you need to get version programmatically?! It might be that your feature relies on the specific version, lets say SharePoint SP1 + Infrastructure Update installed, and you need to check version of the SharePoint when feature installs. The way to get version programmatically is use the following SQL script 1: SELECT Version, UserName ...