About the customer
Zepf Center is a Trauma Certified non-profit that provides behavioral health and vocational services to individuals with severe and persistent mental illnesses. The organization's services include crisis care, addiction treatment, child and adolescent psychiatric, medical, residential, primary care and therapy services, as well as career development.
200+
qualified employees
337+
associated members
50
years of experience
Country
USA
Product used
Challenges faced
Peter Hoffman, a Database Architect on the Health Information Technology team, was working on complex business intelligence, reporting, and integration solutions using Microsoft SQL Server. However, the team encountered numerous bottlenecks in the routine aspects of SQL development, such as:
01
Identifying table structures while writing T-SQL code
02
Maintaining code formatting standards across the team
03
Managing the excessive workload of code reviews
Neither SQL Server Management Studio (SSMS) nor several other tools they tried managed to cope with these challenges. After extensive research, Peter Hoffman decided to assume dbForge SQL Complete, a powerful coding assistant that seamlessly integrates with SSMS and brings plenty of new options into the habitual interface. Its simplicity and perfect alignment with the team's needs made it the ideal choice for Zepf Center.
"SQL Complete allows our BI team to streamline tedious or repetitive tasks so they can focus on creative development..."
Database Architect
Results achieved
The team relied on SQL Complete for all their SQL development tasks. This tool enabled the BI specialists to streamline repetitive tasks and allocate more time to development. The use of code snippets helped them create standardized templates for BI structures, while shared code formatting eliminated a significant bottleneck in code review procedures.
By adopting SQL Complete, the team significantly improved their reporting capabilities, helping them deliver compelling reports in no time. As a result, the organization was better equipped to make informed decisions and attract greater access grants and other programs, ultimately expanding its services to reach more people.
Key features Peter is excited about
Code snippets
SQL snippets are commonly used code fragments that can be inserted during typing. This feature simplifies reusing code fragments and makes it more comfortable. SQL Complete offers a collection of default code templates for selection. It also supports the customization of existing templates and the creation of new code snippets to meet the specific user's needs.
Context-aware code completion
SQL Complete dynamically analyzes code and suggests the most relevant keywords and phrases based on the context. It automatically presents database objects and filters them according to the user's input. Additionally, it offers extensive prompts for T-SQL code, DDL, and security statements. These options are readily available during code writing, enabling the user to insert them instantly and thus accelerate the coding process and enhance accuracy.
Grid aggregates
The grid aggregates feature in SQL Complete automatically calculates and displays aggregates for a selected range of values at the bottom of the SSMS Results Grid. It covers MAX, MIN, AVG, SUM, COUNT, and DISTINCT ON, eliminating the need for separate calculations. Users can conveniently copy any value from the Aggregate Panel to use it further.
Get extra benefits with Devart for Enterprise
Grow your business with Devart - become our Enterprise client and get a customized package of SQL Server development and management software, tailored to your business needs and demands.
-
Bonuses for corporate clients
These may include fast and effective deployment, corporate budget optimization, and a number of special deals.
-
Dedicated manager
We will save your time by providing a dedicated manager to consult you and guide you through all the purchasing and licensing processes.
Similar stories
More success stories
Floor & Decor
"Its features are robust and useful... Impressed with how much faster, more efficient, and to the point I am."
dbForge SQL Complete
Ludlow Mount Holly Unified Union School District
"...the simplicity it gives with creating and modifying databases and creating code are fantastic..."
dbForge Studio for SQL Server
Contract Resources (NZ) Ltd
"The environment missing SQL Complete feels far less polished. SQL Complete completes SSMS."
dbForge SQL Complete