Posts

Showing posts with the label Tip

Enabling/ Disabling Developer Dashboard in SharePoint 2010

Developer dashboard is not only for Developers, the administrators can also take good advantage of it. They can do quantitative analysis if their site is slow then how much slow and when the users started raising complaints. There are three in which this DD can remain: 1. OFF (which is by default) 2. ON - which turns it on all the time. It is generally not a good option as it causes performance overhead and turning it on would make all the Site Collection Admins to see it. 3. On Demand – It appears like a small button and site collection admins can turn it on any time they want. This is most feasible option. To set it to OnDemand, execute following powershell cmdlets: $dd = [Microsoft.SharePoint.Administration.SPWebService]::ContentService.DeveloperDashboardSettings $dd.DisplayLevel = ‘OnDemand’ $dd.TraceEnabled = $true $dd.Update() This is enabled on the whole farm so you can go and look the the Right-Top of the site where a white colored button should appear. Upon clicking...

SharePoint 2010 Error Log Viewer

Perhaps I posted this before, but if not, I am posting again for my reference. Use this tool to view SharePoint 2010 Error Logs: http://code.msdn.microsoft.com/ULSViewer/Release/ProjectReleases.aspx?ReleaseId=3308 SharePoint 2010 Log files are usually located here, sort by date and open the latest one in the ULS Viewer: C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\LOGS Create a “Filter” and select “Message” and enter “Error” in value. This should give you all error entries in the file and you can find out what is wrong.

SharePoint 2010 - Upgrade License from Trial

Go to Central Administration>Upgrade and Migration>Convert License Type> check the current license under Current License. Enter new key to upgrade to new license type.

Find Column in Database - SQL Server

Use the following query to find column in your database. Change “yourdbname” and “%ColumnNameToSearch%” column name accordingly. Use yourdbname GO SELECT t.name AS table_name, SCHEMA_NAME(schema_id) AS schema_name, c.name AS column_name FROM sys.tables AS t INNER JOIN sys.columns c ON t.OBJECT_ID = c.OBJECT_ID WHERE c.name LIKE '%ColumnNameToSearch%' ORDER BY schema_name, table_name; Thanks to Pinaldave .

Enable Debugging in the VSeWSS with Visual Studio 2008 and MOSS 2007

Go to the application you are deploying your feature to, and open web.config and make following changes in the given sections (CustomeErrors, compilation and SafeMode sections are already there): <customErrors mode="Off" /> <compilation debug="true"… <SafeMode CallStack="true"… Now press F5 and it should start debugging your projects/features/solutions created with VSeWSS.

VSEWSS - The HTTP request is unauthorized with client authentication scheme 'Negotiate'. The authentication header received from the server was 'Negotiate,NTLM'."

I faced this issue after installing VSeWSS (Visual Studio Extensions for Windows SharePoint Services) V1.3. O/S was Windows Server 2003 SP2 and I was trying to package my solution for SharePoint in Visual Studio 2008 when it kept failing by giving following errors: “The HTTP request is unauthorized with client authentication scheme 'Negotiate'. The authentication header received from the server was 'Negotiate,NTLM'."" and (at times when I was trying different things) the following error: “The HTTP request is unauthorized with client authentication scheme 'Negotiate'. The authentication header received from the server was 'Negotiate,NTLM'.” Do the following to resolve, go to (try after each step in order): 0. If you are using domain account, make sure you are connected to that domain otherwise user (against which the VSeWSS site application pool is running) will not be able to authenticate. 1. Follow this article and make sure IIS en...

Windows Service Management for Better Performance! OR Call it Memory Management

During development, its quite common to find out that SQL Server has eaten up all your RAM and other processes also keep ballooning. I tried simplest workaround for that and it worked well. Just write a couple of batch files to stop the services. You add/remove services as per your liking. Here is an example file that I sometime use when I am working on Microsoft Project, Microsoft Visio or have to run Virtual Machine (VM) or when I am not in the “coding mode”: File1: StopServicesToRunVM.bat net stop "SQL Full-text Filter Daemon Launcher (MSSQLSERVER)" net stop "SQL Server (MSSQLSERVER)" net stop "SQL Server Agent (MSSQLSERVER)" net stop "SQL Server Analysis Services (MSSQLSERVER)" net stop "SQL Server Browser" net stop "SQL Server Integration Services 10.0" net stop "SQL Server Reporting Services (MSSQLSERVER)" net stop "SQL Server VSS Writer" net stop "SharePoint 2010 Adm...