Blog

Normalization is the process of refining a database to eliminate data redundancy and ensure data is stored logically. The process is related to the data modeling capabilities of ER/Studio and using them in tandem can result in more efficient databases across an organization.

SQL Diagnostic Manager for SQL Server is a valuable database monitoring tool. Attend an IDERA webinar on Tuesday, October 26, 20201 from 11 AM to 12 PM EDT to learn how to use the application to improve the performance of your SQL Server environment.

We’re excited to announce the General Availability of DB PowerStudio version 18.0 as the latest release of these powerful cross platform tools for database development, tuning and management. DBPS continues to expand its platform support, broad...

Universal Database GUIs provide a means to manage cloud, on-premises, hybrid and multi-platform environments from a single tool. A GUI for any database means lower licensing costs among other benefits.

Tuning MySQL databases for better performance can be challenging. Using these five tips and SQL Diagnostic Manager for MySQL gives DBAs a good chance of finding performance gains that lead to more responsive systems.

There are some upcoming sessions at IDERA live that should appeal to the SQL Server community. Register for these free webinars today!

Organizations should follow the following business glossary best practices - including the dos and don'ts of building business glossaries - to ensure they create a business glossary that adds value to the business.

SQL Compliance Manager can help teams stay ahead of regulatory auditors by conducting internal audits to ensure compliance. The tool enables teams to understand their position regarding compliance and produce documented evidence to satisfy external auditors.

SQL Server controls access to resources through locks on transactions. Identifying these locks so they can be addressed to improve performance requires a reliable monitoring solution like Precise for Databases.

The choice between open source and commercial database tools can be confusing. There are benefits with a commercial tool that negates any cost savings available through an open source solution. SQL Diagnostic Manager for MySQL is a good example of a robust commercial solution for monitoring.

The terms business glossary and data dictionary refer to two different artifacts used by data-driven companies to make more effective use of data and information. This post will look at the differences between these two entities and tools to synchro...

Slow SQL Server performance can impact business-critical systems and lead to dissatisfied customers and lost revenue. SQL Doctor provides an effective tool for improving the performance of physical, virtual, and cloud SQL Server database instances.

Third-party tools can help streamline the management of MySQL environments. SQLyog is a versatile and valuable addition to the toolbox of MySQL DBAs and developers.

Building a business glossary is an important facet of modern, data-driven business.  A business glossary is a bank of business terms recorded and defined using business user-friendly language.  Constructing business glossaries, and busines...

Integrated development environments (IDEs) are excellent tools for increasing team productivity. Aqua Data Studio is a multi-platform database IDE that gives DBAs and developers a flexible tool for managing their systems.

A business glossary is a valuable artifact for data-driven companies that enables them to use data assets more efficiently. ER/Studio provides the tools necessary to construct and manage business glossaries for more effective use of enterprise data.

Database backups demonstrate their true value when a system needs to be restored after a disaster or unexpected outage. SQL Safe Backup provides database teams with multiple restoration techniques that enable them to recover systems quickly and minimize any business impacts.

Do you need to manage and monitor your SQL Server environment for availability, health, performance, disaster recovery, security, and compliance? Join IDERA’s experts during interactive webinars to see for yourself how IDERA can help you keep y...

We are pleased to announce the general availability (GA) of IDERA ER/Studio 19.1 ER/Studio 19.1 is a minor release with some hotly anticipated new features. This release continues the journey to connect data architects closer to the data governance i...

Infrastructure monitoring is an important activity that helps organizations understand their current IT environment and plan for future capacity. Uptime Infrastructure Monitor provides a comprehensive monitoring solution that covers your complete environment.

Optimizing SQL queries is an important part of a DBA's job. DB Optimizer offers a tool to streamline the process and assist database teams in extracting the maximum performance from their systems.

There is high demand for MySQL DBAs to address the needs of data-driven businesses. This post outlines the steps required to become a MySQL DBA and how to use SQL Diagnostic Manager for MySQL to ensure optimal performance for your databases.

Using indexes correctly can provide greatly improved query performance. With an understanding of indexes and Aqua Data Studio, database teams can improve queries on over 40 different database platforms.

Always Encrypted is a feature of SQL Server that enhances the protection of data resources. Using this feature with SQL Secure lets database teams strengthen the security of valuable corporate data assets.