Blog

In week two of our blog series The Tradeoff Between Database Security and Database Performance, we explore the roles of database administrator and security administrator and why it is best practice not to combine the roles.

Cross-platform database development and management pose a host of problems. Many of them can be minimized or eliminated through the use of Aqua Data Studio.

In this post, we talk about using TSM as the method of backing up your SQL databases and the advantages of using SQL Safe Backup to streamline the process of protecting your data.

In this blog in our Benefits of SQL Diagnostic Manager for MySQL (formerly Monyog) series, we detail MySQL and MariaDB monitoring features with SQL Diagnostic Manager for MySQL, including real-time monitoring and monitoring MySQL error logs.

Choosing the right data owners is a critical step in forming a data governance program. ER/Studio Enterprise Team Edition can help solidify your plans by facilitating the collaboration needed to institute data governance.

Lack of DBA skills should not be a reason to move away from the benefits of MySQL. Employing a quality monitoring tool like SQL Diagnostic Manager for MySQL can help DBAs of any skill level improve the performance of their system.

Join IDERA (@Idera_Software) and host Matt Gordon (@sqlatspeed) on July 31 at 11AM CT for a community discussion on SQL Server 2019.

Welcome to our new blog series, The Tradeoff Between Database Security and Database Performance. This series will cover best practices that will help to improve the ability to achieve the apparently conflicting goals of improving both database securi...

In this post we look at how the centralized console offered by DBArtisan can make you a better DBA by allowing you to focus on learning one tool.

Infrastructure monitoring and capacity planning work hand-in-hand to keep your systems functioning and available. We look at how metrics collected through monitoring can assist your capacity planning efforts.

In this blog in our Benefits of SQL Diagnostic Manager for MySQL (formerly Monyog) series, we discuss monitoring and understanding performance trends using visual analytics and the display dashboard of SQL Diagnostic Manager for MySQL.

SQL Compliance Manager 5.6 was released last week Last week we released SQL Compliance Manager 5.6.  Along with it are some new and exciting changes in the product.  We thought we would share some more detailed notes on the new functionalit...

A validated disaster recovery plan is an important tool that enables you to keep business-critical applications running in the event of a disaster. Tools such as SQL Doctor can help identify problem areas in your SQL recovery plans.

Welcome to the DB PowerStudio Blog. This blog will cover all things about DB PowerStudio. DBArtisan is one part of the suite of tools known as DB PowerStudio. The June edition of DBArtisan tips and techniques covered three tips for using DBArtisan. ...

This article describes how to begin implementing a data governance program by developing a language shared by all stakeholders.

This article discusses the benefits of monitoring a MySQL system and offers some suggestions on where to start. It also points to SQL Diagnostic Manager for MySQL as an excellent solution to perform your monitoring.

This post talks about the potential for a GDPR type of personal data regulation to be implemented in the U.S. and discusses how it will impact DBAs. We offer tools to help with compliance.

We’re excited to announce the release of SQL Compliance Manager 5.6. SQL Compliance Manager is a comprehensive database auditing solution that monitors and tracks changes to SQL Server objects and data, and sends alerts on suspicious activity. ...

In this blog in our Benefits of SQL Diagnostic Manager for MySQL (formerly Monyog) series, we discuss how to identify and analyze problematic SQL queries using SQL Diagnostic Manager for MySQL.

This article describes the benefits of performing performance monitoring to identify potential security weaknesses in your IT environment.

This post discusses the advantages of presenting your data in a visual manner to enable it to be more easily understood by a diverse audience.

Concluding our Solutions for the Cloud blog series, we discuss cloud deployment models - public cloud, private cloud, hybrid cloud, and community cloud - and their differences. If you missed our blog last week, feel free to read about Cloud Serv...

In this blog in our Benefits of SQL Diagnostic Manager for MySQL (formerly Monyog) series, we dive into agentless monitoring technology, cloud readiness, and customization options with SQL Diagnostic Manager for MySQL.

With changes in software development methodologies, the role of the data modeler has changed significantly.  In many organizations, data modelers now find themselves on the outside looking in, relegated to documentation “after the fact&rdq...