Rename table in MS SQL Server
Rename table in MS SQL Server: sp_rename 'old table name', 'new table name' Read more»
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»
Fix error “System.InvalidCastException [A]Microsoft.Expression.Utility.Controls.ClearableSearchTextBox cannot be cast to [B]Microsoft.Expression.Utility.Controls.ClearableSearchTextBox”
![[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»
Retrieve passwords for SharePoint 2010 Farm, Web Application and Service Application Accounts
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»
Create Table of Contents in Microsoft Word
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»
Using System.Environment Class in PowerShell
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»
How to find out the type of SharePoint installation
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»
Add-Type. Create .NetFramework Class equivalent in PowerShell
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»
How to merge Excel cells
You can merge Excel cells in 3 simple steps: Select a range of cells. Right click on the selected cells and then choose Format Cells (Figure 1) 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 […] Read more»
How to rotate text in Excel cell on 45 degrees
Excel has a huge number of tools for customizing text and tools to count data. So, one of useful things is to rotate text on any angle. It can be useful for customizing table headers. Read more»