Unable to delete library in Record Center

Run "Hold Processing and Reporting” timer job and then delete the library

Single user to Multi user mode - SQL

select d.name, d.dbid, spid, login_time, nt_domain, nt_username, loginame from sysprocesses p inner join sysdatabases d on p.dbid = d.dbid  where d.name = databasename


kill process1 (resulting from the query above)
kill process 2(resulting from the query above)

kill process n(resulting from the query above)

SET DEADLOCK_PRIORITY HIGH

ALTER DATABASE databasename SET MULTI_USER

Registering new apps in SharePoint App Catalog

You will get an Access denied to the appregnew.aspx unless you are an SCA on the App catalog site collection.

Entity Extraction and list item with attachments

We also have a number of lists having list items with one or more attachments.  In our case, we enabled the OOTB entity extraction to produce some additional refiners. If you have enabled entity extraction on the "body" managed property, entity extraction will fail on any list item with an attachment and that list item and its attachments will NOT be indexed, and as a result, will not appear in search results.
Microsoft is in the process of developing a hotfix for this. When we successfully apply it, I will post our results

Source: http://social.technet.microsoft.com/Forums/sharepoint/en-US/9a958806-ed69-478e-8290-4ce6a6ea8c2c/the-content-processing-pipeline-failed-to-process-the-item-issue?forum=sharepointsearch

401.2 in my provider hosted app

I kept getting the 401.2 error when I switched from IIS express to IIS to host my Provider hosted web form app. Thanks to this awesome blog (http://blogs.technet.com/b/speschka/archive/2012/11/01/more-troubleshooting-tips-for-high-trust-apps-on-sharepoint-2013.aspx) , I fixed the authentication. Anonymous disabled, Windows Integrated Mode enabled and problem solved.
 

Provider Hosted Apps and host header names in IIS

http://lixuan0125.wordpress.com/2013/09/26/sharepoint-2013-apps-404-error/

VSCommands for Visual Studio

VSCommands for Visual studio is a Visual Studio extension that provides a lot of short cuts for the most common things you do in VS. As a first step, I was able to group my files without having to use folders. Just highlight the files you want to group, right click and group items. 

Full Trust Provider Hosted App - Cert folder permission

This is something I wouldnt worry about on my dev environment, since my app pool account is also my farm admin  since I use a single account for everything. But this is important when deploying an app to test/production.


On the SharePoint server, be sure that the app pool identity for the following IIS app pools have Read rights to the C:\Certs folder:

• SecurityTokenServiceApplicationPool
• The app pool that serves the IIS web site that hosts the parent SharePoint web application for your test SharePoint website. For the SharePoint – 80 IIS website, the pool is called OServerPortalAppPool.

Source: http://msdn.microsoft.com/en-us/library/office/fp179901(v=office.15).aspx

Windows Service marked for deletion

I tried to use the sc.exe delete "Servicename" and it said that the "Service has been marked for deletion". Earlier, I had used installutil /u to uninstall it. Since, both of them did not work, I wasnt sure what else I had to do. Then, I realized that I had the services MMC open. Close it and the service gets deleted.

Manage Servers in SharePoint shows "Upgrade required", even after applying updates

Run the following command on the servers where upgrade is required

PSConfig.exe -cmd upgrade -inplace b2b -force -cmd applicationcontent -install -cmd installfeatures

Then run the SharePoint Configuration Wizard on the servers where upgrade is required

Site Count from Content Database is 0

This happens when the powershell script  that overwrites an already existing db from the bak file does not do it properly. In order to fix this, do the following


1. Dismount the Content Database from SharePoint
2. Remove the Content Database from SharePoint
3. Delete the messed up Content Database from SQL
4. Restore using the SQL UI
5. Mount the Content database into Sharepoint

Sharepoint custom ribbon buttons disappear

Custom ribbon buttons in Sharepoint will disappear if the tool bar type is anything but Full Tool bar for a Ribbon button that is provisioned to the list view

Json to C# converter

json2csharp.com/

 

This was the site that I used to convert Sharepoint TaxonomyInternalService.json calls to C# json objects. We then did an Httppost to the taxonomyinternalservice.json and used the oob JavascriptSerializer class to deserialize the result from the service.

Web Properties FTW

Programmatically updating the Search Settings for a Site Collection - Coding Times of a .Net Developer from Yard - Site Home - MSDN Blogs

Top 10 Secret Features in Windows 8

Top 10 Secret Features in Windows 8

Cant change Database Single user moce

http://remidian.com/2008/01/remove-sql-server-database-from-single-user-mode/

Versioning in word document - Sharepoint

http://stackoverflow.com/questions/508229/how-can-i-include-value-of-sharepoints-version-column-in-a-word-document

VS 2012 64 bit version

I just found out that there isn't a 64 bit version of Visual Studio ...The following is a post from 2009.

http://blogs.msdn.com/b/ricom/archive/2009/06/10/visual-studio-why-is-there-no-64-bit-version.aspx

2012 doesn't have a 64 bit version either.

Office web apps

Yesterday I installed Office web apps.The installation is just a couple of clicks of Next buttons. On finish, the installation ran fine, and launched the SharePoint Configuration wizard. After the wizard marched through its 10 steps, the final message read "Error" and pointed me to a log file. Perusing through the log file, I couldn't find anything useful. It could be because I was impatient to look for what I wanted to find. So, instead of trying to figure out the specific point of failure, I did the Ctrl+Alt+Del equivalent of Sharepoint Configuration, which is to run the configruation wizard again, without any changes to the default settings of the wizard...it worked. The I created the Word Viewing service (Sharepoint Admin=> Configuration => Manage Service Applications), the powerpoint service (excel service was already installed). Enable Office web apps feature in the site collection. Now view in browser and edit on browser options are available for word, power point and excel files. It looks nice too.

Dual boot windows 7

http://www.hanselman.com/blog/LessVirtualMoreMachineWindows7AndTheMagicOfBootToVHD.aspx