SQL Server Best Practices for SharePoint

Introduction SharePoint stores most of the data in SQL Server. Stress on SQL servers causes stress on front-end servers, which ultimately degrades the user experience. Healthy SQL Server = Healthy SharePoint! So here are the best practices for SQL Server with SharePoint 2010. Whether SQL Server 2005 or SQL  Server 2008 or…

Read more

Never Stop Windows SharePoint Services Web Application

If you stop the “Windows SharePoint Services Web Application” it will remove all SharePoint websites along with your customizations from IIS!!! So, Until you are very sure what you are doing, Never stop the Windows SharePoint Services Web Application. In case, it happened already then you have to apply ALL your IIS…

Read more

Configure Access Requests in SharePoint 2010/2007

Configure/Enable-Disable Access Requests in SharePoint Access Request feature enables users to request access to a site directly through SharePoint when they get an access denied page. By default SharePoint configures the access requests for a particular site collection to go to the person who created it. This configuration is for the entire…

Read more

SharePoint 2010 Database Naming Conventions

SharePoint 2010 Database Naming Standards/Conventions When it comes to SharePoint database naming standards, There are lot of patterns used by SharePoint Admins. Yes, it is a good practice to have a database naming convention. Not only just a good practice, but it will be good for your DBAs as well :-). and…

Read more

Configure People Picker for Multi-Domains (or Cross Domains), Forests Environments in SharePoint

By default, the people picker will issue queries to all two-way trusted domains and two-way trusted forests to search people & groups. It uses the application pool account to search the target domains and forests. If the application pool account does not have permission to the target domains or forests, or if…

Read more

SharePoint Column/Field Display Name vs Internal Name

In SharePoint, When we create a column on a site/list/document, It has two names:     Internal Name – which is the name given to it when it was created, and it won’t be changing.     Display Name – You can change the display name as many times as you want. The best…

Read more

Applying SharePoint Service Packs/Patches – Steps and Best practices

Well, it is inevitable in a SharePoint administrator’s life, Applying service packs or patches to the environment. Here are the steps, I’ve learned in my implementations. First, it’s a good idea to have a maintenance page for your website, in order to avoid a typical “404 – page not found” to the…

Read more

SharePoint Solutions – Building and Deployment Best Practices

SharePoint solution best practices: Based on my experience, here are the best practices w.r.t solutions management in SharePoint. 1. Every customization must be a Feature-based solution. Doesn’t matter if it’s a Webpart/Event Handler/InfoPath/Content Types or file system change. You can group the features together as solutions. The solution should have event handlers…

Read more

Exclude SharePoint Folders from Antivirus

In SharePoint servers, some of the SharePoint, IIS, SQL Server folders should be excluded from anti-virus protection in order to avoid performance hits! such as: (C:\ may be other drive as well) C:\Program Files\Microsoft Office Servers\14.0\Logs  C:\Program Files\Microsoft Office Servers\14.0\Data. C:\Program Files\Microsoft Office Servers\14.0\Bin C:\Program Files\Microsoft Office Servers\14.0\Synchronization Service,  C:\Documents and Settings\Default…

Read more