Blog

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.

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 ...

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...

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...

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.

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...

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…

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.

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.

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…

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...

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…

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…

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 ...

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...

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.

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.

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.

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...

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.

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.

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...

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.

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.