How Dan Price improved coding speed and accuracy with
dbForge SQL Complete

Dan Price

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 existing ones faster."
Dan Price
Senior BI Developer

Results achieved

Coding efficiency improved by 70%

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 Price 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.

Tabs 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.

dbForge SQL Complete

Advanced IntelliSense-style code completion add-in

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.