Microsoft SQL Server relational database management system works behind the scenes on Small Business Server to store and process your information. Microsoft Solution Providers can customize SQL Server for you by building applications specific to your type of business. Working with these applications, Small Business Server and SQL Server can help you manage your business information.
For example, you can purchase a SQL Server application that can store employee and payroll information and allow employees to view some, but not all, of the information, depending on their job requirements. You can also store accounting and inventory information. As goods are shipped and payment is received, SQL Server records can be updated automatically.
Whether you are publishing existing company data on your intranet or building a new Internet solution, a SQL Server application can provide you with a database foundation that can quickly interpret queries and retrieve information, expand as your business and Web presence grow, and run efficiently and reliably with little management overhead.
SQL Server shares the same architecture, programming interfaces, and tools as other Microsoft BackOffice applications. Developers of solutions on BackOffice products can use these shared resources to build a database solution that you can implement quickly and easily.
SQL Server information can be accessed with Microsoft Excel, Microsoft Access, and many other popular tools from Microsoft and third-party suppliers.
If you are knowledgeable about application development, you can use Microsoft programming tools, such as Microsoft Visual Basic® and Microsoft Visual C++®, to customize SQL Server for your business needs.