Database Administration & Monitoring

SQL Server Snapshot Backup and Restore with Proxmox ZFS – REST API with SQL Server 2025 (3/3)

The proposed architecture consists in adding a small internal REST API on the Proxmox server in order to expose a controlled ZFS snapshot operation. SQL Server 2025 can then call this API through sp_invoke_external_rest_endpoint, instead of running SSH commands directly(…)

SQL Server Snapshot Backup and Restore with Proxmox ZFS – Powershell implementation (2/3)

In the previous section, we discussed the drawbacks of running the commands manually. Indeed, the manual process was taking too much time and could directly impact the database state while the freeze was occurring. To address this issue, it is(…)

A Misleading SSAS Error in Power BI Report Server When Using DirectQuery Mode

Our client was experiencing issues after publishing a report that used Direct Query mode. Specifically, when the report was queried, the following error occurred: Error :  We couldn’t connect to the Analysis Services server. Make sure you’ve entered the connection(…)

PostgreSQL 19: Dynamically adjust the I/O worker pool

When PostgreSQL 18 was released last year one of the major features was the introduction of the asynchronous I/O subsystem. The main configuration parameter for this was (and still is)(…)

PostgreSQL 19: pg_waldump can now read from archives

When PostgreSQL 18 introduced the ability to verify tar based (and compressed) backups with pg_verifybackup there was one limitation: The verification of the WAL files in the tars (or compressed files) had(…)

PostgreSQL 19: Importing statistics from remote servers

Usually we do not see many foreign data wrappers being used by our customers. Most of them use the foreign data wrapper for Oracle to fetch data from Oracle systems. Some of them use the(…)

PostgreSQL 19: Online enabling of data checksums

Since PostgreSQL 18 was released last year checksums are enabled by default when a new cluster is initialized. This also means, that you either need to explicitly disable that when you upgrade from a previous version of PostgreSQL or you(…)

PostgreSQL 19: get_*_ddl functions

PostgreSQL already comes with plenty of system information functions to reconstruct the commands to create various objects, e.g. constraints or indexes. Starting with PostgreSQL 19 more functions will be available, namely those: pg_get_database_ddl pg_get_role_ddl pg_get_tablespace_ddl As(…)

PostgreSQL 19: json format for “copy to”

PostgreSQL already has impressive support for working with data in json format. If you look at the jsonb data type and all the built-in functions and operators you can use, there is so much(…)

PostgreSQL 19: The “repack” command

Before PostgreSQL 19 you had two commands to completely rewrite a table: Either you can use the “vacuum full” or the “cluster” command to achieve this. Both operations are blocking and the(…)