Popular Posts

Recent Posts

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

Characters in Midnight commander via Putty from Windows 8

Midnight Commander with unreadable characters

When I first started Putty on my Windows 8.1 x64, connected to my server and ran Midnight Commander, I saw picture like this (see drawing 1). Instead of separating lines there were unreadable characters. It wasn’t what I expected to see and the first thing came in my mind is to fix it.  Read more»

Windows

How to lock cells in Microsoft Excel 2013

Figure 1. Excel table

When you work in Excel with large tables, for example, price list, sometimes while scrolling you forget what columns you are watching. To make more comfortable work with tables you can fix position of cells (row or column) so that other cells to be scrolled and the cells with names are fixed. Read more»

Microsoft Office

Get List info by ID in SharePoint

Using PowerShell it’s rather easy to find information list. In messages about denied access (especially in custom SharePoint solutions) you can see in URL ID of denided list. To find-out where it is you can using this script:  Read more»

SharePoint