Blog

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.

Data governance is an important technique used by businesses to make the most effective use of enterprise data resources. This can be especially critical in the healthcare field. ER/Studio provides the building block necessary to construct a strong foundation for a data governance program.

In modern business, database administrators (DBAs) need to identify and address MySQL database performance issues quickly.  Failure to do so can have disastrous effects on an organization. Database monitoring is a technique that can be instrumen...

Problems with database transactions can slow performance to a crawl. Precise for Databases enables DBAs to monitor and tune transactions to maintain optimal performance and customer satisfaction.

The ability to quickly identify database changes can help database administrators address unexpected outages or performance issues. DB Change Manager provides an excellent tool for managing and tracking database changes on multiple platforms.

Building and analyzing SQL queries is a common task of database administrators and developers. Aqua Data Studio offers query building, editing, and analyzing features that support a wide variety of database platforms from a unified interface.

Developing a data governance policy helps define the elements required to implement data governance successfully. The ER/Studio family of data modeling solutions assists teams in creating the foundation of a viable data governance program.

Do you need to manage 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 your SQL Serv...

Ultimately a data migration to the cloud is a technical exercise – we will use technical tools to move data to a cloud-based destination. That said, there are two keys to a successful data migration project that are non-technical, but critical ...

Fragmentation is a database performance killer. implementing an automated defragmentation process with SQL Defrag Manager will help keep your databases performing optimally.

Database profiling can identify areas that need to be tuned for optimal performance. DB Optimizer can perform activities like wait-time analysis to find the bottlenecks in multiple relational database platforms.