The NextGen Electronic Medical Record (EMR) software uses Microsoft's MS-SQL® database as its data storage engine. ggXTech has worked with SQL databases since the late 1970's. ggXTech has worked with the NextGen EMR software's MS-SQL database which now includes almost 3000 tables for several years. ggXTech thoroughly understands the NextGen EMR software database's structure and functionality.

ggXTech frequently designs custom SQL stored procedures and user defined functions to accomplish tasks which are not possible using the standard set of NextGen EMR software development utilities and tools. ggXTech typically integrates custom stored procedures and functions into its template and report development to enhance functionality, reduce development costs and increase code maintainability. 

Some examples of ggXTech's use of custom SQL to enhance functionality and reduce development/cusomization costs include:

• populating large tables through SQL scripts (ie lab tests) eliminating the need to enter data manually 1 record at a time.
• automating the creation of hundreds of patient lab triggers eliminating the need to add them via the NextGen EMR software template editor.
• replicating triggers in bulk between templates which have similar functionality
• building new diagnoses categories content by importing an Excel spreadsheet.
• streamiling templates by eliminating large numbers of triggers to help performance and maintainability.
• returning patients' most recent lab values to reports and templates across all lab vendors including in-house labs.
• executing "gap analysis" to determine differences bewtween two versions of a template.
• querying and reporting capabilities beyond those available from a standard report writer.
• export and import of data into MS-ACCESS® databases for further analysis (ie remove load from server).
• creating custom dbPickLists driven by stored procedures to allow infinite filtering, sorting etc.
• increasing performance through the use of stored procedures.