Latest Posts

  • A Tool for Creating More Efficient SQL Code Quickly

    Writing SQL code is a part of the everyday life of database administrators and developers. Rapid SQL is a coding tool that streamlines the process of crafting efficient code across multiple database platforms.
    • 10 Jul 2020
  • What do you need to know about compliance audits?

    Compliance audits are an inescapable part of the information technology world we live in. A compliance audit is a detailed review that is conducted regarding the degree to which an organization is following specific regulatory guidelines or terms of ...
    • 9 Jul 2020
  • Help – I’ve inherited yet another database!

    With many companies trying to do more with less, it’s not uncommon for a database administrator (DBA) to find out they’ve just been assigned yet another database. If they’re lucky, the new database will be of the same kind as others...
    • 8 Jul 2020
  • SQL Diagnostic Manager 10.6 General Availability

    We are pleased to announce the general availability of SQL Diagnostic Manager 10.6. Existing users may upgrade to this version through the Idera Customer Portal. New users may download the trial version from the Idera Website.  With this release...
    • 8 Jul 2020
  • The Important Role of Compliance Reporting

    In the current world of increased focus on regulatory compliance, it is not enough to just meet all applicable standards. SQL Compliance Manager provides the reporting capabilities that allow you to demonstrate and prove compliance to internal or external auditors.
    • 8 Jul 2020
  • Announcing the General Availability of SQL Secure 3.3.2

    We are pleased to announce the general availability of SQL Secure 3.3.2. Customers can access the new version via the IDERA Customer Portal. New customers can access the trial version via the IDERA website. IDERA SQL Secure is an industry-leading, s...
    • 7 Jul 2020
  • Maintaining the Security of Your MySQL Databases

    MySQL is a popular database solution for eCommerce and websites. This makes it critically important to keep systems secure to avoid data breaches or unexpected outages. SQL Diagnostic Manager for MySQL is a full-featured monitoring tool that addresses the security and health of your MySQL databases to…
    • 6 Jul 2020
  • You Need to Read the Fine Print on Your Software Licenses

    Unexpected software license audits can be costly and disruptive. Major software vendors can subject your company to this practice with little advance notice. IDERA does not believe in surprise audits. Do not expose your organization to risks of non-compliance across your software portfolio.
    • 2 Jul 2020
  • What Makes a Dashboard Useful to its Audience?

    Dashboards are a great way to provide stakeholders with valuable information for decision making. Aqua Data Studio can help your database team create dashboards that will satisfy users with data from over 30 different database platforms.
    • 30 Jun 2020
  • The Best Way to Reduce Your DBAs’ Learning Curve

    Keeping up with the educational requirements of supporting multi-platform database environments can be challenging to say the least. One way to help address this issue is to use a standardized support tool such as DBArtisan that lets you manage and administer multiple database platforms from a unified…
    • 29 Jun 2020
  • Agile + Data Modeling = Greater Success

    Let me start by saying that agile development is fundamentally sound and has serious merit. In may in fact be the best development methodology there is. However, that does not mean there are no serious issues with it in practice. In this blog, I will...
    • 28 Jun 2020
  • How to Choose the Right Database for Your Application

    Choosing the right database platform for an application requires you to answer several important questions. Fortunately, just about any database solution you select can be supported by Aqua Data Studio. It's a flexible solution that enables your team to access and manage over 30 database platform from…
    • 26 Jun 2020
  • The Challenge of Managing Newly Acquired Databases

    Comparing and synchronizing databases is an important task that DBAs are called upon to perform in a variety of situations. SQL Comparison Toolset offers your database team an application that automates the time-consuming manual processes necessary when migrating or integrating new databases into your…
    • 24 Jun 2020
  • Designing a Database

    ER/Studio has two primary use cases; designing databases and documenting databases. In this blog we will discuss designing a database.  In this use case the mission is for a Data Architect who wants to take requirements from their customer ...
    • 24 Jun 2020
  • Documenting a Database

    ER/Studio has two primary use cases; designing databases and documenting databases. In this blog we will discuss documenting a database. We need to be able to document it to understand its contents. We have three approaches to this: As a Localised P...
    • 24 Jun 2020
  • A Simple Way to Make Your SQL Server DBAs More Efficient

    Tools and methods that can help DBAs get their work done efficiently are always welcomed by a database team. SQL Admin Toolset offers 24 different tools that will contribute to the productivity of your database team and keep your SQL Servers running smoothly.
    • 22 Jun 2020
  • Why Data Modeling is an Important Skill

    Data modeling is an important skill for database teams to possess. It can be an essential part of a successful database migration or when reverse engineering newly acquired systems.
    • 19 Jun 2020
  • The Best Practices for Implementing Effective Monitoring

    Effectively monitoring your database systems is vital to maintaining system performance. There are ways to optimize the way you monitor to get the most out of the process. SQL Diagnostic Manager for SQL Server is a comprehensive monitoring tool that helps keep your systems running smoothly.
    • 17 Jun 2020
  • Data Visualization - Quick and Easy

    Visually analyze data with Aqua Data Studio and bring your data to life! Create engaging data visualizations and dashboards to explore and share. Identify patterns and trends to find opportunities for further analysis. Apply filters, data labels, ta...
    • 17 Jun 2020
  • How to Keep Critical Systems Running During the Pandemic

    Among the many changes forced on society by COVID-19 is the elevation of the importance of some computer systems that were previously not considered critical. Uptime Infrastructure Monitor can help address the issues with keeping critical systems available and running at peak efficiency.
    • 15 Jun 2020
  • Keeping Everyone on the Same Page with Data Governance

    As the size of an organization increases, so too does the potential for misuse of enterprise data assets. ER/Studio Enterprise Team Edition is a collaborative tool that can help create a solid foundation for data governance to ensure everyone uses it in the same way.
    • 12 Jun 2020
  • Plagued by IT Downtime?

    Cut IT Downtime By Using Server Monitoring Tools.   In today’s world, we need to keep our organizations up and running 24/7 with limited or non-existent unscheduled downtime, or face the wrath of IT directors and CIOs. Server monitoring to...
    • 10 Jun 2020
  • Monitoring is the Key to Improving Database Performance

    SQL Diagnostic Manager can help database teams maintain high performing SQL Server systems. It offers a wealth of features such as customized alerts and real-time monitoring that keep your team informed of their systems' status at all times.
    • 10 Jun 2020
  • The Use of MySQL in the Scientific Community

    MySQL is used extensively by many industries and organizations. The scientific community has used this database platform to construct many systems that foster research and the exchange of information. SQL Diagnostic Manager for MySQL can help manage MySQL environments whatever their purpose.
    • 8 Jun 2020