This is a foreign data wrapper (FDW) to connect PostgreSQL to Firebird. It provides both read (SELECT) and write (INSERT/UPDATE/DELETE) support, as well as pushdown of some operations. While it ...

A tool which treats CSV and JSON files as SQL tables, performs SQL SELECT queries on them, and stores the result into CSV and JSON files. Many tools and systems can export their data to CSV. Typical ...

In this article, we explore how Postgres, a powerful and versatile relational database, can be effectively used to model and traverse graphs and trees. While specialized graph databases exist, such as ...

Update 5th of May 2020: Thanks to Salesforce MVP and Marketing Cloud Expert, Gregory Gifford, here is a way better approach. There might still be useful information in my original solution but I ...

Resolving a SQL SPID to an AX user can be useful when trying to diagnose performance or blocking issues on the database server. As some of you are aware, in AX 2012 it is now possible to track an AX ...

SQL Bulk Insert has been tuned over the years to work well with the Microsoft .NET Framework. This tutorial shows you how to take advantage of its power. SQL Bulk Insert is not a new technology. In ...