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

There’s a table in SharePoint content database where all the events are written in case if audit is turned on. But SharePoint doesn’t display real-time statistic about users on site, it gives you statistic only on the next day. (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...)

Working  with local copy of my WordPress site I found that I don’t see my uploaded images – I see thumbnails, but don’t see original images. My PC  OS is Windows 7 x64, local web server – IIS. When I tried to open image, I got error 500 – in IIS it can be anything. (read more...)