Blog

The use of an integrated development environment or IDE can increase the productivity of a database team in m multiple ways. Aqua Data Studio offers an IDE that supports over 30 different database platforms from a unified interface.

EAV (“Entity-Attribute-Value”) tables result from a very common schema design error for programmers who started with an OO language, and now work with NoSQL (attribute, value) pairs or a loosely typed programming language. This one schema...

The SQL Server Agent provides the opportunity to automate repeatable tasks to aid the productivity of database teams. IDERA's SQL Enterprise Job Manager can help tame the complexity that can arise from multiple server instances and their SQL Server Agent jobs.

Securing sensitive data is a complicated task that has to be addressed by organizations that collect and store it. ER/Studio can help institute data governance which can you understand, structure, and manage your mission-critical information.

Index fragmentation can slow down your SQL Server response time. SQL Defrag Manager provides a tool for automating the process of defragmenting indexes and keeping systems running smoothly.

Data can be skewed by its nature. How can you tell if you have skewed data in your database? And if you do, how do you handle it when writing queries? Mitigating skewed data is hard and not obvious. There is no magic formula, just a few tricks that h...

Cloud bursting is a way to use the resources of the public cloud to augment your on-premises or private cloud environment. SQL Diagnostic Manager for SQL Server lets your database team monitor your SQL Servers wherever they are located.

Protecting your network is an essential component of a viable security initiative. The first indication that your network has been comprised may be the degradation of normal services or an abnormality in the use of a particular segment.

Hackers never stop trying to come up with creative ways to steal your data. SQL Safe Backup protects your valuable information in the event of a successful attack from an advanced persistent threat or other types of malware.

Dr. Codd’s original relational algebra had eight basic operations. Since relational database management systems are based on set theory, the first four are traditional set operations: intersection, set difference, union, and product. These oper...

We are pleased to announce the general availability (GA) of IDERA ER/Studio 18.4 ER/Studio 18.4 contains core product support for the Snowflake database in both Data Architect and Team Server. Customers using this database platform will benefit ...

A combination of proven security measures and attentive monitoring is required to keep MySQL databases secure. SQL Diagnostic Manager for MySQL gives you insight into your systems that you need to identify security issues or suspicious behavior.

Choosing the right tool for the job is an essential part of achieving optimal performance. DB Optimizer is a versatile tool for tuning SQL statements on a variety of database platforms to help you improve system response time.

Collaboration is an essential component of enterprise data models. ER/Studio Enterprise Team Edition gives organizations a collaborative tool with which to create data models that address business needs.

Analytics for big data rapidly has become indispensable for nearly all clinical and operational processes in the healthcare industry. Such functions include support for clinical decisions, predictive analytics for big data, management of revenue cycl...

Many of the administrative tasks required to keep databases operating efficiently need to be performed regularly. While in some respects, these activities can become routine and mundane for the administrative team, they are nevertheless vital for the...

Aqua Data Studio can help DBAs become more productive by allowing activities to be performed on multiple platforms from a unified interface. IDERA provides an instructive webcast that highlights how Aqua Data Studio can help with SQL Server and Oracle systems.

DBAs can always use some new information regarding how to tune their SQL Servers. An IDERA webcast provides expert tips on how to improve SQL Server performance and how to use SQL Diagnostic Manager for SQL Server to identify the queries that need tuning.

Data migrations are complex undertakings that require extensive planning and the right tools in order to be successful. DBArtisan can be a valuable tool when migrating data between database platforms or to different databases within a server.

Microsoft has introduced a new model for deploying SQL Server Integration Services (SSIS) packages into SQL Server 2012. Prior to releasing this new model, the locations to store SSIS packages were to deploying SSIS packages to: a directory on the f...

The promise inherent in new paradigms can often be the impetus for making major decisions in the business world. Companies want to take advantage of any perceived method of becoming more productive and gaining a competitive edge over their rivals. A ...

Data breaches can be devastating to affected organizations and individuals. There are multiple steps that entities involved in a data breach should take to mitigate the damage. SQL Compliance Manager can help keep your SQL Server environment safe from unauthorized use of your data assets.

The Internet of Things (IoT) is the term used to describe the connection of network-capable devices to the Internet and other connected devices. The equipment that makes up the IoT go far beyond the computers that were connected to form the consumer ...

Analytics is a valuable tool with which an enterprise can obtain an advantage over its competitors. Aqua Data Studio offers database teams a valuable tool for conducting data analytics on a wide variety of database platforms.