If you need to go through some steps of disaster recovery plan with your SharePoint 2010 Farm after falling down your MS SQL server (of course if it’s not on the same machine with your SharePoint), there are some steps to do it. I’ll describe steps how to install another instance of MS SQL Server 2008 R2 with another name and actions after restoring databases from backup. (read more...)

Using PowerShell it's rather easy to find information list. In messages about denied access (especially in custom SharePoint solutions) you can see in URL ID of denided list.

To find-out where it is you can using this script:  (read more...)

Sometimes you may need to show information in SharePoint list only how you want it but not users. You create a list view and hope than other users will not change anything. But to be more assured that list view will be the same as you created it, you need to disable a change of list view in SharePoint list. (read more...)

In SharePoint site you can see usually a lot of groups. Sometimes administrator gets a task to add user to several groups. If it’s 3-5 groups you can do it manually, but if you need to add user to 30 groups? I’m too lazy to do it manually and too smart not do it at all. (read more...)

While migration system and its data to SharePoint application there was a task to save logs of change from old system data. Some authors of changes have already retired - some of them are disabled in Active Directory, others – deleted at all. (read more...)

Today I wanted to execute PowerShell ISE on one of SharePoint Server, but I couldn’t find it. I searched for it but on this server I haven’t installed it. I have already forgotten how to add PowerShell ISE to Windows Server 2008R2. It’s not included in default settings because PowerShell ISE is not necessary for Windows Server. And I think it’s true. (read more...)

Once one friend of mine was making s SharePoint web-part with a lot of available filters. He couldn’t make it with only list so webPart was the only way. (read more...)

Once I needed a CAML query for selecting elements with non-empty column. I wanted to select all the users with name detected (filled) and with OS "Windows".

First I decided to use <Neq> construction and <Value Type='Text'></Value>. I thought it’s an analog for var != "". But the result was wrong. (read more...)

In a list with a field type “Choice” you can know available options of this field from codebehind without reading all list values and not making them unique with Distinct(). Especially, you can’t just read and make Distinct() list values if your field allows multiple choice or if you don't have all options. (read more...)

Today I needed to know a quantity of SharePoint List. Somewhy SharePoint doen't give this information using common tools. But using PowerShell it appeared to do easy. (read more...)