Migrating databases from Oracle to SQL Server can be challenging, particularly when character sets between the two systems differ. Mismatched character sets can lead to data loss, corruption, or issues with character encoding. In this blog, we'll explore…

Introduction

Database migration from Oracle to PostgreSQL has become increasingly common as organizations seek to reduce licensing costs, embrace open-source solutions, and modernize their database infrastructure. However, such migrations present significant…

Many organizations have a cloud strategy and one of which is moving your databases to cloud. If you have already/recently moved to AWS and started using AWS RDS Databases for example Oracle, SQL Server, PostgreSQL, MySQL and if you are wondering how to…

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…

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…

I was recently talking to a customer who wanted some help tracking Oracle process memory usage on Windows. They had a problem with a bug causing a memory leak and had a support case open for that. They were happy with the SQL PI feature in Foglight that…

Background

We are very excited to announce the general availability of Quest® Foglight® version 6.3.

Foglight is the world’s broadest and deepest monitoring and optimization solution for the hybrid enterprise. Foglight brings unique top-to-bottom…

We are seeing more and more interest in our Stat customers moving their EBS and/or PeopleSoft applications to the cloud.  It seems most of the moves currently are to Oracle Cloud Infrastructure (OCI).  In some cases, customers are also moving Stat as well…

If you are reading this, chances are you’re considering a 30 day trial of ‘Foglight for Cross Platform Databases’. Before you do, here are a few tips that will help you get a fully functional Foglight installation up and running quickly…

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…

Data to AWS Three Ways

A SharePlex Cookbook Part Two

In the first blog, I discussed data and a bit on SharePlex. Now for the recipes!

Recipes

Here are the recipes - three different ways to get data from your Oracle database to either an Amazon File or…

This is the second in a multi-part series on how to leverage Foglight to save money within your IT budgets.  To review the first part, managing monitoring vendor sprawl, check out the post linked here.

This post is going to cover another way to save money…

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 has…

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 said in…

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 following steps…

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 applications so that…

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…

"I felt a great disturbance in the Force, as if millions of voices suddenly cried out in terror and were suddenly silenced=" - Obi Wan - Star Wars

if the lack of support for RAC in Oracle 19c is disturbing the Force in your environments, here…

Subscription services are not new. In fact, it might interest you to know that the subscription business model was pioneered by publishers of books and periodicals as far back as the 17^th century.

Whether you lease a car, donate to charity or pay for…

Database monitoring is the process of collecting and using performance metrics so your database can fully support your applications by avoiding slowdowns and responding immediately to queries. Database professionals who know the right metrics and track…

We’re all in the same global boat. In response to COVID-19, and to curtail the spread and keep employees and the general population well, companies worldwide have suddenly sent their employees home to work.

Who says database pros lose productivity…

There are many advantages of migrating databases to a cloud services provider such as Amazon AWS, such as faster provisioning, increased reliability, flexible resource scaling and reduced CapEx. However, if you are undertaking an Oracle database migration…

Many developers think that DevOps and ERP just don’t mix. Are you one of them?

It’s not only the Java developers doing departmental-type applications who think that way, but also the developers on ERP teams. You know; the people who have built a…

In case you missed the December webcast, “Mitigate Your Oracle Database to AWS Cloud Migration Challenges,” you can catch the replay on Quest.com.

Representing Quest® is John Pocknell, senior solutions product manager in information management…

For those Toad for Oracle users that often execute long running queries using F9, they always ask me how they can still work in Toad without having to wait on the query to finish. The problem seems to be the user sees the dialog box below in Figure 1…