SharePoint Diary

SharePoint Managed Paths Explained

November 26, 2012 Managed Path, Reference, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016

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

November 24, 2012 CSV, SharePoint, SharePoint 2010, Survey

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?

November 22, 2012 SharePoint, SQL Server, Troubleshooting

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

November 20, 2012 SharePoint, SharePoint 2010, Shortcuts, Tips and Tricks

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

November 19, 2012 Best Practices, CSV, SharePoint, SharePoint 2007, SharePoint 2010, SharePoint 2013, SharePoint 2016, Web Parts

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

November 16, 2012 SharePoint, Utilities

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

November 14, 2012 Admin Reports, Administration, Alerts, Monitoring, SharePoint, SharePoint 2010

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

November 13, 2012 SharePoint, SharePoint 2010, Utilities

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

November 12, 2012 CAML, Object Model, PowerShell, SharePoint, SharePoint 2007, SharePoint 2010, SharePoint 2013, SharePoint 2016

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?

November 12, 2012 Best Practices, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016, SQL Server

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

November 09, 2012 Managed Path, SharePoint, SharePoint 2013, SharePoint 2016, Site Collection

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…

Disclaimer