• Slow Performance for Reporting (Publish) Jobs

    We had a scenario where five particular Project Schedules were taking 8 minutes to finish publishing to the Reporting DB, but the Draft and Published database jobs were finishing in less than a minute. All other 200 schedules in the system would publish...
  • Add AD group to all PWA project sites with Read Only permission using PowerShell

    My customer wanted to be able to provide his Portfolio Managers with read only access to all project sites in PWA. Because an AD group for Portfolio Managers already exists, we can use that AD group in the script and add it to all project sites under...