Monitoring & Performance
Security & Compliance
Backup & Administration
Data Modeling and Architecture
Aqua Data Studio
SQL Development and Tuning
Uptime Cloud Monitor
Uptime Infrastructure Monitor
Ask the Experts
sql diagnostic manager
SQL DM for MySQL
Blog - Post List
By view count
By comment count
Data Modeling Still Important in a Big Data, Analytics World
As more organizations embrace big data and analytics to gain insight from extremely large data sets the tools and systems that we use to manage data have grown, changed, and multiplied. Instead of just relational, SQL database systems, we now use NoS...
22 Oct 2018
GDPR vs CCPA - A Quick Look
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...
19 Oct 2018
How to Monitor the Performance of MySQL and MariaDB Databases - Part 3
This is the third part of a three-part series of blog posts. Read also the
. Analyze Queries In addition to the real-time monitoring, SQL Diagnostic Manager for MySQL offers several different ways of identifying ...
17 Oct 2018
DBA Paradox – Plus ca change, plus c’est la meme chose
The quote comes from
. 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...
12 Oct 2018
These are a few of my Favorite Macros!
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...
12 Oct 2018
Whoo-hoo! Uptime Cloud Monitor login using Google or G Suite accoun
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...
11 Oct 2018
How to Monitor the Performance of MySQL and MariaDB Databases - Part 2
This is the second part of a three-part series of blog posts. Read also the
. Click here to view the
. Get Overview The OVERVIEW page, which is the initial page, gives you a high-level view of your environment. You get a q...
10 Oct 2018
We'll See You at PASS Summit 2018!
It’s that time of year again! IDERA is excited to see everyone at PASS Summit 2018! This year’s summit will take place from November 6th-9th at the Washington State Convention Center in Seattle, Washington. The exhibit hall will be o...
9 Oct 2018
How to Set Up MySQL 8 Cluster Replication
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...
5 Oct 2018
Need more time in your day to do the fun stuff? The new Automatic Installation of Agent on Uptime Cloud Monitor Agent for Linux and Windows was made for you.
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...
4 Oct 2018
How to Monitor the Performance of MySQL and MariaDB Databases - Part 1
This is the first part of a three-part series of blog posts. Click
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...
3 Oct 2018
How to Build Effective Data Visualizations
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...
1 Oct 2018
Announcing SQL Safe Backup 8.5.1 General Availability
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 SQL Safe Backup provid...
27 Sep 2018
Save the Dates: October ER/Studio Events
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...
26 Sep 2018
IDERA Honored in DBTA’s “Big Data 50” List
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...
20 Sep 2018
October #SQLChat: Making the Most of Conferences - From Training to Networking
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...
20 Sep 2018
Attention Operational DBAs
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...
19 Sep 2018
Data Breaches Are Common - Are You Prepared?
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...
18 Sep 2018
The Simple 3-2-1 Rule for Backups
Earlier this month, one of Microsoft's Azure data centers encountered an outage that impacted customers worldwide. Microsoft recently provided a
of the outage, which details the series of events that lead up to ...
18 Sep 2018
Fixing Database Performance Problems
(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...
14 Sep 2018
Five reasons SQL Server health checks are life savers
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...
5 Sep 2018
How can DevOps help database teams improve software delivery?
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...
5 Sep 2018
Amazon and VMware accelerate Hybrid Cloud partnership
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.
4 Sep 2018
September #SQLChat: Automation in SQL Server - How to Work Only 40 Hours a Week
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...
4 Sep 2018
What is NoSQL and Why Should I Care?
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...
31 Aug 2018