Databases — Carlos Rodrigues

Setting up Change Data Capture with Debezium and PostgreSQL

By Carlos Rodrigues

8 min read

Setting up Change Data Capture with Debezium and PostgreSQL

Event-driven systems have well-known advantages and most modern distributed system architectures leverage events to reduce latency, improve scalability, and overall, make everybody’s life a little Continue readingSetting up Change Data Capture with Debezium and PostgreSQL

2025-05-14 Read more

PostgreSQL – which configurations require a service restart

By Carlos Rodrigues

1 min read

PostgreSQL – which configurations require a service restart

To determine whether a PostgreSQL configuration change requires a service restart, query select name, context from pg_settings. If the context is postmaster, the setting requires a restart; otherwise a reload is sufficient.

2021-03-16 Read more

By Carlos Rodrigues

2 min read

SEQUELIZE AND TYPESCRIPT

As many .NET developers transitioning to the world of Node, I started looking for an ORM. After some research, I found sequelize which seems widely adopted by the community. I’m using typescript, and I quickly found the way to define the model with sequelize a bit too verbose, and especially a duplication of the typescript class. That’s when I discovered sequelize-typescript, which provides this bridge, and leverages typescript’s typings, so mapping can be transparent if so we wish. All it takes is to extend a base Model class, and some annotations. Continue readingSEQUELIZE AND TYPESCRIPT

2021-03-11 Read more

[SQL SERVER] – CHECK RESTORE / BACKUP PROGRESS

By Carlos Rodrigues

1 min read

[SQL SERVER] – CHECK RESTORE / BACKUP PROGRESS

Having to temporarily wear the DBA hat for a couple of days, I found myself backing up and restoring lots of databases, across different environments. Continue reading[SQL SERVER] – CHECK RESTORE / BACKUP PROGRESS

2016-07-14 Read more

By Carlos Rodrigues

1 min read

WHERE ARE SQL SERVER ERROR LOGS STORED?

Lately I had to provide the location of our SQL server error logs to an infra team, so they could be copied somewhere else. Raising a… Continue readingWHERE ARE SQL SERVER ERROR LOGS STORED?

2015-08-13 Read more

[SQL SERVER] – GENERATE RANDOM DATETIME WITHIN A RANGE

By Carlos Rodrigues

1 min read

[SQL SERVER] – GENERATE RANDOM DATETIME WITHIN A RANGE

One of these days I had the need to obtain a random datetime inside a specified range, on SQL Server 2008+. After a few minutes… Continue reading[SQL SERVER] – GENERATE RANDOM DATETIME WITHIN A RANGE

2012-06-22 Read more

By Carlos Rodrigues

2 min read

USING AN ENUM ON A FLUENTNHIBERNATE MAPPING [C#]

I recently needed to map a C# class to a database table using FluentNHibernate. So far so good…. But then I got stuck as one… Continue readingUSING AN ENUM ON A FLUENTNHIBERNATE MAPPING [C#]

2011-05-31 Read more