Blog

On June 28th, 2018, California enacted the California Consumer Privacy Act (CCPA).  It will go into effect on January 1, 2020. Guidelines must be followed for any company who wishes to collect data on California residents. Some of the law may be...

This is the third part of a three-part series of blog posts. Read also the first part and second part.   Analyze Queries In addition to the real-time monitoring, SQL Diagnostic Manager for MySQL offers several different ways of identifying ...

The quote comes from Jean-Baptiste Karr.  And while some may not be familiar with the source and that original language version, almost everyone is familiar with the paradoxical adage in English,  “The more things change, the more the...

Howdy! ER/Studio Users, Prospective Users and Data Modeling Enthusiasts.. In this short blog post , I would like to list out some of my Favorite ER/Studio Macros in the product. Auto Create Data Dictionary - This macro will enable one to kick...

Uptime Cloud Monitor (UCM) now supports Google OAuth SSO authentication. Now you can use your Google account or G Suite enabled account to log in to your UCM account. Get Google OAuth setup today. Prerequisites To log in to your UCM account using Goo...

This is the second part of a three-part series of blog posts. Read also the first part. Stay tuned for the third part coming soon!   Get Overview The OVERVIEW page, which is the initial page, gives you a high-level view of your environment. You...

In the Setting up Basic Master-Slave Replication in MySQL 8 blog, we went through the process of setting up two MySQL servers on the same box for the purposes of replication. In that scenario, the Master handled write operations, while the Slave perf...

Let me guess: You have been using UCM Collector to monitor your server infrastructure, and everything is going great. Except for one minor issue: Whenever a new server spins up, you need to spend 2 to 3 minutes to install the collector agent on the n...

This is the first part of a three-part series of blog posts. Click here to view the second part.   Overview SQL Diagnostic Manager for MySQL is an IDERA product that allows you to monitor MySQL and MariaDB databases. The product is a low-ov...

A tool like Aqua Data Studio provides a rich canvas for creating data visualizations.   While these charts, graphs, etc. can be eye candy, without proper context they are nothing more than pretty pictures.  It is important to create th...

We are pleased to announce the general availability of SQL Safe Backup 8.5.1. Existing users may upgrade to this version through the IDERA Customer Portal. New users may download the trial version from the IDERA website. IDERA SQL Safe Backup provid...

October will be a busy month for the ER/Studio team! You have multiple opportunities to engage with our product experts and learn more about how this feature-rich data architecture suite can help you gain control of your data landscape and establish...

We’re proud to announce that for the second straight year IDERA was named to the “Big Data 50” list published annually by DBTA’s Big Data Quarterly. The prestigious list includes 50 forward-thinking companies that are working...

So you're attending a training conference next month.  Maybe you're a first timer, maybe this is your 10th year.  Making sure you can make it to every session you want is a near impossible task.  Fitting in time between the &qu...

Uptime Database Infrastructure Monitor triages large environments so that you can quickly determine what needs your immediate attention, Database Down.  Instances that are stopped or imminently unavailable are highlighted in red.   Ava...

October is National Cybersecurity Awareness Month.  In preparation for that, I thought I might take a moment to ponder some security issues that occured in the last week or two.  Recently, British Airways made the news for a data breach tha...

Earlier this month, one of Microsoft's Azure data centers encountered an outage that impacted customers worldwide. Microsoft recently provided a preliminary report of the outage, which details the series of events that lead up to ...

(content originally posted by Bert Scalzo on 3/8/2017) There is no such thing as the perfect database. No matter how hard the DBA may try, something outside the planned norms will eventually occur and then performance will suffer. The good news is t...

SQL Server health checks have garnered a great deal of notoriety over the last five years. What was initially a niche offering more than ten years ago has evolved into a mainstream "must-have” for the SQL Server community. A SQL Server health c...

DevOps Research and Assessment (DORA) published a detailed report on the state of DevOps entitled "Accelerate: State of DevOps 2018: Strategies for a New Economy". While there are many research reports one can find on DevOps, this one is notable beca...

Amazon's and VMware’s accelerating Hybrid Cloud partnership blurs the line between on premise and cloud deployments further emphasizing the need for database management tools which flexibly span both of those domains.

Automation in SQL Server - the one thing that can salvage the sanity of the DBA. While automating backups and maintenance processes is common place at most companies, the methods for doing these can differ. Whether using a scripted solution or a main...

Many database professionals have historically worked with traditional relational database management systems (DBMS) such as Microsoft SQL Server, DB2, Sybase, and Oracle which use the Structured Query Language (SQL) language. In fact, relational data...

We are excited to announce the release of SQL Secure 3.2.  SQL Secure is an auditing and security tool for SQL Servers.  It helps identifies vulnerabilities with SQL Server configurations and access, establishes security policies and b...

There’s only a few weeks left to apply to the IDERA ACE program! The search has begun for the 2018 - 2019 IDERA ACEs. Do you have a passion for helping the community and sharing your knowledge? Then apply today! ACE Applications are open until...