Blog

Using data models is an effective method when designing or migrating databases. ER/Studio Data Architect is a valuable tool that helps your database team create data models on a wide variety of platforms.

There are several examples where data theft has brought organizations to a halt or resulted in a bad press that will leave a tarnished image. For example, in 2017, Equifax disclosed that the personal information for over 145 million people was expose...

SQL Server database administration is difficult; queries and indexes require tuning in response to application changes. For many database administrators, change is regular; change happens after a development cycle with testing phases and a careful ro...

Business intelligence can dramatically improve the ability of decision-makers to make the correct choices. SQL Server includes features designed to provide BI for its users. SQL BI Manager keeps your SQL Server BI components running smoothly and delivering results.

We are excited to announce the release of SQL Compliance Manager 5.8. SQL Compliance Manager is the industry leading SQL Server auditing solution that dramatically lowers the cost for companies to maintain database compliance standards...

Cloud computing services offer many advantages for companies or organizations that make use of them. There are often financial incentives involved in cloud migrations, as the provider’s ability to use an economy of scale solution results in cos...

Tuning configuration parameters and monitoring database activity are two ways of improving MySQL performance. An IDERA whitepaper with suggested tuning activities combined with SQL Diagnostic Manager for MySQL will enable your database team to optimize the MySQL database environment.

Today, organizations are about data. Database systems and the elements they store are arguably the most valuable assets in any given enterprise. Not only are executives and IT leaders responsible for doing what is right to protect the best interest o...

Putting together the right team is an important component of a data governance program. Once the team has been assembled, ER/Studio Enterprise Team Edition is an excellent collaborative tool that facilitates building a strong foundation for data governance efforts.

The executable process that is the SQL Server Database Engine is called the Database Engine service. The Database Engine service is an executable program that runs as a Windows service that can continuously operate without displaying any activity on ...

Windows Failover Clustering can keep your SQL Server databases online and your customers happy when hardware or operating system problems strike. Failover Clustering also makes your life easier when you need to do maintenance on a physical server: ju...

Index fragmentation can drag down database performance and result in long-running queries. SQL Defrag Manager lets you automate the defragmentation process for your SQL Server environment so it performs at peak efficiency.

Understanding how SQL Server can be infiltrated is the key to understanding how to prevent intrusions. The consequences for inadequate permissions are tremendous. Organizations could incur data breaches, fines, loss of customers, decrease in customer...

There are often multiple ways that data can be presented. Choosing the right format can make information more accessible to your audience. Aqua Data Studio provides a tool to access data from diverse platforms and display it in the best format for any situation.

Capacity planning is essential for businesses that want to stay ahead of evolving demands. Uptime Infrastructure Monitor gives your team tools that assist in understanding the capacity of your current resources so you can plan for the future more effectively.

The reliance on digitally stored information continues to grow and now dominates society in the 21st Century. The use of the Internet for business and information exchange shows no signs of slowing down or returning to the good old days of cash trans...

SQL Server provides robust capabilities to monitor itself, and it can be easy to be overwhelmed with the choices presented through catalog or dynamic management views, extended events, server-side traces (for older versions of SQL Server), or perform...

Data breaches are a big problem for organizations that collect and store sensitive and personal information. SQL Secure helps you minimize the risk by providing a full-featured tool for hardening the security of your SQL Servers.

The security of any database can be improved. However, that likely degrades the performance of the database. The cost increases to improve database security while maintaining database performance. That is, the trade-off consists of three axes: Perfor...

You don't want your organization paying for unnecessary SQL Server instances scattered throughout your environment. SQL Inventory Manager can help control SQL Server sprawl and minimize the financial and productivity impacts of hosting extra database instances.

Consistency in the tools and processes you use can help increase your productivity. Aqua Data Studio offers a flexible and versatile tool that allows you to perform many tasks on a wide variety of databases from a unified interface, increasing the productivity of your database team.

Databases are vitally important to modern businesses across all market sectors. They are the repository of an organization’s information resources which are essential assets used to run its business and gain an edge over its competitors. Big da...

SQL Server health checks have garnered a great deal of notoriety over the last five years. What was originally a niche offering more than ten years ago has evolved into a mainstream must-have for the SQL Server community. A health check should: (1) V...

Creating viable data models can be instrumental in allowing organizations to make full use of their data resources. ER/Studio tools offer teams multiple solutions with which to create the types of models that benefit their business.