Skip to content

index

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 attempting a replication with GoldenGate, and I wanted to write about the DBA_GOLDENGATE_NOT_UNIQUE view. Before explaining what this view contains and… 

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 rights on your environment. Disk Space problem If you have a full disk.Instead of connecting to the server.You can use this query,… 

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 built (for security and scalability). The K8s Nodes were split across two DataCenters for DR reasons. However, one of the DataCenter had an important issue… 

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 how to configure Kibana and discover our data. Data Stream vs Index A data stream lets you store append-only time series data across multiple indices while giving you… 

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. Snapshot lifecycle management (SLM) is the easiest way to regularly back up a cluster. An SLM policy automatically takes snapshots on a preset schedule. The policy can also delete snapshots based on retention rules… 

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. A snapshot is a backup of a running Elasticsearch cluster, it could be used to: Please note that this blog… 

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 with you the Index compatibility story 😉 Index compatibility Elastic confirm that any index you restore from a snapshot must… 

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? To be honest, I had this question as a beginner and rapidly noticed that there are two sides to answer it. First the indexing, is… 

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). What is an index? To understand what is an index in Elasticsearch, first we have to know that Elasticsearch is a distributed document store. Instead of storing information as rows of columnar data, Elasticsearch… 

Elasticsearch – Data lifecycle management

Elasticsearch is a very versatile platform that supports a variety of use cases and provides great flexibility around data organization. After a global overview on Elastic Stack, understanding Elasticsearch terminologies, and setup Elasticsearch. Today, we will go more in deep with data management inside Elasticsearch. Data categories The data you store in Elasticsearch generally falls into one of two categories:… 

SQL Server: Heap page deallocation and IndexOptimize

Introduction HEAP tables are a type of data structure that, unlike a clustered index table, does not have a specific ordering of its rows, making them faster to insert and delete data. They are often used for temporary “staging” tables. This is all fine. But, if your table is never dropped and reused over time for data loading, you need…