About the customer
Dan Price is an experienced Business Intelligence and Data Warehouse practitioner who has been implementing
Business Analytics solutions in a number of industries for many years. In particular, he focuses on telecommunications,
financial services, and education sectors, specializing in the Microsoft BI Stack, but also having a profound experience in other technologies.
Country
Australia
Product used
Challenges faced
As an independent contractor, Mr. Price was working on a BI solution for a company operating in the travel industry. The main challenge he faced was the limited functionality of the solution used for SQL development.
01
Inconsistent layout and format of code
02
Low speed of code writing
03
Risks of using the wrong server
Neither the default SSMS nor other third-party tools could solve those challenges. On the recommendation of his colleague, Mr. Price turned to the dbForge product line for SQL Server and chose SQL Complete to overcome all the challenges. The tool appeared to be more feature-rich, with responsive support and more frequent updates delivering functionality enhancements.
"I can build new analytical capabilities and maintain the existing ones faster."
Senior BI Developer
Results achieved
+70%
coding efficiency
Mr. Price uses SQL Complete in day-to-day development routines, such as creating various database objects, report queries, etc. The primary advantage that this tool brought was the improvement of coding speed. With the functionality provided by SQL Complete, any coding tasks became easier and faster in production. The overall coding efficiency has increased significantly.
Key features Dan is excited about
IntelliSense-style SQL autocompletion
SQL Complete provides an autocomplete feature that is more powerful than its analogs in SSMS and other third-party tools.
The context-based suggestions, statement expansions, object search, and simple code navigation make the coding routines almost twice as fast.
T-SQL Debugger
This feature is a great support when writing complex stored routines. It allows developers to analyze and troubleshoot stored procedures,
functions, and triggers. Developers can perform all operations in the familiar SSMS interface enhanced with SQL Complete.
Tab coloring
This option is helpful when working with multiple server connections, and when it is essential to execute the statements
against the correct environment. Developers can mark the servers related to development, test, sandbox, and production by color
and thus eliminate the risk of working with the wrong server.
Get extra benefits with Devart for Enterprise
Grow your business with Devart - become our Enterprise client and get a customized package of MySQL 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
Contract Resources (NZ) Ltd
"The environment missing SQL Complete feels far less polished. SQL Complete completes SSMS."
dbForge SQL Complete
Speech Technology Center
"dbForge Studio for SQL Server turned out to be the most efficient and cost-effective toolbox..."
dbForge Studio for SQL Server
GoodSoftware.com, LLC
"We just wanted the easy way to do things. You've provided us with a reliable tool that we depend on daily."
dbForge SQL Tools