If you removed a number of SharePoint list items (moved to Recycle Bin), I think you want to clean the Recycle from them. Of course you can remove them manually but it’s not a good idea if you have deleted 10000 records or more (Remove a lot of elements from very large SharePoint Lists). (read more...)

Lists in SharePoint is only look like database tables but not they are. For some things they are even better than databases – for common users for example, but for developers and administrators they are often not so good and friendly. (read more...)

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...)