Отключение автоматической аутентификации в Internet Explorer

При разработке веб-приложений с анонимным доступом или отличной от Windows аутентификацией необходимо отключить автоматическую проверку подлинности. К примеру, это очень актуально при разработке приложений для SharePoint.  В принципе, все браузеры кроме Internet Explorer не поддерживают автоматическую авторизацию, потому это только для пользователей Internet Explorer. Read more»

April 29, 2016. Alexey

SharePoint

Migrate managed metadata to new SharePoint farm. Fix cannot bulk load error

Managed metadata is very good and powerful tool in SharePoint. But it has some not very comfortable specialties during migration data from one farm to another, for example, from test environment to productive. You can export your managed metadata from one site and import it into another one. But here’s the problem that each termset and […] Read more»

April 25, 2016. Aleksei

SharePoint

C# write file to MyDocuments

Using class System.Environment you can get paths of special Windows folders such as Program Files, My Documents and others. The list of available values is stored in enum object Environment.SpecialFolder (Fugure 1). Read more»

April 21, 2016. Aleksei

.Net & C#

Count rows in result of SQL query

To receive quantity of rows of the returned records of SQL query, you should use function @@ROWCOUNT. Function @@ROWCOUNT returns the quantity of rows, which were used in a query. Read more»

April 6, 2016. Aleksei

SQL and databases

Transact SQL: Get list of all databases in server

How to get as SQL query result the list of databases in SQL server. select name, database_id  from sys.databases   Read more»

March 24, 2016. Aleksei

SQL and databases

Saving changes is not permitted in MS SQL Management studio

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

March 13, 2016. Aleksei

SQL and databases

Rename table in MS SQL Server

Rename table in MS SQL Server: sp_rename 'old table name', 'new table name'   Read more»

March 12, 2016. Aleksei

SQL and databases

Включить или отключить отправку оповещений в SharePoint 2010 из PowerShell

Для изменения большого числа записей в списке SharePoint, на который было подписано много человек, столкнулся с задачей, чтоб в это время пользователи не получили кучу сообщений. Думал про 2 реализации отключения оповещений: 1 – изменить настройки SMTP сервера на заведомо неверные, чтоб вся почта скопилась в папке Queue, а потом ее удалить; 2 – временно […] Read more»

March 6, 2016. Alexey

SharePoint

Enable and disable SharePoint alerts via PowerShell

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

March 5, 2016. Aleksei

SharePoint

Fix error “System.InvalidCastException [A]Microsoft.Expression.Utility.Controls.ClearableSearchTextBox cannot be cast to [B]Microsoft.Expression.Utility.Controls.ClearableSearchTextBox”

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»

February 5, 2016. Aleksei

.Net & C#