The New Features in Aqua Data Studio Improve its Functionality

by Jul 12, 2021

Categories

Tags

Administration agent-based monitoring Agentless Monitoring alert responses alert thresholds alerting Alerts Amazon Aurora Amazon EC2 Amazon RDS Amazon RDS / Aurora Amazon RDS for SQL Server Amazon Redshift Amazon S3 Amazon Web Services (AWS) Analytics application monitoring Aqua Data Studio automation availability Azure Azure SQL Database azure sql managed instance Azure VM backup Backup and recovery backup and restore backup compression backup status Backup Strategy backups big data Blocking bug fixes business architecture business data objects business intelligence business process modeling business process models capacity planning change management cloud cloud database cloud database monitoring cloud infrastructure cloud migration cloud providers Cloud Readiness Cloud Services cloud storage cloud virtual machine cloud VM clusters code completion collaboration compliance compliance audit compliance audits compliance manager compliance reporting conference configuration connect to database cpu Cross Platform custom counters Custom Views customer survey customer testimonials Dark Theme dashboards data analysis Data Analytics data architect data architecture data breaches Data Collector data governance data lakes data lineage data management data model data modeler data modeling data models data privacy data protection data security data security measures data sources data visualization data warehouse database database administration database administrator database automation database backup database backups database capacity database changes database community database connection database design database developer database developers database development database diversity Database Engine Tuning Advisor database fragmentation database GUI database IDE database indexes database inventory management database locks database management database migration database monitoring database navigation database optimization database performance Database Permissions database platforms database profiling database queries database recovery database replication database restore database schema database security database support database synchronization database tools database transactions database tuning database-as-a-service databases DB Change Manager DB Optimizer DB PowerStudio DB2 DBA DBaaS DBArtisan dBase DBMS DDL Debugging defragmentation Demo diagnostic manager diagnostics dimensional modeling disaster recovery Download drills embedded database Encryption End-user Experience entity-relationship model ER/Studio ER/Studio Data Architect ER/Studio Enterprise Team Edition events execution plans free tools galera cluster GDPR Getting Started Git GitHub Google Cloud Hadoop Healthcare high availability HIPAA Hive hybrid clouds Hyper-V IDERA IDERA ACE Index Analyzer index optimization infrastructure as a service (IaaS) infrastructure monitoring installation Integrated Development Environment interbase Inventory Manager IT infrastructure Java JD Edwards JSON licensing load test load testing logical data model macOS macros managed cloud database managed cloud databases MariaDB memory memorystorage memoryusage metadata metric baselines metric thresholds Microsoft Azure Microsoft Azure SQL Database Microsoft PowerShell Microsoft SQL Server Microsoft Windows MongoDB monitoring Monitoring Tools Monyog multiple platforms MySQL news newsletter NoSQL Notifications odbc optimization Oracle PeopleSoft performance Performance Dashboards performance metrics performance monitoring performance schema performance tuning personally identifiable information physical data model Platform platform as a service (PaaS) PostgreSQL Precise Precise for Databases Precise for Oracle Precise for SQL Server Precise Management Database (PMDB) product updates Project Migration public clouds Query Analyzer query builder query monitor query optimization query performance Query Store query tool query tuning query-level waits Rapid SQL rdbms real time monitoring Real User Monitoring recovery regulations relational databases Releases Reporting Reports repository Restore reverse engineering Roadmap sample SAP Scalability Security Policy Security Practices server monitoring Server performance server-level waits Service Level Agreement SkySQL slow query SNMP snowflake source control SQL SQL Admin Toolset SQL CM SQL code SQL coding SQL Compliance Manager SQL Defrag Manager sql development SQL Diagnostic Manager SQL Diagnostic Manager for MySQL SQL Diagnostic Manager for SQL Server SQL Diagnostic Manager Pro SQL DM SQL Doctor SQL Enterprise Job Manager SQl IM SQL Inventory Manager SQL Management Suite SQL Monitoring SQL Performance SQL Quality SQL query SQL Query Tuner SQL Safe Backup SQL script SQL Secure SQL Security Suite SQL Server sql server alert SQL Server Migration SQL Server Performance SQL Server Recommendations SQL Server Security SQL statement history SQL tuning SQL Virtual Database sqlmemory sqlserver SQLyog Storage Storage Performance structured data Subversion Support tempdb tempdb data temporal data Tips and Tricks troubleshooting universal data models universal mapping unstructured data Uptime Infrastructure Monitor user experience user permissions Virtual Machine (VM) web services webinar What-if analysis WindowsPowerShell

