Check for TempDB PAGELATCH waits

SELECT

session_id,

wait_type,

wait_duration_ms,

blocking_session_id,

resource_description,

ResourceType = CASE

WHEN PageID = 1 OR PageID % 8088 = 0 THEN 'Is PFS Page'

WHEN PageID = 2 OR PageID % 511232 = 0 THEN 'Is GAM Page'

WHEN PageID = 3 OR (PageID - 1) % 511232 = 0 THEN 'Is SGAM Page'

ELSE 'Is Not PFS, GAM, or SGAM page'

END

FROM ( SELECT

session_id,

wait_type,

wait_duration_ms,

blocking_session_id,

resource_description,

CAST(RIGHT(resource_description, LEN(resource_description)

- CHARINDEX(':', resource_description, 3)) AS INT) AS PageID

FROM sys.dm_os_waiting_tasks

WHERE wait_type LIKE 'PAGE%LATCH_%'

AND resource_description LIKE '2:%') AS tab;

This Web Part requires at least Microsoft Internet Explorer 7.0

After installing internet explorer 10, PWA broke with this error message

This Web Part requires at least Microsoft Internet Explorer 7.0. For more information, contact your Project Server Administrator.

Adding the website to the compatibility view list solves the problem. Tools -> Compatibility view settings

 

Configuring OpenVas on BackTrack 5 R3

BackTrack is a pentest linux distribution, download live cd from here, it contains the open source security scanner OpenVAS.
Below are the configuration steps required after booting BackTrack 5 R3 to get OpenVAS running.

ERROR: The number of NVTs in the OpenVAS Manager database is too low

I was setting up OpenVas on BackTrack 5 R3 and got stuck at his error.

ERROR: The number of NVTs in the OpenVAS Manager database is too low

SCOM ACS User Logon Report

This is a report I created for the Audit Collection Services of System Center Operations Manager that lists all successful user logons details in all servers.

SharePoint Project Sites appear in the navigation menu

After I edited the navigation menu in Microsoft Project Server 2010, I found new links to all the project sites.

To solve the problem I had to delete them manually from the Quick Launch page.
Since the SharePoint Publishing feature is enabled, Quick Launch link will be replaced by Navigation, access it from the url /_layouts/quiklnch.aspx

Configure HTTPS on IIS 7 and SharePoint 2010

This post is about configuring https on SharePoint 2010 web application running on multiple load balanced IIS 7 web servers.
Assuming you already have a digital certificate, follow the coming steps. If you do not have a certificate, you can either purchase or create a self signed certificate but in that case you will receive a warning in the browser when opening the website.