As businesses and government organizations shift a growing amount of their operations online, data security has become an increasingly important...
How to Maintain Security Compliance to Prevent a Costly Breach
read more
SQL
Announcing the General Availability of SQL Compliance Manager 6.0
We’re excited to announce the release of SQL Compliance Manager 6.0 SQL Compliance Manager is the industry leading SQL Server auditing solution that...
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...
Get Historical SP and Query Statistics
I want to retrieve the slow queries and Stored procedures from the Idera database(without using the UI Application --- i want to do it...
General Availability of Aqua Data Studio, Version 22.0!
Aqua Data Studio is the industry leading multi-platform Database Integrated Development Environment (IDE) with Visual Analytics. Data and...
Improve ETL Performance by Disabling Non-clustered Indexes
Perhaps you just read the title and thought, “Disable indexes…say what?” Stay with me here, and I'll show you how this...
The Most Surprising SQL Antipattern We Use
Do you like hammering nails with screwdrivers? Me neither, but all too often we take this kind of approach when writing our SQL queries. We use the...
update multiple tables using joins
I am trying to update table1 based on common data between table1 and table2. But I am receiving the error:update table1 set A.ORG_NAME = @ORG_NAME,...
A Tool for Creating More Efficient SQL Code Quickly
Information technology has become one of the most important manifestations of society’s technological advancements. IT systems are widely used...
Announcing General Availability of Aqua Data Studio 20.6!
On behalf of the entire Aqua Data Studio team, we’re excited to announce the release of Aqua Data Studio version 20.6 with Enhancements in the...
date difference in months calculation should be simple and just by one function.
The current Postgresql provides calculation to find date difference in months by getting (year difference * 12 )+ Months difference. This...
Aqua Data Studio 20.5 General Availability
Idera is excited to announce Version 20.5 of Aqua Data with major Enhancements in the following areas. Platform support now includes Amazon RDS...
Announcing the GA Release of SQL Safe Backup 8.6
We are pleased to announce the general availability of SQL Safe Backup 8.6. IDERA SQL Safe Backup provides a mission-critical backup and recovery...
DBArtisan Tips and Tricks Webinar November 2019
The November edition of DBArtisan tips and techniques Webinar covered three tips for using DBArtisan. Using Projects to organize your work...
*runscript-bundled.bat* file do not export any data when the data is greater than around 115mb
Response aniltexascowboy over 3 years ago Hi Toni, You will need to increase the XMX values in both the run-bundled.bat to atleast 5-6 gigs of...
A One-Stop Solution to SQL Coding Problems
A One-Stop Solution to SQL Coding Problems One of the challenges a DBA must deal with on a daily basis is negotiating the multiple database...
Announcing the General Availability of SQL Safe Backup 8.5.2
We are pleased to announce the general availability of SQL Safe Backup 8.5.2. Existing users may upgrade to this version through the IDERA Customer...
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...
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...
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....
Sharing Files and SQL statements using Aqua Data Studio
There are many ways to share files or SQL statements using Aqua Data Studio. These range from shortcuts to your own file directories or...
SQL Performance, Part 4: Additional Considerations
Today’s blog post concludes our four-part look into SQL performance and optimization. Part one introduced and explained relational...
SQL Performance, Part 3: Multiple Table Access Methods
In part one of our overview of SQL performance we examined relational optimization; part two took a look at query analysis and introduced...
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...