Exposing MyRocks Internals via system variables: Part 4, Compression and Bloom Filters

(In the previous post, Part 3, we covered Compaction.) In this blog post, we continue on our series of exploring MyRocks mechanics by looking at the configurable server variables and column family options. In our last post, I explained at a…

Read More >

How to remove grid 12.2 after an 18c upgrade

The environment started with a GRID 12.1.0.1 installation, upgraded to 18.3.0.0, and performed out-of-place patching (OOP) to 18.6.0.0. As a result, there are three GRID homes and, ideally, we should remove 12.1.0.1 to save space because it’s longer required. This…

Read More >

Five ways to migrate your on-premises SQL database to Azure

There are currently three deployment options for SQL Server Database on the cloud. Well, four, if you count Azure SQL Databases in elastic pool. But Azure SQL DB in elastic pool is essentially just Azure SQL Databases grouped into an…

Read More >

How to use mount-dbfs.sh to resolve “Device or resource busy”

I was not satisfied with using fuser -mv to identify processes causing DBFS failure to unmount and killing the processes haphazardly. Upon further investigation, mount-dbfs.sh can be used to kill processes causing “Device or resource busy” and unmount DBFS. One…

Read More >

Exposing MyRocks Internals Via System Variables: Part 3, Compaction

(In the previous post, Part 2, we covered Initial Data Flushing.) In this blog post, we continue our series of exploring MyRocks mechanics by looking at the configurable server variables and column family options. In our last post, I explained…

Read More >

How to fix SQL backup to URL error: The remote server returned an error: (400) bad request

Problem: You are trying to take a native SQL Backup to URL and you receive the error below: Msg 3271, Level 16, State 1, Line 1 A nonrecoverable I/O error occurred on file “https://MyStorageAccount.file.core.windows.net/MyContainer/Adventureworks_full_20190420.bak:” Backup to URL received an exception…

Read More >

How to run DBSAT against Oracle RDS database

The scope of this article is to show how to run DBSAT (Oracle Database Security Assessment Tool) against an Amazon RDS Oracle instance. This is based on a real-life execution. The DBSAT version used was 2.0.2 over an RDS database…

Read More >

Harnessing the power of Jinja2 with Ansible

Configuration files management is the core component of every configuration management tool. Templates are one of the best methods for creating configuration files as they allow dynamic variables. Ansible has a template module that uses Jinja2 in its core. Jinja2…

Read More >

A simple command that saved me

So there I was, reviewing the environment to create an action plan for patching. To my surprise, I noticed the following when checking DBFS: I will demonstrate the simple command I used to ensure that all services that are supposed…

Read More >

How to run DBSAT on RAC Instances

The scope of this article is to provide a brief summary of how to run Oracle Database Security Assessment Tool (DBSAT) on Oracle Real Application Cluster using the parameters to exclude sections on the Reporter to avoid duplicated information into…

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