Blog

MySQL servers are not immune to vicious attacks from ransomware. Some variations of this malware target specific enterprise software such as MySQL. Vigilant monitoring highlights unusual system activity so it can be addressed by system admins and the security team.

Managing change in a dynamic IT environment can be a complicated task that demands the right personnel and tools to perform effectively. DB Change Manager is a valuable tool that can help your teams keep changes under control and provide reporting to auditors and other interested parties.

The threats of cyberwarfare are continuing to rise around the world. Incidents can affect your SQL Servers at any time, potentially crippling your organization. SQL Safe Backup offers a tool that can help protect these valuable assets and allow you to fully recover impacted systems.

Many organizations have not addressed the need to institute data governance to protect their information resources. ER/Studio Enterprise Team Edition is a collaborative tool that helps build the foundation of a strong data governance program throughout the company.

Welcome to this first of three blog posts that would cover the basics of getting practical usage of Aqua Data Studio's FluidShell. Introduction: What is FluidShell? FluidShell includes commands which can be executed from the shell's command line. Th...

It can be difficult to convey the information contained in statistics appropriately so they can be used by decision-makers. Aqua Data Studio offers a tool for creating data visualizations from over 30 different database platforms so the underlying knowledge can be understood by all stakeholders.

Finding the right balance between database security and performance can be challenging. You may need to adopt new strategies to fully address both points. SQL Secure is a valuable tool that can help secure your SQL Server environment and keep it compliant with regulatory standards.

On Jan 1st, 2020 as many of us were sleeping off the revelry from the previous night, silently the CCPA (California Consumer Protection Act) went into effect. GDPR has been in effect for some time now, but it has mostly been viewed as a European thin...

Idera is excited to announce Version 20.5 of Aqua Data with major Enhancements in the following areas. Platform support now includes Amazon RDS for MariaDB, Microsoft SQL Server, MySQL, Oracle and PostgreSQL!  Aqua Data Studio now provides ...

The challenge of managing multiple platforms can negatively impact the productivity of any database team. Aqua Data Studio enables your team to access and manage all of their SQL, NoSQL, and cloud databases from a single interface leading to enhanced productivity.

SQL Compliance Manager can help maintain the high levels of security that are demanded with the increased focus on regulatory standards. It helps you identify and protect the information living in your SQL Server databases.

Smart cities bring together data and technology to enhance the lives of their citizens. Constructing a smart city requires the use of tremendous amounts of data that demand a governance program to process effectively. ER/Studio Enterprise Team Edition offers a valuable tool for organizations wrestling…

SQL is the first programming language with temporal data types. The SQL-92 standard added temporal data to the language, acknowledging most of what was already in most SQL products by that time. The problem is that each vendor made a trade-off intern...

We are pleased to announce the general availability of SQL Safe Backup 8.6.  IDERA SQL Safe Backup provides a mission-critical backup and recovery solution for Microsoft SQL Server deployments in environments ranging from small business and depa...

Database benchmarking is an important process that DBAs may need to engage in periodically. There are many roadblocks that need to be negotiated in order to perform the process successfully. DB PowerStudio can serve as a valuable tool for facilitating benchmarking.

DevOps is the melding of the development and operations teams with the goal of streamlining and improving the software development and production process. Aqua Data Studio can be a valuable tool that contributes to the success of your DevOps initiative.

The dictionary definition of a 'heuristic' is ‘Computers, Mathematics: pertaining to a trial-and-error method of problem-solving used when an algorithmic approach is impractical.’. That definition means that this is what you do wh...

Using the right tool combined with best practices can help a DBA properly monitor their systems and stay out of the limelight that accompanies user complaints and outages. SQL Diagnostic Manager for MySQL is that tool and will help your database team stay on top of all their MySQL instances.

The November edition of DBArtisan tips and techniques Webinar covered three tips for using DBArtisan. Using Projects to organize your work Using the visual Query Builder Space Management using DBArtisan You can view a recording of the event he...

Precise for Databases is a trusted tool that has been used for years by many DBAs. See how you can use Precise on Chrome, Firefox, and Internet Explorer to tune your database transactions for optimal performance.

Compression is a more viable tactic for streamlining database backups than deduplication for several reasons. SQL Safe Backup is a valuable tool that will compress and encrypt database backups to keep your data safe and your backups completing on time.

Data governance is a viable method of strengthening your organization's cybersecurity. It demands a tool designed for collaboration such as ER/Studio Enterprise Team Edition for building a strong data governance foundation.

Obtaining value from the flood of data available to companies can be as challenging as solving a Rubik's cube in record time. Visualization can be a valuable tool to address this difficult task. Aqua Data Studio offers visual analytics for all major database platforms.

A query that runs well on a local set of test data can fail miserably on a production system. Very often, a simple change in the syntax can make a huge performance difference. Much of the advice concerning SQL is ‘it depends’ because tuni...