Archive for the ‘SharePoint 2007’ Category

Building a Common Approach to Grants Management

January 4, 2011 Leave a comment

Summary of what I’ve been working on for the last year.

Project Overview


The purpose of this project was to create a common grants management system for the North Carolina Department of Crime Control & Public Safety (CCPS) to maximize the use of federal grant funds to projects related to law enforcement, victim of crime services, emergency response and Homeland Security efforts. Initiation focus was given to the Governor’s Crime Commission Division (GCC) to administer all phases of their federal block grant programs that bring approximately $50,000,000.00 into the state’s criminal justice and juvenile justice system. The previous grant system was inefficient and labor intensive. Fiscal data preparations were performed in local access database files, excel spreadsheets, hand written notes and emails and then eventually manually entered into the central accounting mainframe. This labor intensive process creates multiple copies of the same data leading to duplication of work throughout the process. This also resulted in limited perspectives of grant information causing errors in grant awards: potential over-allocation of grant funds; larger than authorized check amounts written to subgrantees; under-utilized grant funding forcing money to be returned to the Federal Government along with under-utilized interest baring accounts limiting opportunities to extend grant funding to North Carolina criminal justice and juvenile justice systems.


Provide a single entry point and approach for all organizations requesting grant funding from all CCPS grant programs that have different grant application processes while ensuring fiscal management of funds are fully utilized and completely compliant with all federal auditing regulations.


The project provided a Microsoft SharePoint 2010 website for organizations requesting grant funding. This data is fed into a Microsoft CRM 4.0 solution that is tailored for each grant program. Once a grant project is awarded from any of the grant programs, the fiscal data is sent to a common Microsoft GP 10.0 solution. The fiscal solution provides accounts payable activities to be performed using a common fiscal focused software solution – minimizing training and maximizing common use of the tool. The system then automatically sends approved budget and check writing request information to the State’s Accounting Mainframe system eliminating the need for manually data entry. All interfaces between these system are managed by SCRIBE Insight software.

The implementation of a common fiscal grant management system will ensure all fiscal roles will be able to utilize information without the need to duplicate data entry or drive fiscal grant management workflow based on personnel rather than fiscal process.

Social Benefit

It provides management the ability to ensure maximum utilization of grant funds. The more programs that can be simultaneously supported throughout the state will help reduce crime, improve crime victim services, allow for better response to an emergency and solidify our state homeland security strategy.



GEMS SharePoint Home Page


GEMS CRM 4.0 Solution




GEMS Microsoft GP

Office SharePoint Server for Internet Sites Licensing

December 24, 2010 Leave a comment

This posting was very important regarding how to properly budget for a MOSS roll-out.

Office SharePoint Server for Internet Sites Licensing


Given this topology, here are the licensing requirements:

  1. Every server requires Windows 2003 Standard Edition or greater.
    You don’t need Enterprise unless your machines have 8 processors. Included are 5 user or device CALs which will be sufficient.
  2. All three MOSS servers require MOSS for Internet Sites.
    Whilst you are able to mix editions within a farm, for this scenario it doesn’t make sense for the Index server to use the Enterprise License + CALs as it’s data is being accessed by the external users (via the WFEs).
  3. Your SQL Servers require SQL Server 2005 Standard Edition per Processor.
    We don’t need SQL Enterprise unless we are doing advanced management. Per Processor licensing is the only option here as we don’t know the number of users. From a licensing perspective, it doesn’t matter if we’re using clustering or mirroring or something else for resilience here. However if you are running an active-passive cluster you only need the licenses for the processors on your active node. If you are doing clustering you require Enterprise Edition of Windows Server. Thanks to Tadas Aukstakalnis.
  4. Every box requires the Windows External Connector.
    Yes, every box needs it. Whilst you may think neither SQL or the Index Server are on the Internet, they still need the external connector as their data is accessed over the Internet.

US Retail List Pricing (23rd May 2008)



unit cost



MOSS (2xWFE, 1xIndex)






Windows External Connector




Windows 2003 R2 Standard





SQL (2 node cluster, 2x CPU each)


SQL Server 2005 Standard CPU*




Windows External Connector




Windows 2003 R2 Standard







Categories: SharePoint 2007 Tags: