All articles

ysql_bench: the YugaByteDB version of pgbench

By Franck Pachot . This follows the previous post on testing YugaByteDB 2.1 performance with pgbench: https://www.dbi-services.com/blog/yugabytedb-2-1/ A distributed database needs to reduce inter-node synchronization latency and then replaces two-phase pessimistic locking by(…)

YugaByteDB 2.1: the Open Source multi-region distributed database with PostgreSQL API is in GA with huge performance improvement

By Franck Pachot . 9 months ago I was looking at YugaByteDB which was still in beta version for its 'YSQL' API. I published my first test on Medium: https://medium.com/@FranckPachot/running-pgbench-on-yugabytedb-1-3-3a15450dfa42. I have been very enthusiastic about(…)

Collations in PostgreSQL – basics

When you work with databases sooner or later you will need to get in touch witch collations. It might be that you never needed to think about it as initdb picked a(…)

Restore S3 Object with AWSPOWERSHELL

AWS S3 offers different Storage Classes, allowing to optimize cost among others. For instance, some classes are used for archiving purposes: S3 Glacier and S3 Glacier Deep Archive. It means the(…)

How to automate a kill of one or several executing jobs in AJF at specific Date/Time at once

Introduction We had a request to automate a kill of some executing jobs in AJF at specific date and time. For example: A Control-M job is running a script all day, in order other programs can connect to it,(…)

SQL Server: Collect Page Split events using Extended Event session

Earlier this week someone tried to show me how to capture page split events using Extended Events (XE) but unfortunately, the demo failed. This is a good opportunity for me to refresh my knowledge about page split and set up(…)

Control-M/EM Mass update,some examples on how to use it

Introduction We are back today to write about a powerful tool that we can use to update our folders Question Suppose you have to update two jobs of your folder; the task should be easy But what happens when you(…)

Refactoring procedural to SQL – an example with MySQL Sakila

By Franck Pachot What I want to show in this blog post is that, as in mathematics where you have to apply some algebra rules to transform an equation to an equivalent one, the database developer must translate the business(…)

DevOpsDays 2020 at HEG in Geneva

This 2020 new year began with a really exiting DevOps Event in Geneva. Kubernetes, Helm, Cloud Native, CNCF, CI/CD, Ansible, Terraform,… So much topics around DevOps that was in every people mouth. This confirm that DevOps is a good choice(…)

Control-M/EM Shout destination tables graphic and cmd mode

Introduction Today we will check how to use notification by using shout destination table, indeed sometime it could be useful to be notified about our jobs status ( long execution, late submission failure etc..). For that kind of need we(…)