Popular Posts

Recent Posts

Script for calculating SharePoint SPWeb size

SharePoint portal in active company grows like an anthill. Setting limits of SharePoint sites can protect from problems with disk spaces, but it makes more users requests that not all the administrators like. So I think a good tone not to set limits on SharePoint sites. Read more»

SharePoint

SELECT from table WHERE items IN (@variable)

You need to make query like “SELECT * from tbl WHERE items IN (‘item1’, ‘item2’, ‘item3’, ‘item4’)” and you want to send items to IN clause as variable. It’s nice when, for example, you want to execute Stored procedure or, as in example below, use INSERT … SELECT construction. Then you need to make a […] Read more»

SQL and databases

Copy file to all SharePoint farm server using PowerShell

If you have a SharePoint Farm and you need to update only one file, for example, in LAYOUTS dir (c:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\TEMPLATE\…), there’s no need to go to every server and copy file. Using PowerShell and some strings of code below you can easily do it. Read more»

SharePoint

How to change SQL server in SharePoint Farm

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 […] Read more»

SharePoint

Create FTP Site in IIS in Windows 8

Figure 2. Add FTP Extension for IIS

No so long ago I decided to create FTP site for my home local area network. I wanted to read and write files not via file sharing but via File Transfer Protocol (FTP). I had Windows 8 Home Edition on my PC. So this PC became server for my FTP site. Read more»

Windows