Aqua Data Studio is the industry-leading multi-platform Integrated Development Environment (IDE) for databases with Visual Analytics. This...
SQL
Why Data Model? Part 5: We Data Model to be Smart
Author This blog post was authored by Todd Schraml. Always Normalize Logical Data Models The logical data model reflects the common language of the...
SQL Server Alert Management: From Chaos to Clarity
Author This blog post was authored by Pinal Dave from SQLAuthority. Introduction In the fast-paced world of database administration, staying ahead...
Navigating SQL Server CPU and Memory Usage Woes
Author This blog post was authored by Pinal Dave from SQLAuthority. Introduction Microsoft SQL Server is a powerful database management system, but...
Making the Most of Historical Data: Preventing Future SQL Server Issues
Author This blog post was authored by Pinal Dave from SQLAuthority. Introduction Forecasting future SQL Server performance issues can often feel...
How to Maintain Security Compliance to Prevent a Costly Breach
As businesses and government organizations shift a growing amount of their operations online, data security has become an increasingly important...
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...