• Are you an Accidental DBA? Quest has you covered!

    Accidental DBA?  What’s that?

    Are you an Oracle DBA?  Have you been asked to manage PostgreSQL or SQL Server databases?

    Or maybe you’re a SQL Server DBA now assigned to manage “that one Oracle database that supports a mission-critical application…

  • Celebrating the 25th Anniversary of SharePlex

    Celebrating the 25th Anniversary of SharePlex

    This post shares some highlights from the SharePlex 25th anniversary webcast that was held last month. In this celebratory webcast, five long-time Quest staffers shared their experiences in a round table discussion…

  • PostgreSQL — Your next database platform?

    As a database administrator, you’re probably known in your organization for your pragmatic approach to technology. Sure, it’s important to continually hone your skills, but when somebody comes up with a new application-question, it’s more important to…

  • Post up with Postgres v. 15!

    The PostgreSQL Global Development Group announced the release of Postgres version 15!

    Some of the notable feature enhancement additions include:

    1. Addition of the MERGE command - SQLServer and Oracle have had this command for some time now and its…

  • EnterpriseDB Postgres - Big Animal

    Wouldn't it be nice if we all had a big animal to handle our heavy lifting and workloads?

    Introducing, EnterpriseDB's fully-managed Postgres database in the cloud, Big Animal.

    -> Get pumped! <- (choose skip ad)

    The community spoke and EnterpriseDB…

  • Postgres v. 14 has been released and it is SCARY good!

    Postgres v. 14 snuck up on us and was released about a month ago.

    The community continues to kill it with advancements in innovation.

    Have a look at these frighteningly powerful enhancements and additions.

    JSON:

      

    PostgreSQL 14 now supports the syntax…

  • Exploring Postgres Date Formats and Their Different Functions

    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…

  • A Guide to Using Postgres Indexes

    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…

  • Exploring the Various Postgres Data Types

    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…

  • Key Methods for Creating Postgres Tables

    In this article, we will explore what a Postgres table is, its function and the various methods for creating tables in PostgreSQL.

    PostgreSQL or Postgres is a popular relational, object-oriented and open source database system. It runs on Windows, Linux…

  • A Review of Postgres version 12

    Postgres version 12 is here. Did you miss its introduction like me? My excuse is the year-end holidays (what's yours?). 

    Well, version 13 isn't planned for release until the fall, so there's plenty of time to brush up on v.12

    To give the nod…

  • Can you believe this Administration?!

    What’s that you say? You think it may not be appropriate that a technology blog dive into politics?

    Agreed. Instead, this blog highlights the breadth of Administration capabilities available in Foglight for Postgres.

    Administration options are available…

  • Postgres, Postgres....read all about it!

    Have you heard the news? PostgreSQL has earned the prestigious 'DBMS of the Year' award by DB-Engines!

    **(Postgres won in 2017 as well!)

    Who is DB-Engines (.com)?

    Solid IT, an Austrian IT consulting company, created and maintains DB-Engines. Solid…

  • "These go to eleven"

    PostgreSQL has entered an exciting new chapter with the release of version 11 (10/18/18). This blog highlights some of the version 11 additions and improvements to PostgreSQL.

    ** The information shared in this blog was largely gathered from the postgresql…

  • PostgreSQL Anxiety? Three Truths I Wish Someone Would’ve Told Me

    Adopting PostgreSQL is not unlike adopting a crazed monkey: It’s new. It’s exciting. It’s also downright terrifying.

    You’ve got questions.

    What if I can’t handle it? How hard will it be to get it to perform well? Will it look…

  • Monitor Postgres Disk Space Usage with Foglight

    Many things can happen if the database runs out of disk space. None of them are good. DBAs understand that it is essential to monitor database disk space so that critical business processes are uninterrupted. Quest’s Foglight provides peace of mind by…

  • Optimize Postgres Query Performance with Foglight

    One of the primary tasks of any DBA is to find and optimize poorly performing queries. This is not a trivial job as often times there is too much data to sort through and pinpoint problems. Quest’s Foglight provides alerts for Postgres queries that have…

  • Monitoring and Managing Locks in Postgres with Foglight

    One of the most valuable capabilities of Postgres is its support for concurrent ACID transactions. ACID is an acronym for Atomicity, Consistency, Isolation, and Durability. These database transaction properties help verify data validity. It is important…

  • Monitor Postgres Post-Haste with Foglight

    First, a brief introduction….

    Formally named PostgreSQL (and pronounced  /ˈpoʊstɡrɛs ˌkjuː ˈɛl/), it is an object-relational database management system with roots from the Ingres project at the University of California, Berkeley. PostgreSQL is open…