In a recent article, we announced that Sage 100 Contractor now runs on Microsoft SQL Server. But we know that some of you might be saying “What is SQL Server and why should I care?”
In this article, we’ll take a closer look at this industry-standard database technology and discuss what it means for the construction industry and Sage 100 Contractor.
What Is Microsoft SQL Server?
First things first. SQL (or “sequel”) stands for Structured Query Language.
It’s a programming language and the term is often used to describe a database system. Many modern software applications that process large amounts of complex data use SQL to sort, retrieve, and update information in the system—including Microsoft SQL Server which has been the industry standard database for a very long time now.
Scalability is Key
One of the key strengths of SQL Server is support for databases up to one terabyte in size (that’s huge!). Without getting into all the technical details, SQL Server is structured in such a way that as your company grows, the database will seamlessly absorb increased transaction workloads and data processing tasks without a significant drop in performance.
That means no matter how much data, history, jobs, or transactions you manage in Sage 100 Contractor, it will perform just as fast and efficient as it did when you first started using the software.
Extensive Security Features
Another key feature of Microsoft SQL Server is that it gives companies more extensive security options for protecting your data and preventing file corruption. Database administrators can limit user access to data at a very detailed level, as well as determine whether they can add to, modify, or retrieve information in the database – all of which helps prevent unauthorized access. You also have a complete audit trail so you know who changed what, and when.
SQL Server is highly reliable, touting a documented uptime of 99.9999% according to some studies (depending on your server and hardware). In addition, SQL Server databases can be backed up, either incrementally or completely, while the database is in use. Users do not have to exit the database before the system administrator performs routine maintenance.
In case of system failure, such as an operating system crash or power outage, SQL Server has an automatic recovery mechanism that recovers a database to the last state of consistency in a matter of minutes, with no database administrator intervention.
In short, Sage 100 Contractor will almost never crash based on a database issue. And your employees will never have to stop what they are doing and log out of the system when you need create a backup.
Deeper Reporting and Analysis
Using SQL Server helps you get more use and insight out of the data and transactions you collect in Sage 100 Contractor. Not only are the standard system reports faster and more flexible, companies with knowledge of the SQL Server environment can tap directly into the database to create sophisticated charts and other visual supplements. SQL Server also provides an interactive data exploration, visualization, and presentation experience along with intuitive ad-hoc reporting.
Sage 100 Contractor is now part of the Microsoft SQL Server family. What that means to you as a customer of Sage 100 Contractor is that your construction software is now faster, more reliable, and more secure than ever before.
The Nitty Gritty Details
Understanding SQL Server
Leave your name below and we’ll send you a copy of Improve System Performance and Data Security with SQL Server.
This free white paper discusses the details of how SQL Server works and the key advantages to construction companies and contractors.