TrustRadius: an HG Insights company

ApexSQL by Quest

Score8.5 out of 10

10 Reviews and Ratings

Get a Demo

What is ApexSQL by Quest?

ApexSQL is a software development company headquartered in Chapel Hill, US, and a Quest company. The company specializes in developing professional software tools for Microsoft SQL Server including tools for database auditing, recovery, change management, development, and documentation. ApexSQL is a Microsoft Gold Certified Partner.

Categories & Use Cases

Reviews

What users are saying about ApexSQL by Quest.
View all reviews

Making things easy with ApexSQL

Incentivized
John RamírezView profile
Database Administrator in Information Technology at System Crew GmbH (11-50 employees employees)

Use Cases and Deployment Scope

As a Database Administrator, I am in the need to write and mantain queries and scripts. Having this tool, has made my life easier, because I just need to type a few letters and I can have a whole script template ready, just worrying for what is important for my job. Also, there are a lot of tips and useful tools, making my job easier.

Pros

  • Templates
  • Code editing
  • Code Review

Cons

  • Can be slow on dataloading
  • A few times has crashed, with no reason

Return on Investment

  • Decrease on the work time
  • Productivity increase
  • Training flexibility

Alternatives Considered

IDERA SQL Admin Toolset

Other Software Used

Microsoft SQL Server, Microsoft Power BI

Must have profession tool for SQL Server

Incentivized
Mohammad AnasView profile
Application Development Analyst in Information Technology at Accenture (1001-5000 employees employees)

Use Cases and Deployment Scope

There is increased in demand of Devops implementation and requirement of data privacy, security in our organization. ApexSQL by Quest is an amazing tool that helps DBAs in managing more complex databases in cloud and hybrid environment while protecting personal and sensitive data of organization. ApexSQL enables both DBAs and developers to increase their efficiency while managing the databases.

Pros

  • Disaster Recovery of database
  • Management of Agent Jobs in Sql sever
  • Backup and restoration of databases

Cons

  • Compare and sync feature need improvement
  • Automation can be improved
  • Connection of various database at same time

Return on Investment

  • Positive impact in terms of maintaining the privacy of organization data
  • Positive impact in terms of increasing the efficiency of working on complex databases
  • Positive impact in terms of good integration between visual studio and SSMS

Alternatives Considered

PostgreSQL

Other Software Used

PostgreSQL, Oracle Database, MySQL

Great set of SQL server and DBA tool

Incentivized
Verified User
Strategist in Finance and Accounting (51-200 employees employees)

Use Cases and Deployment Scope

We work with big ecommerce company like Purplle.com, Myntra, Snapdeal for improving their performance by running sponsored ads on their platform so here to achieve the goal Apexsql helps a lot like Apexsql determines object internal relationship within the database and it helps me to speed up coding by automatically completing SQL code statement and also keeps track of all executed query and tabs which we can easily search through query results,exports query results.
It has Create CRUD procedures feature that automatically create select,insert,update and delete stored procedure using customisable templates.
When we execute the SQL code,the execution alerts feature analyzes the SQL code against a defined set of rules with ability to block query execution and produce a warning message.
If we have a lot of opened query tabs so here ApexSQL provide tabs coloring feature.

I will recommend all of you to use ApexSQL

Pros

  • Tab coloring
  • Execution alerts
  • Create CRUD procedures
  • Automatic Tab renaming
  • Tab navigation
  • Export into Excel

Cons

  • Need to improve on optimization sometimes it take too much time during data loading and unloading
  • The IDE comes in web browser.It should develop its own IDE to write code
  • I don't particularly appreciate that there is no way to get all data for any records

Return on Investment

  • Free to use so easily affordable
  • Very easy to use of any new employee can easily learn
  • It provides all encompassing tool for our developers and ApexSQL solves that

Alternatives Considered

PostgreSQL and MySQL

Other Software Used

MySQL, PostgreSQL, Microsoft SQL Server

ApexSQL by Quest - Excellent toolset that makes working with SQL databases more efficient

Incentivized
Verified User
Engineer in Research & Development (10,001+ employees employees)

Use Cases and Deployment Scope

ApexSQL has been used by the organization to help manage MS SQL Server and automate some tasks that had been done manually by developers in the past. We mainly used it to try to streamline our devOps pipeline and use it to handle some of the auditing and monitoring tasks that had previously been done by devs or by our devops partners.

Pros

  • Pretty scalable and relatively straight-forward to deploy
  • Useful tools that speed up table comparisons and auditing
  • Able to create a customized pipeline and run it through a dashboard

Cons

  • Source control can be a bit difficult with large database tables
  • Many tools so can be complex for new developers to onboard and use efficiently

Return on Investment

  • Reduced the time needed to maintain and audit our MS SQL databases
  • Automation reduced the time and effort needed to execute on daily tasks
  • Increased efficiency overall by making data comparisons and other day to day tasks more efficient

Alternatives Considered

PostgreSQL and Microsoft SQL Server

Other Software Used

Microsoft SQL Server, Microsoft Azure