Latest Posts

  • DBArtisan Tips

    Welcome to the DB PowerStudio Blog. This blog will cover all things about DB PowerStudio. DBArtisan is one part of the suite of tools known as DB PowerStudio. The September edition of DBArtisan tips and techniques covered three tips fo...
    • 23 Sep 2019
  • Why You Should Choose MySQL as Your Database Platform

    There are many choices when it comes to the database with which you will entrust your company's important information. MySQL is an excellent solution that is widely popular for a variety of reasons.
    • 23 Sep 2019
  • Real Benefits of a Unified Database Management Solution

    Multi-platform database environments pose challenges to DBA productivity. The unified solution presented by Aqua Data Studio enables database professionals to save time and be more productive when working with multiple different database instances.
    • 20 Sep 2019
  • Protecting Your MySQL Servers From Ransomware

    Ransomware is a very destructive form of malware that is used to obtain financial gain by encrypting an organization's data and demanding ransom to unencrypt it. MySQL is not immune to this type of attack. Monitoring your MySQL databases can help you defend against ransomware attacks.
    • 19 Sep 2019
  • How to properly set up SQL Server clusters

    Windows Failover Clustering can keep your SQL Server databases online and your end users happy when hardware or operating system problems strike. When equipment fails, Windows Failover Clustering is a high technology that can keep SQL Server instance...
    • 18 Sep 2019
  • Problems That Influence Efficient Enterprise IT Management

    Managing your IT environment is a critical part of maintaining and optimizing your systems. It also offers the opportunity to perform capacity planning by identifying trends in usage that need to be addressed to handle future growth. Uptime provides a platform for effective enterprise IT management.
    • 18 Sep 2019
  • Addressing the Pain Points of Big Data

    Handling the volume of big data can be challenging for any organization. Data governance provides a framework with which to understand, manage, and use this data throughout an enterprise. ER/Studio Enterprise Team Edition is great tool for building a data governance foundation.
    • 17 Sep 2019
  • Protect Your Databases From Password Attacks

    Hackers employ many techniques trying to obtain unauthorized access to corporate data. Password attacks are one of their primary tools. SQL Secure can help you keep your SQL Server instances safe from intrusion by identifying weak passwords and incorrect group membership.
    • 16 Sep 2019
  • A One-Stop Solution to SQL Coding Problems

    Coding SQL queries and statements for multiple database platforms can be challenging. Rapid SQL offers many features that streamline your coding efforts and enable you to be more productive.
    • 13 Sep 2019
  • Why Would You Want to Reverse Engineer a Database?

    Reverse engineering can be a powerful tool and can be used in many ways. One way is to create ER models from existing databases. Aqua Data Studio gives you the capability to easily create ER models and diagrams from databases on many different platforms.
    • 12 Sep 2019
  • Effectively Conquer Ransomware Attacks With Database Backups

    Ransomware can cripple your business. Often the only remedy for an attack is to recover your systems from valid backups. SQL Safe Backup helps DBAs maintain backups that can quickly restore your systems and keep your business running.
    • 11 Sep 2019
  • MySQL Security Basics

    Full security requires security of the network, hosts, databases, and applications. Most of these are the same, regardless of which database vendor you are using. However, if you’re using MySQL for the first time, there are some differences in ...
    • 10 Sep 2019
  • Manage SLAs Effectively and Save Your Company Money

    Failure to meet service level agreements (SLAs) can be costly for a business. Uptime Infrastructure Manager offers an SLA management platform that can help save your business money by meeting its SLAs.
    • 10 Sep 2019
  • What are the MySQL Metrics That Really Make a Difference?

    MySQL offers many metrics with which a DBA can monitor their databases and diagnose problems. Some metrics are more informative than others and should be where you look first when issues strike. SQL Diagnostic Manager for MySQL enables you to fully monitor your system's metrics.
    • 9 Sep 2019
  • Elevated Privileges Can Cripple Your Business

    Elevated privileges are one of the causes of data breaches. The privileges could have been obtained illicitly or been assigned inadvertently. SQLyog can help manage your MySQL users and minimize the risks of elevated permissions.
    • 6 Sep 2019
  • What are MySQL Database Engines?

    If you’re new to MySQL, you’ve probably run into a term you haven’t seen before: Database engines. Database engines (also called “storage engines”)` are simply different ways of storing data. Different engines offer vari...
    • 6 Sep 2019
  • Using Collaboration For a Competitive Advantage

    Collaboration is a vital strategy for businesses that want to remain competitive in today's marketplace. Concepts and tools such as data governance and ER/Studio Enterprise Team Edition can help any organization achieve more benefits from their collaborative efforts.
    • 5 Sep 2019
  • How to Provide Compliance Evidence to Auditors

    Providing the evidence to prove compliance is a key factor in passing an audit. SQL Compliance Manager makes it easy for DBAs to generate reports that demonstrate the compliance of their systems.
    • 4 Sep 2019
  • Using MySQL SHOW Commands for Performance Monitoring

    MySQL SHOW Commands Different database vendors provide different ways of querying the engine to determine status, sessions, configuration, and other important information. With Microsoft’s SQL Server, this is done with the “dynamic manage...
    • 4 Sep 2019
  • Generate Increased Stakeholder Confidence with Visual Data

    The visual presentation of data makes it more accessible to diverse groups with different levels of experience regarding the information in question. Aqua Data Studio offers a comprehensive tool for creating data visualizations from many different database sources.
    • 3 Sep 2019
  • The Benefits of Complete Root Cause Analysis

    Resolving IT problems often calls for a root cause analysis to be performed to identify the underlying factors that contributed to the issue. Precise can help your database team quickly find the cause behind an issue.
    • 3 Sep 2019
  • Avoid These Critical DBA Mistakes and Save Your Job!

    Mistakes are an unavoidable part of an IT professional's work life. Some of these errors are so serious that they can lead to the loss of your job. We discuss some of the mistakes that need to be avoided by DBAs if they intend to stay gainfully employed.
    • 30 Aug 2019
  • Data Governance and Data Maturity

    I have written previous blog posts on the topics of Data Governance and Data Maturity, and although these two topics are related, the former typically gets the most visibility within an organization. As volumes of data grow, the need for precise, acc...
    • 29 Aug 2019
  • A Unified Dashboard Results in Increased Monitoring Efficiency

    IT system monitoring is a critical part of maintaining availability and providing performance to your users. Uptime Infrastructure Monitor employs a unified dashboard that will make your monitoring efforts more efficient.
    • 29 Aug 2019