Three Easy Steps For Consolidating Oracle Databases into Cloud Virtual Machines

Problem Having decided to move our Oracle databases to the cloud, we now want to build equivalent VMs as database servers.  This is simple enough when we have only one or a very small number of databases. But this can…

Read More >

Examining the Lifecycle of Tombstones in Apache Cassandra

This post is the first part of a series of blog posts regarding the lifecycle and management of tombstones. Deleting and expiring data in Cassandra is something that you should carefully plan. Especially if you’re about to delete a massive…

Read More >

Explaining Azure Data Factory Mapping Data Flows – SQL On The Edge Episode 20

With the current focus on data science, data engineering and the game-changing advantages of doing data lakes or warehouses in the cloud, all the major cloud providers continue to strengthen their data-related services and tools. On this front, Microsoft has…

Read More >

How to Autoscale ProxySQL in the cloud

ProxySQL is a great tool. It’s one of the most recommended technologies in our Open Source Database practice. Many of our clients are running it or are migrating towards it, but we’ve seen that it is pretty CPU-intensive. We’ve also…

Read More >

How to deploy highly available SQL Server 2017 on Linux on GKE

Kubernetes is an open-source container orchestration system for automating deployment, scaling and management of containerized applications. Running a SQL Server database on Kubernetes is a topic of discussion nowadays as Kubernetes provides ways to provision stateful containers using persistent volumes,…

Read More >

How to a recreate disk group used by CRS

I will go through detailed steps here on how to recreate a disk group used by CRS. Some things to bear in mind: – I created this cluster based on another existing cluster, so I just followed the same patterns…

Read More >

A script for Relocating and Restoring Database Services

Due to complex requirements for service relocate and restore as part of patching, I decided to script the process. Requirements: Existing configuration: Save existing services affinity: Note: /tmp/service_hawk*.conf is read-only to prevent accidental overwrite. Patching starts from instance1 and relocate…

Read More >

Exadata: How to manage OS dependencies when upgrading to 19c

Exadata 19c comes with Linux 7 and Exadata 12c and 18c come with Linux 6. There will then be an upgrade to Linux 7 when upgrading from 12c or 18c to Exadata 19c or above. In this specific case, you…

Read More >

How to create an Oracle Database Cloud service (OCI) using the command line

The Oracle Cloud Infrastructure, also known as the second generation cloud, offers an integrated command line utility called OCI Command Line Interface (CLI) which can be used to perform almost all the activities we can do using the web console….

Read More >

Examining distributed training of Keras Models

Creating deep learning models using Keras is pretty straightforward, which is why Keras is often used for prototyping and creating proof-of-concept products. But when it comes to using it for training bigger models or using very big datasets, we need…

Read More >
Page 1 of 34412345...10...Last Page »