Monitoring & Performance
Security & Compliance
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
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
Announcing the GA Release of SQL Secure 3.2
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...
30 Aug 2018
Apply to the IDERA ACE Program Today!
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...
30 Aug 2018
Top SQL Server Backup mistakes and how to avoid them
Backing up SQL Server databases is one of the most critical tasks that database administrators perform in their SQL Server environments every day. The backup process is so essential that it usually requires distinct processes, checklists, and multipl...
29 Aug 2018
Building Blocks for Visualizing Business Intelligence using Aqua Data Studio
When providing analytic reports to Senior Management, there are many approaches that can be taken to create these necessary building blocks for Business Intelligence. Before we show you suggested building blocks, let’s break down the term...
28 Aug 2018
How to comprehensively manage SQL Servers on-premise and in the cloud
The volume, velocity, and variety of data is ever-increasing. At the same time, data is becoming ever more critical to the growth of organizations. Data is also becoming ever more difficult to manage across on-premise and cloud platforms. All these d...
28 Aug 2018
Does Database or Version Matter?
I’m sure you’ve heard the saying, “Never discuss politics or religion in polite company”. That’s good advice. This blog is not intended to spark impassioned debate on a topic that for many DBAs is their religion: the dat...
26 Aug 2018
Introduction to Windows Azure SQL Database
Many organizations are adopting the cloud computing as their primary computing environment, and others find ways to use Microsoft Azure to enhance their current offerings and create solutions that would otherwise be difficult to achieve. As Microsoft...
22 Aug 2018
Azure MySQL Database as a Service - The next best thing to an Azure Database as a Service Addon
Azure MySQL Database as a Service - A Primer The Azure PaaS has really kicked off and databases are no different.Mic...
20 Aug 2018
Simple Worthwhile Database Security Practices – Part IV
Database security is a hot topic these days, especially with all the new and seemingly never-ending security compliance requirements being imposed such as GDPR. This means that DBAs must up their game when it comes to database security. Some DBAs may...
20 Aug 2018