Latest Posts

  • 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
  • Network Security is Your First Line of Defense

    Protecting your network is an essential component of a viable security initiative. The first indication that your network has been comprised may be the degradation of normal services or an abnormality in the use of a particular segment.
    • 14 Sep 2020
  • New and Persistent Threats to Your SQL Servers

    Hackers never stop trying to come up with creative ways to steal your data. SQL Safe Backup protects your valuable information in the event of a successful attack from an advanced persistent threat or other types of malware.
    • 11 Sep 2020
  • Relational Division

    Dr. Codd’s original relational algebra had eight basic operations. Since relational database management systems are based on set theory, the first four are traditional set operations: intersection, set difference, union, and product. These oper...
    • 10 Sep 2020
  • We are pleased to announce the general availability (GA) of IDERA ER/Studio 18.4

    We are pleased to announce the general availability (GA) of IDERA ER/Studio 18.4 ER/Studio 18.4 contains core product support for the Snowflake database in both Data Architect and Team Server. Customers using this database platform will benefit ...
    • 10 Sep 2020
  • Secure Your MySQL Databases with These Best Practices

    A combination of proven security measures and attentive monitoring is required to keep MySQL databases secure. SQL Diagnostic Manager for MySQL gives you insight into your systems that you need to identify security issues or suspicious behavior.
    • 9 Sep 2020
  • The Right Tools Makes All the Difference

    Choosing the right tool for the job is an essential part of achieving optimal performance. DB Optimizer is a versatile tool for tuning SQL statements on a variety of database platforms to help you improve system response time.
    • 8 Sep 2020
  • The Business Benefits of Collaborative Data Models

    Collaboration is an essential component of enterprise data models. ER/Studio Enterprise Team Edition gives organizations a collaborative tool with which to create data models that address business needs.
    • 4 Sep 2020
  • How can you handle the complexities of analytics for big data for healthcare?

    Analytics for big data rapidly has become indispensable for nearly all clinical and operational processes in the healthcare industry. Such functions include support for clinical decisions, predictive analytics for big data, management of revenue cycl...
    • 3 Sep 2020
  • What are the real benefits of database automation?

    Many of the administrative tasks required to keep databases operating efficiently need to be performed regularly. While in some respects, these activities can become routine and mundane for the administrative team, they are nevertheless vital for the...
    • 2 Sep 2020
  • An Efficient Solution for Multi-Platform Environments

    Aqua Data Studio can help DBAs become more productive by allowing activities to be performed on multiple platforms from a unified interface. IDERA provides an instructive webcast that highlights how Aqua Data Studio can help with SQL Server and Oracle systems.
    • 2 Sep 2020
  • SQL Server Tuning Tips You Need to Know

    DBAs can always use some new information regarding how to tune their SQL Servers. An IDERA webcast provides expert tips on how to improve SQL Server performance and how to use SQL Diagnostic Manager for SQL Server to identify the queries that need tuning.
    • 31 Aug 2020
  • Best Practices for a Successful Data Migration

    Data migrations are complex undertakings that require extensive planning and the right tools in order to be successful. DBArtisan can be a valuable tool when migrating data between database platforms or to different databases within a server.
    • 28 Aug 2020
  • What do you need to know about the SQL Server Integration Services (SSIS) catalog?

    Microsoft has introduced a new model for deploying SQL Server Integration Services (SSIS) packages into SQL Server 2012. Prior to releasing this new model, the locations to store SSIS packages were to deploying SSIS packages to: a directory on the f...
    • 27 Aug 2020
  • What do you need to consider when moving databases out of the cloud during cloud repatriation?

    The promise inherent in new paradigms can often be the impetus for making major decisions in the business world. Companies want to take advantage of any perceived method of becoming more productive and gaining a competitive edge over their rivals. A ...
    • 26 Aug 2020
  • Surviving the Damages of a Data Breach

    Data breaches can be devastating to affected organizations and individuals. There are multiple steps that entities involved in a data breach should take to mitigate the damage. SQL Compliance Manager can help keep your SQL Server environment safe from unauthorized use of your data assets.
    • 26 Aug 2020
  • Is your organization ready for the Internet of Things (IoT)?

    The Internet of Things (IoT) is the term used to describe the connection of network-capable devices to the Internet and other connected devices. The equipment that makes up the IoT go far beyond the computers that were connected to form the consumer ...
    • 25 Aug 2020