We all know that over time the tablespaces in our Oracle database(s) get fragmented. Database and application performance can suffer from this fragmentation.
Fragmentation happens when your applications are inserting, updating and/or deleting data. You…
Quest Software has established itself as a key player in data management, offering solutions that span the disciplines of data modeling, performance monitoring ,data and database replication, data catalogs, metadata management, data intelligence, data…
We're thrilled to announce the general availability of Foglight Cloud, a transformative solution reshaping how organizations manage and monitor their IT environment. Foglight Cloud…
The recent system glitch at Toyota offers a compelling lesson in the intricate dance between technology and business. When routine database maintenance went awry, the fallout was massive, halting 28 assembly lines across 14 plants. Over a span of 36 hours…
Once Foglight for Databases or Foglight for SQL Server has been installed, you’ll need to tell it what to monitor. Since Foglight doesn’t use any agents installed on the monitored systems, all you have to do is provide Foglight a SQL and Windows…
SharePlex® by Quest® was designed to address the HA/DR and horizontal scaling issues in Oracle databases. Building on this two-decade legacy, SharePlex for PostgreSQL now provides PostgreSQL database replication that solves many of these issues…
The results of the 2022 DBTA Readers’ Choice Awards are in and Quest® solutions have been named as winners and finalists in seven categories. We’re thrilled with the results but what means the most to us is that these awards were voted on by…
Database developers and DBAs have been using open-source databases, such as MySQL and PostgreSQL, for years. The platforms are mature, offer flexibility with low license costs and have a huge community following. Plus…
As part of most any database monitoring software evaluation, it includes comparing that software to similar solutions. Logically, it often means doing head-to-head comparisons to database tools that come bundled with that particular DBMS. Regularly, I…
The Database Trends and Applications (DBTA) magazine, a publication covering data operations and information management, big data and data science, has unveiled its 2021 Readers’ Choice Awards winners.
We are honored to announce that Quest Software…
In this article, we will explore when and how to use the SQL PARTITION BY clause and compare it to using the GROUP BY clause.
Database users use aggregate functions such as MAX(), MIN(), AVERAGE() and COUNT() for performing…
In this article, we will explore Postgres dates, the different date data types, uses and functions.
Date and timestamps are helpful for data analysis and storing data for checking when an event actually took place. For example, when you have purchase…
Patching, Upgrading or Migrating your Oracle Database can leave you feeling that you're in the midst of the same tornado that swept Dorothy into the Land of Oz; and you might run into some of the same characters as well. Here's how SharePlex, Quest's…
Just like most database environments, DEVintersection is going hybrid. Whether you’re joining DEVintersection from the comfort of your home this year or heading there in person, you won’t want to miss Quest®!
In this article, we’ll explore the different types of SQL tables and best practices for creating user-defined tables in SQL Server.
Tables are primary objects for storing data in relational databases. To visualize a table, consider an Excel spreadsheet…
This article will explain what database schemas are, their advantages and how to create and use schemas in SQL Server.
In a relational database management system such as SQL Server, the database contains various objects. These can be tables, stored procedures…
Data is a critical asset of every organization, and poorly-secured databases are too often to blame for security breaches. This article details SQL server security best practices, as well as essential security considerations for protecting your databases…
This article will cover Postgres indexes and the various index types supported.
Indexes play a vital role in the query performance of any relational database. The index provides feasibility to access the data pages directly. It is similar to an index…
In this article, we will cover the different methods for using the UPDATE from SELECT statement in SQL Server.
In the database world, static data is not typically stored. Instead, it keeps changing when we update existing data, archive or delete irrelevant…
In this article, we will cover the various Postgres data types and how they are used.
Relational databases organize data into tables, which are made up of rows and columns. Each table has one or more columns and each column has a specific assigned data…
In this article, we will explore using the different SQL CONVERT date formats within SQL Server.
Date interpretation varies between different countries. Suppose you have a global SQL Server database with a table that holds a specific date format. For…
How important is database performance tuning? Well, the world essentially runs on data (the business-focused parts of it, anyway). To ensure data is easily and quickly accessible, databases need to be running efficiently and be available at all times…
Data is at the heart of every modern enterprise, so maintaining database performance and ensuring data is quickly and easily accessible for those who rely on it is a key responsibility for database professionals.
With the rapid adoption of cloud database migration, many database professionals have concerns and questions regarding their futures and career prospects in database management. We recently had the opportunity to sit down with two industry veterans– Brent…
What does your company’s approach to database management look like? You should always have an answer to that question.
Suppose that, at the end of a conference call, someone from the executive leadership team asks you and your boss to stay on for…
