This Is Our Old Site
Interprise Solutions
This website is powered by Interprise Suite eCommerce
 SQL Client / Server

SQL Client / Server technology is considered the best technology for business applications. More scalable, reliable and robust than standard database technology (FoxPro, Access, etc.) SQL Client / Server technology has always been very expensive - until now.

Interprise Suite is a Client / Server application optimized for Microsoft SQL server technology (SQL Server 2005 & SQL Express) and is divided in two parts - a "client application" and a "server application". The client application is installed on each users workstation while the server portion is installed on the server. Unlike many "client/server" applications, the server portion of Interprise Suite utilizes SQL stored procedures for its data processing. Since all data processing activities are safely processed on the server performance and scalability is increased, network traffic is reduced, and data corruption is eliminated.

It is also worthy to note that the "data access layer" of Interprise Suite is located on the server and not the client like some applications. Since the data access layer is responsible for all communications between the client application and SQL server this is important. In Interprise Suite data passed between the client and the server can be encrypted for security or compressed making it up to 20 times faster when requesting large amounts of data. 
 

  Microsoft SQL Server 2005 Express Information

In 2005 Microsoft SQL Server 2005 Express edition replaced the MSDE. A completely free database engine based on Microsoft SQL Server 2005, the Microsoft SQL Server 2005 Express edition is an idea choice for small companies looking for a high performance database.  Compared to SQL Server 2005 limitations of the Express edition include:

  • Lack of enterprise features support
  • Limited to one CPU
  • One GB memory limit for the buffer pool
  • Databases have a 4GB maximum size

SQL Server 2005 Express Edition Features
SQL Server 2005 Express Edition DataSheet (.pdf format) 
SQL Server 2005 Express Edition Overview

 Microsoft SQL Server 2005 Information

Microsoft's next generation database is coming in mid 2005 and will have enhanced features only available to .NET applications.

  • More Scalable
  • More Secure
  • Enhanced Interoperability
  • Enhanced management tools
Introducing Microsoft SQL Server 2005
Features at a Glance
Security in SQL Server 2005
   © 2010 Interprise Software Systems International Inc.