Featured Blog
Announcing the General Availability of SQL Secure 4.2
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...
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...
Aqua data studio – visual analytics
Hello, I am using aqua data studio visual analytics for visualization of some data. I have build multiple worksheets which are using same sql...
Announcing General Availability of DB PowerStudio, version 18.2
IDERA’s DB PowerStudio provides a powerful cross-platform toolset for database development, tuning and database management. What's new in DB...
Is ER/Studio Data Architect really the best data modeling tool?
Data modeling tools should be competent at the basics of database modeling. They should be able to create logical and physical data models,...
Announcing the General Availability of Aqua Data Studio, Version 22.2!
Aqua Data Studio is the industry leading multi-platform Database Integrated Development Environment (IDE) with Visual Analytics. Data and...
Announcing General Availability of SQL Inventory Manager 2.6.3
We’re excited to announce the release of SQL Inventory Manager 2.6.3 Database administrators need a simple, efficient way to discover, document, and...
Organizing Chaos with PSWorkItems and PowerShell
I spend my working days living in a PowerShell console. Over the years, I’ve developed many PowerShell modules to help me manage the chaos that is...
Announcing the GA of SQL Enterprise Job Manager 2.4
We’re excited to announce the release of SQL Enterprise Job Manager 2.4 SQL Enterprise Job Manager is an industry leading monitoring, scheduling and...
Announcing the General Availability of SQL Secure 4.1
We are pleased to announce the general availability of SQL Secure 4.1 SQL Secure is the industry-leading, state of the art auditing and security...
Infor Compass JDBC Driver / Infor Compass JDBC Driver.ionapi
Does anyone have an example of setting up a ADS server using the Infor Compass JDBC Driver and their oAuth file(Infor Compass JDBC Driver.ionapi)?...
Communication Link failure
I'm using the latest version of Aqua Data studio and have created a connection to a remote MySQL server. Everything was fine a week or so...
Incorporating compound IF THEN ELSE ELSE statements using query builder functions?
Haven't tried this before, but I'm trying to idiot proof a set of query's and make the held values understandable by the end user while utilizing...