When you modify columns of a table in MS SQL management studio, you got the message "Saving changes is not permitted. The changes you have made require the following table to be dropped and re-created … " (Figure 1). The reason of this is re-creating of table. It's really important for productive environment but not very for test ones.

(read more...)

Rename table in MS SQL Server:

sp_rename 'old table name', 'new table name'

For a massive update of a SharePoint list items I didn't want users, who subscribed for alerts about changes in the SharePoint list, got the messages about it. There were 2 ways to do it: 1 - temporary to disable SMTP server (change SMTP settings to wrong ones) and delete files from Queue folder after; 2 – temporary to disable alerts for a list. This story is about the second way.

(read more...)

As a result of experiments with WPF controls I got the error in Visual Studio 2013. I started to look for records in block "using", but it was all right there. (read more...)

To recover password of SharePoint Farm, you need to log on with a Local Administrator account on a server with Central Administration. To recover passwords for Web Applications or services you need to log on with Administrator account to server where it is running. (read more...)

Word allows you to create a Table of Contents automatically. It searches headings in your document and creates contents according to them. Headings must be set via headings styles in tab "Home". (read more...)

In PowerShell you can use a lot of modules and classes of your machine. Built-in system class "System.Environment" allows you to get a lot of useful information about your machine. Its syntax is like this [System.Environment]::class_property or [System.Environment]::class_method.

(read more...)

SharePoint 2010 can be installed as a Farm installation or as Standalone one.  Standalone installations means that all the components are on the same machine (SharePoint, SharePoint services and built-in database) and this type of installation is not extensible.

(read more...)

There's a possibility to create and use .NetFramework class in PowerShell via cmdlet "Add-Type". You should use New-Object cmdlet to instantiate objects.

(read more...)

You can merge Excel cells in 3 simple steps:

1. Select a range of cells.
2. Right click on the selected cells and then choose Format Cells (Figure 1)
3. Go to the Alignment tab and check the checkbox "Merge cells" (Figure 2).

The other way to merge cells in Excel is via Excel Ribbon. This way is one step less. (read more...)