Popular Posts

Recent Posts

Visual Studio shortcut keys

I found a great collection of Visual Studio shortcuts. While coding I often comment some lines of code.  Using shortcuts it’s even more easy. It’s not a common combination – select lines to comment and press Ctrl + K then Ctrl + C, to uncomment  – Ctrl + K then Ctrl + U. Read more»

.Net & C#

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