HomeServicesTechnologyAnalyticsOur ClientsAbout PCAContact Us

Microsoft .NET/SQL Server Code and Systems Audit

Microsoft .NET/SQL Server systems are often comprised of a large number of inter-related and complex moving parts — table structures, referential integrity rules and constraints, indexes, stored procedures, views, user-defined functions — all required to work accurately and efficiently with .NET application-side forms, queries, 3rd-party controls, web services, and a properly configured database server.
The root-cause behind poor system performance (and other issues such as record locking, poor data integrity, high maintenance costs, etc.) can almost always be traced back to poor system design and/or code implementation deficiencies.

Why Request an Engineering Code and Systems Audit?

 
  • A critical project is behind schedule and over budget — and you need an independent expert assessment of the quality and completeness of the source code
  • You continue to struggle with ongoing system reliability and performance issues — no one involved with the project seems to have any answers, and you've lost patience
  • You are preparing for the sale of your company. Your in-house database is an important consideraton in your company valuation, and you would like an independent expert opinion on the system for any deficiencies that may underming your value.
  • You have lost confidence with your in-house programmers (or an external vendor), and you want to prepare for a transition of the project
  • You need to certify your system meets specific industry and/or regulatory compliance standards, and you'd like an independent review to identify any potential issues
  • You would like to identify any areas of your system design and/or implementation that may causing increased maintenance and support costs

Systems Audit Methodology

PCA employs a standard engineering audit check-list — in combination with many years of experience and advanced database analytics tools — to identify root-causes behind poor system performance, reliability, data integrity, security, and maintenance cost issues. Our Engineering Audit team will document our findings, and make specific remedial engineering recommendations to improve the quality and maintainability of your Microsoft.NET/ SQL Server system.
PCA expert SQL engineering professionals employ a standard check-list of SQL Server design and implementation methods — in combination with many years of experience and advanced database analytics tools — to identify root-cause issues behind poor SQL database performance, reliability, data integrity, security, and overall maintainability of the system.

Documented Audit Findings and Recommendations

PCA SQL Audits are fully documented.   Clients deliverables include a high-level management overview that describes the audit scope, summary findings and key recommendations, and source engineering audit details including specific observations, area(s) of impact, severity, and remedial engineering recommendations (with examples).

PCA Audit Essentials

Time Frame
  • 4 weeks to 10 weeks, depending upon system scope and complexity
Deliverables
  • Documented Engineering Audit Findings and Recommendations
  • Detailed Remedial Engineering Examples
  • Audit Findings Review Sessions (GoToMeeting)