Monitoring & Performance
Security & Compliance
Backup & Administration
Data Modeling & Architecture
Aqua Data Studio
SQL Development & Tuning
Uptime Infrastructure Monitor
Ask the Experts
Announcing SQL Compliance Manager 5.6
We’re excited to announce the release of SQL Compliance Manager 5.6!
Constructing a Shared Language for Data Governance
Begin implementing a data governance program by developing a language shared by all stakeholders.
What's New in SQL Compliance Manager 5.6
We recently released SQL Compliance Manager 5.6 featuring new and exciting changes in the product.
DBArtisan Tips, Security, Projects and Visual Query…
Dive into DBArtisan with tips and techniques for IDERA's premier DBA productivity tool.
Browse by Tag
Aqua Data Studio
Microsoft SQL Server
MySQL server monitoring
MySQL slow query log
real time monitoring
SQL Compliance Manager
SQL Diagnostic Manager
SQL DM for MySQL
By view count
By comment count
Agile is the new Waterfall
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...
21 Jun 2019
Managing Backup & Recovery is the Most Important Thing DBAs Do
I know that many database professionals will cringe at the title of this blog post, but it is absolutely the truth. DBAs are charged with many duties including backing up and recovering data, assuring optimal performance of database systems and appli...
20 Jun 2019
Cloud Service Delivery Models
In week 3 of our Solutions for the Cloud blog series, we dive into three service delivery models of the cloud concept. If you missed it, feel free to read our previous post on
Cloud Building Blocks and Layers.
The cloud concept offers three service ...
20 Jun 2019
Benefits of SQL Diagnostic Manager for MySQL (formerly Monyog)
In this blog in our Benefits of SQL Diagnostic Manager for MySQL (formerly Monyog) series, we discuss some of the challenges associated with MySQL and MariaDB database systems.
18 Jun 2019
Cloud Building Blocks and Layers
Welcome back to our blog series, Solutions for the Cloud. Now that we’ve discussed
three concepts of virtualization related to the cloud
, we will cover the basics of cloud infrastructure including cloud building blocks and layers. The cloud in...
13 Jun 2019
Access InterBase and Snowflake with Aqua Data Studio
Last month, Lisa Waugh
announced the release
of the latest version of Aqua Data Studio (ADS). Version 20.0 expands the platform coverage of this extensive database IDE to include
, an embeddable relational database, and Snowflake...
7 Jun 2019
Solutions for the Cloud - Virtualization
Welcome to our latest weekly blog series, Solutions for the Cloud. This series will focus on central concepts and benefits related to the cloud and how database tools can assist in managing and monitoring your cloud environment. This week, we discuss...
6 Jun 2019
June #SQLChat - Optimizing SQL Server Indexes
SQL Server indexes can improve SQL Query performance when done correctly - but how do you create an optimal set of indexes? Join IDERA (@Idera_Software) and host Eric Blinn (@SQL2TheSequel) on Wednesday June 26 at 11AM CT for a community discussion o...
5 Jun 2019
Announcing the GA Release of SQL Secure 3.3
We’re excited to announce the release of SQL Secure 3.3. 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 baseli...
31 May 2019
Deploying the SQLcompliance Agent in a Failover Cluster Environment Using a Powershell Script
Background A few months ago, I spoke to one of our
SQL Safe Backup
customers that had a very large SQL Server environment. In an effort to streamline the deployment of the SQL Safe Backup Agents throughout his environment, he created a Powershell scr...
27 May 2019
Announcing General Availability of Aqua Data Studio 20.0!
On behalf of the entire Aqua Data Studio team, we’re excited to announce the release of Aqua Data Studio version 20.0 with major enhancements in the following areas. We have extended our Platform Support to include Embarcadero InterBase and Sno...
23 May 2019
How to look for extra funding for database administration tools
It is difficult for database administrators to run their databases efficiently and effectively without proper funding. Whether you are asking for additional funding for the first time or giving it another go after a few failed attempts, knowing how t...
22 May 2019
Manipulating Data for Visual Analytics - Aqua Data Studio - IDE
As we end our Improving the Daily Life of a Database Developer blog series, we outline how to manipulate data for visual analytics. Be sure to check out our previous post,
Comparing Data Sets and Object Scripts
. Within database teams, dat...
20 May 2019
Why should database administrators learn PowerShell?
Microsoft’s PowerShell is a task-based command-line shell and scripting language. It is an automation platform and scripting language that simplifies the management of Windows and Linux environments. It is designed primarily for system administ...
15 May 2019
ER/Studio Data Architect 18.0.1 patch release is available!
We are pleased to announce the availability of the ER/Studio Data Architect 18.0.1 patch release ER/Studio 18.0.1 Data Architect corrects an error when connecting to SQL Server using windows credentials when reverse engineering a database (issu...
13 May 2019
Comparing Data Sets and Object Scripts - Aqua Data Studio IDE
Last week, we discussed Generating and Executing Object SQL Scripts, and you can view that post
In week 5 of our Improving the Daily Life of a Database Developer blog series, we compare data sets and object scripts. Having created...
13 May 2019
Demystifying Regulatory Guidelines
There are several regulations out there that tell you how you should be handling your data. Some organizations are held accountable to multiple different regulations at the same time. Some of these regulations may be in conflict with another. H...
9 May 2019
May #SQLChat - Designing Data Warehouses
IDERA’s #SQLChat is back! Join IDERA (@Idera_Software) and host Leslie Andrews (@landrews5807) on Wednesday May 29 at 11AM CT for Designing Data Warehouses: Using the Power of the Data you have. Leslie will be leading the chat on different...
9 May 2019
How to be a better accidental database administrator
Data is more important than ever to business success. As data demands continue to skyrocket, many database administrators are given responsibilities that fall outside their job function. The accidental database administrators are becoming more preval...
8 May 2019
Generating and Executing Object SQL Scripts - Aqua Data Studio IDE
In week 4 of our Improving the Daily Life of a Database Developer blog series, we discuss the common task of generating and executing object scripts. If you missed it, you can read the previous post on
Creating High-Quality and Easily Editable SQL.
6 May 2019
Do not leave your most valuable backups to chance
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...
1 May 2019
DevOps and the DBA
Modern application development teams are aligned to deliver software using agile methodologies and a DevOps approach. Agile and DevOps are not the same thing, but they work well together to improve the application development process enabling quicker...
1 May 2019
Enjoy May Day without “mayday” - protect your SQL Server data
May 1st is traditionally celebrated as “May Day” to welcome the return of spring. In Central Texas, we often get a lot of rain in the spring, sometimes with hail or tornados, but we’re glad to avoid the late snowfall seen in other a...
1 May 2019
How to Create High Quality SQL Code that is Easy to Edit. - Aqua Data Studio IDE
In week 3 of our Improving the Daily Life of a Database Developer blog series, we detail how to create high quality SQL code that is easy to edit. If you missed it, you can read the previous post on
Navigating the Database.
Creating, editing, and ru...
29 Apr 2019