Setting up MySQL encrypted replication on MySQL 5.7 with GTID

In this blog post, I’ll walk you through setting up encrypted replication on MySQL 5.7 with GTID enabled. I will walk you through how to create sample certificates and keys, and then configure MySQL to only use replication via an…

Read More >

Redo volume optimization in 12c R2

I was using SLOB to compare the throughput between 12.1 and 12.2 databases, and was surprised to see that the average redo size per transaction was ~18.5KB on 12cR2, and ~339KB on 12cR1. Understanding this difference was important for the…

Read More >

Technical insights into CockroachDB

I recently had the pleasure of discussing CockroachDB on the Datascape Podcast with Chris Presley and I wanted to supplement that episode with a bit more technical information about this database. A deeper look at consensus CockroachDB uses the Raft…

Read More >

Using AI for database administration automation – extracting useful information from log files

When talking about automation for Oracle Database Administration, besides automation of software installation and patching, with the use of techniques from machine learning, we can also try to automate a few other tasks. This is especially true since it is…

Read More >

Cosmos DB indexing fundamentals – SQL on the edge episode 15

As Microsoft’s premier NoSQL cloud offering, Cosmos DB offers some interesting design decisions and trade-offs that are necessary to understand in order to maximize the benefits of the product. In this blog post, we are going to cover indexing as…

Read More >

Oracle 12.2 ASM filter driver installation

Recently I needed to install Oracle 12.2 with the ASM Filter Driver for some research on an upcoming presentation. With the new image based Oracle Grid installation I expected this to be easy. To be fair, it was fairly easy,…

Read More >

Cosmos DB Geo-replication – SQL on the edge episode 14

As Microsoft Azure’s NoSQL service offering, Cosmos DB has received a lot of investment and development effort. Microsoft considers Cosmos as a “ring zero” service, which means that it is available by default from all regions as soon as they…

Read More >

Understanding Cosmos DB Request Units–SQL On The Edge Episode 13

As part of their cloud offerings, all major providers (Microsoft, Amazon, Google) have developed very exciting and interesting NoSQL/NewSQL offerings. Microsoft Azure’s is called Cosmos DB, a rebranding of the product initially known as DocumentDB. Cosmos DB is no longer…

Read More >

Oracle OpenWorld 2017 bloggers meetup

DON’T PANIC. Yes, we are doing the OOW Bloggers Meetup this year. Yes, it’s the same time. Yes, it’s the same location. Yes, it’s more fun every year. What: Oracle Bloggers Meetup 2017. When: Wed, 04-Oct-2017, 5:30pm. Where: Main Dining…

Read More >

How to analyze SQL server stack dumps

As a SQL Server production DBA, at some point in time you will have to deal with a stack dump. A stack dump is a file that is written to disk with an “.mdmp” extension when SQL Server encounters a…

Read More >
Page 3 of 612345...Last Page »