Blog

There are many ways to share files or SQL statements using Aqua Data Studio.  These range from shortcuts to your own file directories or company mapped drives, to shareable Aqua files, to popular native features within the menus and toolbars.&nb...

SQL queries are the primary mechanism to interact with databases. Therefore, ensuring that SQL queries perform well is essential. An important method to improve the performance of SQL queries is to use indexes properly to locate data quickly. To crea...

Today’s blog post concludes our four-part look into SQL performance and optimization. Part one introduced and explained relational optimization; part two reviewed query analysis and introduced single-table access path formulation; part three to...

Most people know that GDPR went into effect in May of 2018. For those of you who don't know, GDPR was put in place to protect people's PII (Personally Identifiable Information) Data.  This is the first holiday season with GDPR in effect, and add...

It seems like we hear about a new data breach on an almost daily basis.  This past week, we heard about two newsworthy data breaches that were caused/detected in some part by a Merger or Acquisition.  The first worth mentioning is the ...

Recently I was asked to contribute my thoughts on what things in database technology were a surprise in 2018 along with what trends and topics would be relevant in 2019.   You can read the full article here in Database Zone: Database 2018 S...

Successful solutions are successful solely because systems, users, and organizations have come to depend upon them. Such solutions are not necessarily successful because they were well crafted, intelligently designed, or adhere to any other theoretic...

In part one of our overview of SQL performance we examined relational optimization; part two took a look at query analysis and introduced single-table access path formulation. In today’s blog post, we move forward to look at the various methods...

Nearly all successful applications can benefit from the performance-driven strategies outlined in this whitepaper. Many of the categories and items discussed contain easy wins that can boost performance and scalability with far less effort than expec...

It can’t have escaped your attention that, in recent years, numerous new database platforms have been introduced on the market. Products such as Amazon Redshift, Apache Cassandra, Google BigQuery, and MongoDB are all new database products devel...

Microsoft markets a variety of SQL Server availability technologies under the umbrella term Always On. Always On is a broad term covers many features including things as simple as online index rebuilds and automatic page repair. The two main Always O...

In part one of our overview of SQL performance we examined relational optimization and the things that impact it. In today’s blog post, we turn our attention to query analysis and the ways that SQL gets turned into executable code. The optimiza...

Database professionals must handle many different tasks during the work day, ranging from creating queries and scripts to comparing and editing dataset results, just to name a few. Whether you’re a DBA or a developer, you may have some frequent...

Everyone makes mistakes. Database administrators are no exception to that rule. When database administrators make mistakes, they are often the ones who find it first and have to fix it. The trick to appear to never making mistakes is to get good at d...

Application developers must code efficient SQL and understand how to optimize SQL in order to develop efficient applications. But it is not just the programmer, but also the DBA who must understand SQL optimization. It is a joint responsibility and f...

We are pleased to announce the general availability of SQL Inventory Manager 2.5. Existing users may upgrade to this version through the IDERA Customer Portal. New users may download the trial version from the IDERA website. This release in...

Automated alerts are essential to performance monitoring. Automated alerts enable spotting issues in infrastructures, identifying their causes, and rapidly minimizing degradation and disruption of services. Alerts draw human attention to particular s...

IDERA is pleased to announce the introduction of IDERA SQL DM Performance Insights, a Microsoft Azure Data Studio (ADS) extension which displays key performance metrics for SQL Server that have been collected and stored in a database repository by ID...

Introducing the 2018-2019 Class of IDERA ACEs! We are excited to introduce our 2018-2019 class of IDERA ACEs! This program helps active members of the database and data modeling community share industry knowledge by sponsoring their travel for speaki...

One of the most overlooked powerful features in Aqua Data Studio is the Data Grid. The data grid can double your productivity with Data Management. No matter where the data resides, whether in a relational, cloud, document store, or an Excel source, ...

A solid data analysis process and capable tools are key components of a strong data professional's skill set.   Join IDERA (@Idera_Software) and host Chris Hyde (@ChrisHyde325) on Wednesday, November 28 at 11 AM CT for a community discussion on ...

Statistics, or “stats,” are fundamental components of SQL Server performance, but vastly under-appreciated and misunderstood. They are at the core of query optimization and can have a tremendous effect on query plan selection. The query o...

How many times have you been querying some data, or looking at a report, and asked yourself something like “Should I believe this data? I wonder where this data came from?” Well, what you are asking about is the lineage of the data. The M...

Howdy! In this short and concise blog post, I am really excited to be sharing on how to reverse engineer from ER/Studio via ODBC. For reverse engineering from ODBC check out this article. http://docwiki.embarcadero.com/ERStudioDA/171/en/Configuring_O...

"Data modeling is all about understanding the data within our organizations and then representing this data in a precise visual (the “data model”) which aids communication – saving time during development, saving money on support, a...