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
Key Considerations for Selecting a Database Tool
Database professionals must handle many different tasks during the work day, ranging from creating queries and scripts to comparing and editing dataset results, just to name a few. Whether you’re a DBA or a developer, you may have some frequent...
14 Nov 2018
Five database administration mistakes that can cost you your job
Everyone makes mistakes. Database administrators are no exception to that rule. When database administrators make mistakes, they are often the ones who find it first and have to fix it. The trick to appear to never making mistakes is to get good at d...
14 Nov 2018
SQL Performance, Part 1: Relational Optimization
Application developers must code efficient SQL and understand how to optimize SQL in order to develop efficient applications. But it is not just the programmer, but also the DBA who must understand SQL optimization. It is a joint responsibility and f...
12 Nov 2018
Announcing SQL Inventory Manager 2.5 General Availability
We are pleased to announce the general availability of SQL Inventory Manager 2.5. Existing users may upgrade to this version through the
IDERA Customer Portal
. New users may download the trial version from the
. This release in...
8 Nov 2018
Seven steps to alert effectively
Automated alerts are essential to performance monitoring. Automated alerts enable spotting issues in infrastructures, identifying their causes, and rapidly minimizing degradation and disruption of services. Alerts draw human attention to particular s...
7 Nov 2018
Introducing IDERA SQL DM Performance Insights for Azure Data Studio
IDERA is pleased to announce the introduction of
IDERA SQL DM Performance Insights
, a Microsoft Azure Data Studio (ADS) extension which displays key performance metrics for SQL Server that have been collected and stored in a database repository by
6 Nov 2018
Introducing the 2018-2019 Class of IDERA ACEs!
Introducing the 2018-2019 Class of IDERA ACEs! We are excited to introduce our 2018-2019 class of IDERA ACEs! This program helps active members of the database and data modeling community share industry knowledge by sponsoring their travel for speaki...
2 Nov 2018
Aqua Data Studio's Powerful Data Grid
One of the most overlooked powerful features in Aqua Data Studio is the Data Grid. The data grid can double your productivity with Data Management. No matter where the data resides, whether in a relational, cloud, document store, or an Excel source, ...
1 Nov 2018
November #SQLChat - Let’s Talk About Data Analysis!
A solid data analysis process and capable tools are key components of a strong data professional's skill set. Join IDERA (
) and host Chris Hyde (@
) on Wednesday, November 28 at 11 AM CT for a community discussion on ...
31 Oct 2018
Learn more about SQL Server statistics
Statistics, or “stats,” are fundamental components of SQL Server performance, but vastly under-appreciated and misunderstood. They are at the core of query optimization and can have a tremendous effect on query plan selection. The query o...
31 Oct 2018
The Importance of Data Lineage
How many times have you been querying some data, or looking at a report, and asked yourself something like “Should I believe this data? I wonder where this data came from?” Well, what you are asking about is the lineage of the data. The M...
31 Oct 2018
Reverse Engineer SnowFlake from IDERA ER/Studio
Howdy! In this short and concise blog post, I am really excited to be sharing on how to reverse engineer from ER/Studio via ODBC. For reverse engineering from ODBC check out this article.
31 Oct 2018
Data Architecture: The Foundation for Enterprise Architecture and Governance
"Data modeling is all about understanding the data within our organizations and then representing this data in a precise visual (the “data model”) which aids communication – saving time during development, saving money on support, a...
26 Oct 2018
How to balance database security versus database performance
The security of any database can be improved. However, that likely degrades the performance of the database. The cost increases to improve database security while maintaining database performance. That is, the trade-off consists of three axes: Perfor...
24 Oct 2018
How to Find and Fix SQL Server Deadlocks
Introduction Locking is required for concurrent operations of relational databases to prevent data inconsistency and loss. However, locking impairs the performance of databases. Moreover, the locking process is often complicated. Deadlocks occur when...
23 Oct 2018
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