GitHub

pg_dumpbinary is a program used to dump a PostgreSQL database with data dumped in binary format. The resulting dumps must be restored using pg_restorebinary.

you have bytea that can not be exported by pg_dump because the total size of the escape/hex output exceed 1Gb. you have custom type that stores \0 internally in bytea but data are returned as ...
IEEE

Fuzzy Group By Queries via RL-Instances in Conventional RDBMS

Abstract: SQL group by queries allow grouping tuples in relational databases and computing aggregated values from the obtained sets of tuples, which makes them a particularly useful tool for data ...
IEEE

Distributed/heterogeneous query processing in Microsoft SQL server

Abstract: This paper presents an architecture overview of the distributed, heterogeneous query processor (DHQP) in the Microsoft SQL server database system to enable queries over a large collection of ...
GitHub

This PowerShell module contains two functions that are useful for exporting large amounts of data from tables, views, or queries on an (Azure) SQL Server database into CSV ...

Exports the contents of a table, view, or query of a SQL Server database to an RFC 4180-compliant CSV file. This function supports the export of huge result sets by writing the contents of the CSV ...
Microsoft

Improve scalability with system page latch concurrency enhancements in SQL Server 2022

Part of the SQL Server 2022 blog series. The main difference between tempdb and other databases is the workload. With tempdb we are constantly creating and destroying objects such as temp tables. This ...
InfoQ

How to Source Control Your Databases for DevOps

Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. Birgitta Böckeler, Distinguished Engineer at ...