Fraud Blocker

I’m having trouble canceling a PostgreSQL query.

A PostgreSQL query can take a very long time. Usually, it’s easy to stop (cancel) a statement like this, but sometimes things can go wrong and a query…

Continue Reading

POSTGRESQL TIME ZONE MANAGEMENT

Time zones are among the least popular topics in computing, right behind character encoding. In addition, PostgreSQL’s implementation of timestamp wit…

Continue Reading

MANAGING SQL ADD-ON PROGRAMS 

We all love and hate bonus cards, “Miles & more,” and bonus points at the same time, don’t we? Recently, we encountered an intriguing use case that go…

Continue Reading

How to define table size in MS SQL database

To determine the size of tables in a database hosted on Microsoft SQL Server, you need to perform the following steps:

1. Connect to a database ser…

Continue Reading

Oracle NANVL function

The Oracle/PLSQL NANVL function allows you to replace a value for a floating point number such as BINARY_FLOAT or BINARY_DOUBLE when Nan (Not a number…

Continue Reading

Thank you, the form has been submitted.