DBMS vs RDBMS: Comparison and Differences between DBMS and RDBMS

The World is all about Data. Know more about DBMS and RDBMS…and what’s next. Data and Information Management is not…

Read More »

9 Of The Most Common Mistakes In Database Design

As a database designer, when you are tasked with a database project, you can expect to run into a couple…

Read More »

Reactive Programming and Relational Databases

Imperative code eats threads at the pace of incoming requests while Software is eating the world. This post discusses the assumptions…

Read More »

How to Remove Leading/Trailing White Space from a String in SQL Server? LTRIM, RTRIM Example

Unlike Java, Microsoft SQL Server 2008, 2012, 2014,  and even the latest version don’t have a built-in trim() function, which…

Read More »

PostgreSQL on Open Liberty

Open Liberty is an interesting new OSS Java EE application server that originated from WebSphere Liberty. You can configure Open…

Read More »

Database testing with TestContainers

If you have ever written code that tests database interactions, such as data access objects, you very possibly have run…

Read More »

Tuning PostgreSQL with pgbench

When it comes to performance tuning an environment, often the first place to start is with the database. The reason…

Read More »

Work with Parallel Database Streams using Custom Thread Pools

Parallel Database Streams In my previous post, I wrote about processing database content in parallel using parallel streams and Speedment. Parallel…

Read More »

Using Named Database Locks

In a beginner’s guide to concurrency, I mentioned advisory locks. These are not the usual table locks – they are…

Read More »