About customer
Steven DeLisle is responsible for IT Asset Management in Ludlow Mount Holly Unified Union School District.
He and his collegues monitor, maintain, and manage both physical and virtual assets that particular schools possess or rent.
The team deals with the excessive number of items of all types and has to ensure accountability and convenient representation of the inventory data.
Country
USA
Product used
Challenges faced
The team used spreadsheets to track the IT Assets and needed a solution to make the task performance faster and achieve more productivity. The offerings present on the market were cumbersome for the customers and did not match their specific needs. Besides, the product to use had to meet the K-12 school budgets.
01
Ensure efficient SQL Server database management
02
Customize the solution for the specific environment
03
Intuitive tool for users without strong database-related background
After searching on the Internet, the customer chose two Devart solutions: dbForge Studio for SQL Server and UniDAC (data access components) for Delphi. The deciding factors were flexibility of the solutions, lots of positive users’ reviews, and highly professional and helpful customer support.
"The layout of dbForge, the simplicity it gives with creating and modifying SQL Server databases and creating code are fantastic."
IT Manager
Results achieved
+50%
time efficiency
+40%
inventory management productivity
Despite having limited knowledge of database management, the customers could set dbForge for SQL Server up and running very quickly. The UniDAC solution served excellently for the custom front-end, and the features of the Studio matched the existing programs and enhanced the available functionality. These tools helped to resolve all issues that the team faced during their daily tasks in tracking inventory.
Before implementing dbForge Studio, the team had to overcome lots of difficulties because of the lack of specific programming training. The Studio with its powerful GUI lets even the non-experts perform quickly and diminish the time losses.
Key features Steven is excited about
Database diagrams
A specialized feature for ER diagram design lets the users visualize the databases with their structures and objects as diagrams.
With its help, you can check logical references, create and edit objects, and analyze the databases in-depth.
Table Designer
An object editor lets you create and edit SQL tables in a visual mode. You can create and manage columns, indexes, triggers, work with data,
as well as generate SQL scripts to apply changes.
Index Manager
The feature ensures smooth working with indexes. Users can add and remove indexes, define index types, analyze the existing indexes, identify
and fix issues with index fragmentation in a visual mode or with specifically generated SQL scripts.
Grow with Devart
Learn more about a lightweight and handy software-buying process with lots of benefits for enterprise companies!
-
Special deals for corporate clients
We have been operating since 1998. IT professional in more than 120 countries are already using our products.
-
Fast support
Our professional and friendly team is always ready to help you.
Similar stories
MCS GROUP
"A powerful tool for developing a help system with auto format support..."
dbForge Studio for SQL Server
Nordhausen University
"We found out that it is a perfect tool for us due to its simplicity, usability,
cost-effectiveness..."
dbForge Studio for SQL Server
I Computer Solutions
"When it came to daily performance, the staff became 20% more efficient and 25% more productive..."
dbForge Studio for SQL Server