PCA provides custom Internet database application consulting and design-build engineering services on the Microsoft business platform: SQL Server database, .NET Smart Client, SQL Reporting Services (SSRS) and SQL Analysis Services (SSAS).  Founded in 1992, PCA is a Microsoft Gold-Certified Partner, and recognized for our ability to translate unique and oftentimes complex business and operational needs into fast, reliable and easy-to-use distributed database solutions.

Custom Smart Client Solutions

We design and build custom database solutions on Microsoft Smart Client Platform.   Smart Client applications look and perform just like Microsoft Office applications — but they run over the Internet, and enable real-time, secure SQL Server database sharing.  Smart Client database applications are ideally suited for business-to-business data management needs.

Our Clients

The PCA Client base is exceptionally diverse, spanning a broad range of industries and custom applications.  Our Clients are distinguished by their unique and oftentimes complex industry and line-of-business needs — where quality, cost-controls and profitability rely heavily on the ability to share and manage large amounts of proprietary information among employees, business partners and customers.

Migrate Excel and MS Access to SQL Server and .NET

PCA is frequently engaged by companies that have developed a highly-customized Excel or MS Access application — have outgrown the capabilities these tools can provide — and need business process experts and SQL Server database and application design experts who can translate unique capabilities into a high-quality, distributed database solution.

Prototype Design Methodology

Application Prototypes are the centerpiece to PCA's custom design-build process.  Prototypes provide PCA and our Clients with a simple, visual means to communicate new application capability, layout, workflow and overall look-and-feel requirements.  The outcome of the Application Prototype Design Phase is confidence that we are on the right track, a properly scoped project with reliable budget and schedule estimates, and a Client approved design and source-code to drive the Development Phase.

SQL Server Engineering Audits

PCA provides SQL Server engineering audits to evaluate the quality and completeness of existing SQL Server systems — to identify database and application design and implementation root-cause issues that impair system performance, data integrity, security, and system maintainability.   PCA SQL Server Audits fully document design and implementation issues, and include specific remedial engineering recommendations.