index

SQL Server: Stop ordering index columns by selectivity

Column order does not affect equality seeks in SQL Server. Measured on 5M rows, then proven inside the B-tree pages.

GoldenGate row identification: misconceptions and solutions

GoldenGate is a powerful replication tool, but it is so versatile that you should always check whether what you intend to do is supported or not. Oracle provides a few interesting scripts and views to check your environments before(…)

Common queries on a SQL Server environment for a DBA

This blog will be for queries we use for minor everyday problems. This blog will address issues related to disk space, SID for SQL login, and index fragmentation.. For this blog, you will only need SSMS and sysadmin(…)

Documentum – xPlore Dsearch not starting with a stuck rebuild

I recently faced another interesting issue (c.f. this one) with Documentum xPlore where the Dsearch would refuse to start because of a stuck online rebuild. It happened on a Kubernetes environment using custom images we(…)

Logs from Filebeat to Logstash to Elasticsearch – 3

We sow together how to install and configure Filebeat, Logstash and Elasticsearch. Our log data has been sent from Filebeat to Logstash, then forwarded to Elasticsearch. In this blog, we will see(…)

Elasticsearch – Snapshot Lifecycle Management (SLM)

In a previous blog, I spoke about snapshot, restore, and briefly about Snapshot Lifecycle Management. In this blog, I will go more in deep in SLM.

Elasticsearch – Snapshot and Restore

No need to explain what is a snapshot and restore, how much they are important to any platform, software, database, aso. In this blog, I will show you how to take snapshots of your Elasticsearch cluster and how to restore.

Elasticsearch Upgrade – What about index compatibility?

Upgrade Elasticsearch is an easy task, I always heard this sentence. Which is correct if you take care about indices and compatibility. At a customer, I had the chance to upgrade an old version of Elasticsearch, today I will share(…)

Elasticsearch: is case-sensitive or insensitive?

One more blog in the Elasticsearch series (blogs list at the bottom), this time we will try to learn more together about indexing and search, more specifically answer the question: is Elasticsearch case-sensitive or case-insensitive?(…)

Elasticsearch – Index, document, and search

I have recently wrote blogs about ELK Stack and more specifically around Elasticsearch, this blog comes as a complement of the previous blog (Data lifecycle management).