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»
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»
How to get as SQL query result the list of databases in SQL server. select name, database_id from sys.databases Read more»
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»
Rename table in MS SQL Server: sp_rename 'old table name', 'new table name' Read more»
Для изменения большого числа записей в списке SharePoint, на который было подписано много человек, столкнулся с задачей, чтоб в это время пользователи не получили кучу сообщений. Думал про 2 реализации отключения оповещений: 1 – изменить настройки SMTP сервера на заведомо неверные, чтоб вся почта скопилась в папке Queue, а потом ее удалить; 2 – временно […] Read more»
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»
![[A]Microsoft.Expression.Utility.Controls.ClearableSearchTextBox cannot be cast to [B]Microsoft.Expression.Utility.Controls.ClearableSearchTextBox](https://realdevtips.com/wp-content/uploads/2016/02/vserrors-300x162.png)
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»
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»
