HomeServicesTechnologyAnalyticsOur ClientsAbout PCAContact Us

Microsoft SQL Server Internet Database

PCA specializes in building applications interfaces connected to SQL Server databases over the Internet, so employees, partners and customers can share and update 'privileged-based' information in real-time, anywhere with Internet access.

ASP.Net vs. Smart Client applications

If you need to publish structured information to various web pages, where End Users are limited to read-only access, then ASP.NET pages is a great approach.  If however you need to enable a frequent, two-way "high-fidelity connection" among End Users — where everyone modifies certain areas of the data, adds new records, or if you need to support a more complex business work-flow, then a Microsoft Smart Client application connected to a SQL Server database is a better-suited, more cost-effective approach.
There are also circumstances (and needs) for pure browser-based ASP.NET applications.  The most common reason we encounter is some businesses simply cannot dictate that all End Users install an application on their PC.  In addition, sometimes a rich, highly-interactive End User experience is not needed.

Hybrid ASP.Net / Smart Client applications

While Smart Clients have clear advantages in terms of advanced capabilities, ease-of-use, and lower costs to design and develop, under these scenarios PCA frequently develops "hybrid applications" that deliver the capabilities and benefits of both Smart Client and browser-based (ASP.NET) approaches.  Typically, the Smart Client application is used by employees to create and maintain the database records, and to manage all the application administrative functions, and the resulting database records and reports are made available to customers via an ASP.NET browser interface.
PCA frequently builds "hybrid" solutions for Clients that include both Microsoft Smart Client application and ASP.NET webpage components. Typically, employees use the Smart Client application to manage the data, and customers access the data via ASP.NET pages inside a web browser. ASP.NET page capabilities can include access to reports that are canned and generated on-the-fly, and filters and queries directly from the SQL Server database.

SQL Server Database Replication and Synchronization

In our experience, data replication and synchronization methods available within MS SQL Server can be a significant technical challenge.  The method you choose to replicate and synchronize SQL Server data can (and will!) directly impact application performance and business data integrity.  There are several proven approaches to distributing and updating database-driven content, and the ideal approach can depend upon several factors: end user access restrictions, workflow considerations, database schema complexity, update cycle, media types, size of the database, and more. The process of how you need to distribute information to remote users, and flow reliable data back and forth forces key early design decisions.

Choosing the Best Approach

Any wrong turn with key design considerations can (and will!) produce results that are both painful and expensive, and likely fall short of meeting your business objectives. All too frequently, businesses call PCA because they took a wrong turn with the database configuration and design, and are now experiencing lost data, slow performance, or the database itself becomes corrupt.
PCA offers a number of time-tested distributed web database applications techniques that can address a broad range of functional and budget requirements.  We know how to create robust, web database applications directly from your MS SQL Server database that actually perform FASTER and are EASIER TO USE over the Internet, than most MS SQL Server applications running on a local area network (LAN)!