Once when I started to work over the project which used about 30 SharePoint Lists and their data should be displayed on some interfaces, I decided to use Sandboxed solution. When I started Visual studio and began to write code, everything was fine. No restarting IIS after deploying, I could easily press F5 and not to wait for restarting application pool in 1 or 2 minutes. (read more...)

If you have some site collections but your database grows every day. In  MSSQL size of database should be less than 200 Gb. So if your content database size less than 100Gb you can easily use only 1 database – it’s easier to backup and restore it. (read more...)

If you still don’t have a content database to move site collection, you need to create it. You can do it via SharePoint Central Administration or via PowerShell. Your account must be at least dbcreator role (better db_owner). (read more...)

To understand the size of site collection, you can use DiskUsed property in PowerShell console. (read more...)

Before moving sites between content databases, you should know a quantity of your databases for your WebApplication. You can move sites between content databases only if they are in the same WebApplication! (read more...)

Using SharePoint there can appear orphans objects. This is when there must be an object – there are records about it in database, but there’s no this object. It can be a result of incorrect deletion or troubles with network while working. (read more...)

The task – create SharePoint list so that users could only add list items but couldn’t see any items, even created by them, and, of course, couldn’t edit or delete them. May be there are some ways to do it, but I found this solution to create new permission set - user can add view site pages, view modal pages, add list items but cannot read and delete any list items. (read more...)

The PowerShell script below extracts one file from zip-archive which contains several files. I use code like this to get files with financial references from zip-archives and update SharePoint lists from them. So there's a lot of things where this sctipt can be used. (read more...)

Today I was surprised to see duplicated records in SharePoint list which I imported and updated from XML-files. So I started to find a solution to find duplicated records, see them and delete. (read more...)

While creating a test SharePoint 2010 Farm I have installed all the software, solution, attached content database and wanted to see the result being on one of front-end servers, sp10wfe1. Test portal URL is http://sp10. So I entered URL in browser http://sp10 and wanted to see a site. Browser asked me about login and password, I entered them once, twice. On the third try it just show empty window. (read more...)