Database Management

In my earlier blog, we discussed various business uses for turning Oracle database transactions into “business events”, and how SharePlex can be used to capture Oracle Change Data and write that data to a Kafka message queue. Confluent h...

Don’t miss this opportunity to get SQL Server performance tips from two of the leading experts in the business.

Quest’s data operations solutions were named “Best Solution” in 5 categories by the DBTA 2021 Readers’ Choice Awards. Learn more about each of them here.

As more and more Oracle users upgrade their databases to Oracle 19c and beyond, posts on the Oracle community mailing lists about changes in query performance are increasing.  In most cases, users are seeing improved performance; but, as Scotty ...

In my last blog, we discussed various business uses for turning Oracle database transactions into “business events”, and how SharePlex can be used to capture Oracle Change Data and write that data to a Kafka message queue. In this blog, w...

Learn when and how to use the SQL PARTITION BY clause in SQL Server and how it differs from the GROUP by clause.

Likely the reason your college or university implemented an ERP System(s) was to improve and reduce the cost of core business process such as managing CRM activities such as student prospecting, onboarding, registration, and retention.  Of cours...

Learn the different Postgres date formats and functions available.

Oracle and other relational databases are perfect for storing “transactions”, the results of interactions between people or systems.   For example, when a customer purchases a widget from our store, we may need to perform the fo...

Constraints in SQL Server are predefined rules that you can enforce in single or multiple columns. Learn the different types and benefits for using them.

Learn what data democratization is, why it’s important and how it gives users a 360-degree view of data so they can make timely decisions.

Streams is Gone If you're a current Oracle Streams user looking to upgrade to Oracle 19c, you already know that as of this release, Oracle has removed Streams.   So, there are choices to be made.  You can Change your processes and app...