The release of version 22.0 of Aqua Data Studio continues the pattern of steadily enhancing the scope and functionality of the application. 

The Aqua Data Studio development team makes it a point to update the product regularly, ensuring organizations have the best and latest functionality readily available. This includes ensuring operating system updates do not cause issues so users can continue to enjoy the product without having to run an outdated and potentially unsecured OS. 

The team is always looking to improve the current feature set and add more functionality to their application. This way, they can meet the needs of the current and prospective user base. The Aqua Data Studio team understands that failure to update and improve an application will often lead to the program losing favor with users and ending up on the Island of Stale Apps. Software developers don’t want to see their creations end up there.

What is Aqua Data Studio?

Aqua Data Studio offers database developers and administrators a comprehensive integrated development environment (IDE) designed to streamline a variety of tasks associated with those technical roles.

It presents users with a unified interface from which they can access and interact with over 40 different database platforms resulting in a decreased learning curve and greater team productivity.

Once connected to the database of their choice, users can perform many of the activities required to manage the systems and their underlying queries, develop new SQL code, and analyze data to uncover hidden insights.

Teams can create a wide array of visualizations that make their data accessible to both technical and business audiences. Customized dashboards can easily be built using the drag and drop capabilities of the tool’s interface. 

Code development is facilitated by the tool’s Visual Query Builder and advanced Query Analyzer. SQL scripts can be debugged and version control ensures that teams are always on the same page when developing code for their databases and applications.

Database administrators (DBAs) can perform tasks such as comparing and syncing schemas as well as managing database objects. Aqua Data Studio is a valuable addition to a database team’s software toolbox.

What’s New in Aqua Data Studio Version 22.0

Following are some highlights from this newest version of this versatile tool:

  • SingleStore (previously known as MemSQL) is now a supported platform accessible through Aqua Data Studio’s MariaDB connection. This addition bolsters the roster of supported database platforms and broadens the audience that can benefit from the tool. Features available to teams working with SingleStore include the query analyzer, schema compare tool, visual analytics, and the entity-relationship (ER) modeler. 

 

  • The ability to perform unit testing for SQL Server and PostgreSQL databases has been added to the new version of Aqua Data Studio. Teams can write and run unit tests using the new Unit Test Frameworks feature for SQLServer and PostgreSQL.

 

  • A Data Compare Wizard has been added to simplify the task of comparing query and table data results. Selecting files for comparison can be done through the tool’s graphical user interface (GUI) and delta scripts can be created for table synchronization.

 

  • Users can choose to make their database connections more secure by turning off the remember-password feature. This eliminates the potential risk of unauthorized users gaining access to databases from another user’s session. In these days of an increasing number of data breaches, this is a nice feature that provides additional security to the database environment. 

 

  • Database teams can work with stored procedures in Amazon Redshift and Snowflake using the new version of Aqua Data Studio. Users can create, store, and execute stored procedures on these two platforms, a feature not present in previous versions of the tool.

 

These are among the most important updates that appear in Aqua Data Studio 22.0. The tool also expands support for Snowflake and provides updated drivers for a variety of platforms. The updates make Aqua Data Studio an even more flexible and useful tool for database teams.

 

A video that talks about what’s new in Aqua Data Studio version 22.0 is available and further illustrates how the additional features benefit a database team. It’s worth a view if you are on the fence about how Aqua Data Studio fits into your database team’s software support tools. 

 

Try Aqua Data Studio for free!