Featured Blog
We are excited to announce the General Availability of Aqua Data Studio, Version 22.3!
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...
We are excited to announce the General Availability of Aqua Data Studio, Version 22.3!
We are excited to announce the General Availability of Aqua Data Studio, Version 22.3! Aqua Data Studio is the industry leading multi-platform...
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 -...
Are themes supported in Aqua Data Studio
ADS would still benefit from a THEMES option.Response Thomas Conrad over 1 year ago Hi John, In addition, you can dynamically change the font size...
Fluidshell Source Control
Is there a suite of Fluidshell commands that might relate to source control - e.g., something similar to the git command line client? I guess...
How to schedule an automatic reverse-engineer from a database into a data model?
This blog post describes how you can run a macro to reverse engineer a database and call it from the Windows Task Scheduler. When you use ER/Studio...
Replace sqldm powershell snapins with powershell modules
powersheel 7 no longer support snapins. we cannot use sqldm powershell cmdlets anymore. It would be helpfull if you can replace powershell sql dm...
ER/Studio 19.3 General Availability
We are pleased to announce the general availability (GA) of IDERA ER/Studio 19.3 ER/Studio 19.3 delivers support for Google BigQuery. This allows...
How to automate nested JSON Data Extraction in 10 Simple Steps
If you’ve ever worked with data stored in JSON files, you probably know that extracting data from nested JSON files for processing can be...
Announcing the General Availability of SQL Workload Analysis 1.7.1
We’re excited to announce the release of SQL Workload Analysis 1.7.1 Problematic SQL queries can severely reduce the performance of SQL...
SQL Diagnostic Manager 12.0 General Availability
We are pleased to announce the general availability of SQL Diagnostic Manager 12.0. Existing users may upgrade to this version through the Idera...
Business Architect Support
Is Business Architect currently still being maintained/upgraded, other than to make it compatible with the latest version of Team Server? In looking...
Improve your recovery for SQL Server backup
Not having a good recovery process One big part of your backup process needs to include the recovery procedures. You should have a rehearsed...
ER Diagram: Model varchar(max)
Since length is required for varchar and there is no varchar(max) type, how do you model varchar(max)? ADS 22.1.3 Response Thomas Conrad 4 months...