Latest Posts

  • Welcome to the SQL Server Query Store

    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.
    • 23 Oct 2020
  • You Need A Reliable Strategy for Protecting Data Resources

    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.
    • 21 Oct 2020
  • Who is Responsible and Accountable for a Data Breach?

    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…
    • 19 Oct 2020
  • Announcing The General Availability of DB PowerStudio 17.1

    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...
    • 19 Oct 2020
  • Do You Know How Many SQL Servers You Have?

    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.
    • 16 Oct 2020
  • Lessons Learned From 3 Years in the Trenches with AWS

    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...
    • 14 Oct 2020
  • What Are the Risks of Paying for Ransomware?

    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.
    • 14 Oct 2020
  • Why DBAs Need to Look for Trouble

    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.
    • 12 Oct 2020
  • The Best Way to Use Your Monitoring Software

    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…
    • 9 Oct 2020
  • Making Time Using Temporal Data

    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...
    • 7 Oct 2020
  • How to Secure Your SQL Servers from Internal Threats

    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
    • 7 Oct 2020
  • Oracle 19.7 on Linux and Oracle 19.8 on Solaris is supported in Precise 10.2

    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
    • 6 Oct 2020
  • Tips on How to Become a SQL Server Database Administrator

    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…
    • 5 Oct 2020
  • The Value of Consolidating Your Data Assets

    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.
    • 2 Oct 2020
  • Normalization Heuristics

    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 ...
    • 30 Sep 2020
  • Who Do You Trust with Your SQL Servers?

    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…
    • 30 Sep 2020
  • Why is MySQL So Popular for Website Development?

    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.
    • 28 Sep 2020
  • Boost Productivity with an IDE for Your Database Team

    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.
    • 25 Sep 2020
  • The EAV of Destruction

    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...
    • 23 Sep 2020
  • How to Monitor and Streamline SQL Server Jobs

    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.
    • 23 Sep 2020
  • How Data Governance Strengthens IT Security

    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.
    • 21 Sep 2020
  • Why You Need to Defragment Your SQL Server Indexes

    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.
    • 18 Sep 2020
  • All Skewed Up

    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...
    • 16 Sep 2020
  • Maintaining System Visibility in a Cloudburst

    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.
    • 16 Sep 2020