SharePoint Managed Paths Explained

Let me document the Frequently Asked Questions on SharePoint Managed Paths during my training sessions: What is Managed Path in SharePoint? A managed path is a location within a web application in which you can have site collections. When you create a web application, there are two managed pa…

Export SharePoint Survey Results to Excel

Requirement: is to consolidate and analyze a SharePoint survey results by exporting the data to Excel Spreadsheet. Solution: Go to the survey overview page, Export SharePoint survey results to excel by clicking  Actions >> Export to Spreadsheet SharePoint 2010 Survey Export to Sprea…

SharePoint SQL Server Database Went Offline Mode - How to Bring it back to Online?

Suddenly SharePoint Database Went Offline. Analyzed Event Logs and found Database went offline because: Backup failure. SQL Server How to Bring Database Online? Alright, How to Bring it back to Online? one line T-SQL! ALTER DATABASE STS_G1WSS01_1385353007 SET ONLINE Database is up and …

SharePoint 2010 Keyboard Shortcuts

Did you know we can use keyboard shortcuts in SharePoint 2010? Yes, As part of Accessibility standards, SharePoint 2010 offers keyboard shortcuts. How to use these shortcuts? use ALT + [key] and then ENTER (To do click action!) Here’s the list of useful keyboard shortcuts: [Key] can be: …

Closed Web Parts in SharePoint - How to Find, Restore and Delete

Closed Web Parts? What are they? When users don't need a particular web part on the page, they click on Edit drop down from Web Part Menu, and choose "Close" instead of Delete. They prefer Close rather Delete which is obvious! Technically, When you close a Web Part, It doesn'…

Hidden Screen Capture Utility in Windows 7

Windows 7 comes with an In-Built Screen recorder: Problem Steps Recorder to record screen with series of screenshots and text. Its greatly helpful when we want to reproduce end-users issues and troubleshoot. How to open : Problem Steps Recorder? Go to Run >> Type "PSR" It la…

Drive Space Monitoring using PowerShell Script

In SharePoint servers monitoring disk space is a common administrator task. Because, SharePoint servers may run out of disk space from SharePoint, IIS Logs, SQL Server transaction logs or even from SharePoint content (If you don't have Quotas enabled!) There are a lot of first-party, third-…

Stop and Start SharePoint 2010 Services

In my Laptop with Windows 7, I've SharePoint 2010 Installed for my tryouts. I use it whenever I'm out of network connectivity. Problem is: Not quite frequently I use SharePoint from my laptop, but SharePoint services starts automatically when I turn-on my laptop and eating up my resour…

Delete All Items from List or Library using PowerShell

At times, we may have to delete all items from SharePoint list or library. We can get it done by going to "Manage Content and Structure" option as in my another article How to Remove All responses from SharePoint Survey There may be situations, where we've to delete all items fr…

How to Create SQL Server Alias for SharePoint?

In My SQL Server best practices for SharePoint 2010 , I wrote a point on SQL Server Alias. Let me elaborate that by going little deep on configuring SQL alias for SharePoint. Why We need SQL Alias for SharePoint? When installing SharePoint, you'll be prompted to enter the SQL Server insta…

Move Site Collection to a Different Managed Path

Created a Site Collection under wrong Managed Path? Now want to move the site collection to another managed path? Unfortunately there is no way, other than: Backup your source site collection Delete the source site collection Restore the site collection with the desired target URL! There is…