Browse By Tags

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…

Growth of open-source databases

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.

Understanding the Window function

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^®!

What can you expect from 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.

Overcoming common database performance…

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…

If anyone had any doubts that a panel discussion where Brent Ozar and Pinal Dave would be answering attendees’ SQL Server performance questions would be a success, those were quickly dispelled during the blockbuster Ask the Experts session Quest hosted…

With the landscape of the tech industry rapidly changing, the adoption of and adjustment to application and infrastructure management presents a major challenge. As a result, companies are increasingly expanding and relying on a mix of relational and…

Why is SQL performance tuning so important to database management?

Because it can save you money big time. Bear with me and you’ll see how.

SQL performance tuning and database management — Connecting the dots

Most database professionals spend…

Application deployments are often delayed when related database changes are required. That’s because it still follows a traditional waterfall process, which can result in high technical debt and code defects that can cause application downtime. …