Finding a GUID needle in a pile of database haystacks

Date: 1/28/2006

Our client was providing consulting and training services as well as custom integration for a poorly-documented database application, which used GUIDs to map nearly every data type. "Trying to find relationships between tables was a monumental task," according to Christopher Shipley, one of the company's principal officers. We provided them with a query tool to locate all tables and columns with a specific GUID, thus helping to map out the data relationships. This application saved countless hours of manually sifting and searching through the database to look for the proverbial needle in the haystack.

Customer: Nutmeg Consulting, LLC

Since its founding in 2003, Nutmeg Consulting, LLC has specialized in providing high quality Information Technology (IT) and Project Management services and products targeted at small business and the non-profit sector. From the beginning, we differentiated ourselves from other companies by offering a combination of private and public sector experiences, using proven methodologies for planning and implementation. We provide the skill and knowledge every organization requires – regardless of your size.

Location: Hartford, CT

Website: http://www.nutmegit.com

Contact: Chris Shipley

Email: Zbqry.Cebwrpg.Phfgbzre.Rznvy