Latest Posts

  • Your MySQL Servers Are Being Targeted By Ransomware

    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.
    • 24 Jan 2020
  • Why You Need to Manage Your Database Changes

    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.
    • 22 Jan 2020
  • Is Your Company Prepared for Cyberattacks?

    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.
    • 21 Jan 2020
  • The Substantial Risks of Neglecting Data Governance

    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.
    • 17 Jan 2020
  • FluidShell - A Primer - SQL Server Edition

    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...
    • 16 Jan 2020
  • Helping Management See the Story Hidden in the Data

    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.
    • 15 Jan 2020
  • The Compromise Between Database Performance and Security

    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.
    • 13 Jan 2020
  • CCPA is in effect - Now What??

    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...
    • 7 Jan 2020
  • Aqua Data Studio 20.5 General Availability

    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 ...
    • 7 Jan 2020
  • The Best Way to Manage Queries on Multiple Platforms

    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.
    • 3 Jan 2020
  • Tips That Will Tighten Up Your SQL Server Security

    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.
    • 2 Jan 2020
  • Developing Viable Smart Cities Requires Data Governance

    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…
    • 30 Dec 2019
  • How to use temporal data to improve SQL code

    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...
    • 26 Dec 2019
  • Announcing the GA Release of SQL Safe Backup 8.6

    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...
    • 20 Dec 2019
  • Why You Need To Perform Database Benchmarking Correctly

    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.
    • 20 Dec 2019
  • Fundamentals of DevOps as it Relates to Your Database Team

    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.
    • 19 Dec 2019
  • What are the rules for table design heuristics for relational models?

    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...
    • 18 Dec 2019
  • MySQL Monitoring Best Practices Make You a Better DBA

    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.
    • 18 Dec 2019
  • DBArtisan Tips and Tricks Webinar November 2019

    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...
    • 17 Dec 2019
  • An Improved GUI Results in Better SQL Server Tuning

    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.
    • 17 Dec 2019
  • Why Compressing Database Backups Makes Good Sense

    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.
    • 16 Dec 2019
  • Data Governance Can Strengthen Your Cybersecurity Efforts

    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.
    • 13 Dec 2019
  • Visualization and Analytics for a Competitive Edge

    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.
    • 12 Dec 2019
  • How to improve your SQL queries to improve database performance

    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...
    • 11 Dec 2019