Unfortunately, there’s no equivalent for "Truncate" in SharePoint Lists. It’s not very good. If your list has more than 1000 items and you need to load only new data to list, you need to remove all existing items and to add new ones. This task is easy to code but not very fast to execute. (more...)

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

In this post I'll describe two ways to sort List<T> generic collection by one of it's fields. It's very useful and not easy for beginners. (more...)

WordPress was updated automatically to 3.9, and Crayon plugin I have updates some later manually.

While writing post with it I haven’t found a button to open dialog of Crayon Syntax Highlighter. (more...)

Using this method you can copy attachments from one list item to another. You can add it to SharePoint workflow or any other action. (more...)

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 fint with quotes. (more...)

According to one of Windows 8 interface developers Jacob Miller, metro-interface was made not for advanced users but for housewives who use PC only to set "Like" in popular social network. But advanced users don’t think the same as Jacob. (more...)

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

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 2008 R2 with another name and actions after restoring databases from backup. (more...)

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