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
suited for business-to-business data management
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
application — have outgrown the capabilities these tools can provide
— and need business process experts and
database and application design experts who can translate unique capabilities into a high-quality, distributed database
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
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
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,
specific remedial engineering recommendations.