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: 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»
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»
Generic handlers have an extension .ASHX. It’s a good solution to render documents or images for user on server-side after user requests, not web page. Generic Handlers solution (.ashx files) are not directly supported by Visual Studio 2010 for SharePoint projects. But there’s a little trick for this. Read more»
During long use of Microsoft products, I got a habit that to update Microsoft Office I need to download Service Pack for my MS Office version. But in MS Office 2013 I can easily press some buttons for updates. Read more»
Source: a lot of money values returned from SQL as strings. For example, “1500312.32”, “2382938.12”, “283727361.10” etc. The task: display money values in format “1 500 312.32”, “2 382 938.12”, “283 727 361.10”, etc. Read more»
