Blog

The Query Store is a feature of SQL Server that is extremely useful for performance tuning. Combined with SQL Diagnostic Manager for SQL Server, you can identify the queries that are leading to degraded database performance.

Your important SQL Server environment can be affected by many factors that lead to unexpected downtime. This makes it imperative that you have a reliable backup and recovery plan that can get your systems back up quickly. SQL Safe Backup is a great tool to help you reach that goal.

There is a new trend emerging that may hold corporate executives criminally liable for mishandling data breaches and the notifications that they require. Protecting your SQL Server environment with SQL Compliance Manager will help minimize the chances of a data breach involving sensitive and personal…

We are excited to announce the release of DB PowerStudio 17.1 with enhancements and improvements  in the following areas.   New Functionality We have added Support for Azure Active Directory This will allow customers to take advantage of...

Not knowing how any SQL Servers you have can be a problem for several reasons. SQL Inventory Manager can help you address the server sprawls that often accompanies SQL Server environments, especially those that include cloud instances.

Since the time of our founding, IDERA has been using Amazon Web Services (AWS). It was critical to us to use cloud technologies to build our product, as it too would be running in the cloud. Before deciding on AWS, we evaluated many different cloud t...

Paying the demands of cybercriminals in the wake of a ransomware attack may seem like the best way to regain access to data resources. Backups are a more reliable method of recovery and have the added benefit of reducing the further incidence of this type of attack by making them unprofitable.

SQL Diagnostic Manager for SQL Server is an effective tool for DBAs looking for trouble that they can address to improve their SQL Server environment. It can help discover issues with your SQL Servers so they can be addressed proactively.

Uptime Infrastructure Monitor is a full-featured monitoring solution that enables you to keep an eye on your whole computing environment from a unified interface. Watch a video demonstration of how easy the tool is to set up and deploy and the flexibility with which you can set monitoring baselines…

SQL is the first programming language with temporal data types. The SQL-92 standard added temporal data to the language, acknowledging most of what was already in most SQL products by that time. The problem is that each vendor made a trade-off intern...

Threats to sensitive enterprise data come from both outside and inside an organization. SQL Compliance Manager helps you identify where sensitive data resides and allows you to monitor and audit its use to guard against unauthorized access

Precise 10.2 now supports the latest Oracle 19C patches for Linux and Solaris. Linux Oracle 19.7 on Linux is now supported in Precise 10.2

The popularity of SQL Server makes it a logical choice for individuals interested in a career as a DBA. There are definite steps that can be taken to attain this goal. Read an informational IDERA whitepaper to see how you can obtain the needed skills and then take a look at SQL Diagnostic Manager for…

ER/Studio Data Architect can help database teams with the task of merging or consolidating databases. It can be used to reverse engineer and create logical and physical models that enable intelligent choices to be made during database consolidation.

Heuristics and normalization are the goals of all databases. Heuristics refers to a trial-and-error method of problem-solving used when an algorithmic approach is impractical. Normalization refers to removing redundancy from a database schema and to ...

Protecting data resources thoroughly requires the combination of a viable strategy and the right tools. Zero Trust is a security methodology that demands all internal and external data access can only be trusted after their authorization is verified. SQL Secure can help implement this security model…

MySQL is a very popular database solution and is widely deployed on eCpmmerce sites due to its scalability and security. SQL Diagnostic Manager for MySQL provides database teams with a comprehensive tool that can keep their MySQL environment running at peak efficiency.

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.