Featured Blog
ER/Studio 20.0 GA
ER/Studio 20.0 delivers a variety of performance improvements, usability features, security improvements, and bug fixes. As a bonus, we’ve improved scalability for enterprise-level usage. Get the latest version today!
Improve database development
Wherever data takes the organization, the database must follow. And wherever the database goes, database administrators and developers must take the...
SQL Diagnostic Manager 12.2 General Availability
We are pleased to announce the general availability of SQL Diagnostic Manager 12.2. Existing users may upgrade to this version through the Idera...
Make the most of your metadata
Metadata management is not a new concept. However, it is gaining new adherents as we recognize the value of enterprise data governance. We may have...
Benefits of third-party tools for MySQL
Adding third-party tools can be an effective method of enhancing software, since they may provide additional features lacking in the original...
We are excited to announce the General Availability of Aqua Data Studio, Version 22.3.2
Aqua Data Studio is the industry leading multi-platform Integrated Development Environment (IDE) for databases with Visual Analytics. What’s...
Simplify your data analytics
Generating useful data analytics involves multiple time-consuming and tedious steps, including: Accessing usable data that can help business users...
How to Maintain Security Compliance to Prevent a Costly Data Breach
As businesses and government organizations shift a growing amount of their operations online, security has become an increasingly important issue....
Empower operational data governance with data lineage
Much of the conventional guidance about implementing a data governance program focuses on organizational structure and the protocols for defining...
Tune MySQL performance
MySQL is a popular relational database management system. It is the preferred platform for business critical eCommerce systems that companies rely...
Do you need a tool to manage your databases?
The growing amount of data that organizations must store and manage is increasing the challenges faced by all database professionals, including...
Enable customer business intelligence with data catalogs, business glossaries, and data governance
For over three decades, organizations have relied on data warehouses to support the needs for descriptive analytics of business information...
Become a database administrator for MySQL
You are perhaps reading this because you think that becoming a database administrator may be the right career path for you. Database administrators...
Align data governance with business-driven data architecture
The role of the data analyst has gained prominence in relation to the recognized criticality of processed and analyzed information as an integral...
Improve data modeling with Aqua Data Studio
Data architects spend a major time of their job on data modeling. As such, they need to ensure that change to their data stores is controlled and...
Best IDE for data analysts
Data analysts need good visibility to the right data to make good business decisions. They also require easy access to the appropriate data, and a...
Announcing General Availability of SQL Workload Analysis (SWA) 1.7.2
We’re excited to announce the release of SQL Workload Analysis (SWA) 1.7.2 Problematic SQL queries can severely reduce the performance of SQL Server...
Manage data and result sets, and SQL queries with Aqua Data Studio
Aqua Data Studio improves access and consistency by accessing data sources from a single tool to minimize the learning curve and maximize the...
Easier database management with Aqua Data Studio
Database administrators spend most of their time keeping databases running with little time to focus on performance and future-proof the...
Aqua Data Studio: IDE with visual analytics and automation
Aqua Data Studio accelerates data management processes by simplifying common tasks and automating routine operations. Visual analytics Run visual...
Database IDE: Aqua Data Studio is the best for developers
Developers require application performance and stability. When developing applications, they need to optimize SQL code to enhance the performance...
Manage schema, models, files and servers with confidence
Aqua Data Studio simplifies data-centric tasks by working on data sources without exposure to complex technical elements, detailed technical skills,...
Manage data with Aqua Data Studio
Aqua Data Studio is the industry-leading, multiple-platform, integrated development environment (IDE) for data. It provides many benefits to a...
DBTA Trend Setting Products 2023
DBTA Announces Idera, Inc. Portfolio of Products as the Trend Setting Products for 2023 “Today’s data environments are highly diverse—residing on...
The new release of SQLyog 13.2 provides one update and multiple bug fixes.
Update Upgraded the PLINK executable bundled with SQLyog to PuTTY/PLINK v 0.77, to support private keys generated in the PPK version 3 file format...
Announcing the General Availability of SQL Secure 4.2
We are pleased to announce the general availability of SQL Secure 4.2 SQL Secure is the industry-leading, state of the art auditing and security...
Automatic Corrective Action
Precise offers script execution as a response action to an alert. This post provides an introduction to configuring automatic corrective...
How long have you been using SQL Diagnostic Manager?
February 4, 2014 at 6:30 pm Vicky Harp Keymaster I’ve been fortunate enough to be able to work with, or on, SQL Diagnostic Manager for nearly 10...
Query a SQL database with Powershell
This script can be used to query an SQL database $SqlConnection = New-Object System.Data.SqlClient.SqlConnection $SqlConnection.ConnectionString =...
SQL Server Security: Always Encrypted
Always Encrypted (AE) is a feature Microsoft introduced to SQL Server 2016. This post will provide an overview of AE and talk about how it can be...
What is Logical Data Modeling?
Logical data modeling is the second of the three stages of data modeling and one of three types of data model. The three types of data model -...