Database Administration & Monitoring

Oracle Grid Infrastructure 26ai/ ASM upgrade from 19c one node.

This is second part of 26ai migration blog. We will upgrade here one node Clusterware with ASM in 19c. We will use newest 23.26.1 GoldImages from oracle support. This tutorial showing main steps how to perform upgrade, its not procedure(…)

Database upgrade to AI Database 26ai (23.26.1) for Linux x86-64 upgrade from 19C in 3 steps using gold images.

This tutorial showing simple database upgrade to 26ai using traditional method and autoupgrade tool, For operational databases please properly test and plan your upgrade. https://docs.oracle.com/en/database/oracle/oracle-database/26/fppad/upgrading-oracle-database-software.html This is one from 3 Articles related to 26.1 upgrade: Database upgrade(…)

Commercial PostgreSQL distributions with TDE (2) EDB Postgres Extended Server (2) TDE

In the last post we’ve looked at how you you get EDB Postgres Extended server installed on your system. In contrast to the version provided by Fujitsu, TDE needs to be enabled when you initialize a(…)

Commercial PostgreSQL distributions with TDE (2) EDB Postgres Extended Server (1) Setup

We’ve already briefly looked at Fujitsu Enterprise Postgres (here and here) when it comes to TDE (Transparent Data Encryption) in PostgreSQL. In this and the next post we’ll look at(…)

Commercial PostgreSQL distributions with TDE (1) Fujitsu Enterprise Postgres (2) TDE

In the last post we did the setup of Fujitsu Enterprise Postgres so we’re now ready to look at how TDE is implemented in this distribution of PostgreSQL. The unit of encryption in this version of(…)

SQL Server 2022 CU23: Database Mail is broken, but your alerts shouldn’t be

SQL Server 2022 CU23 bug freezes your emails? Bypass Database Mail using dbatools and PowerShell to resend blocked alerts.

Commercial PostgreSQL distributions with TDE (1) Fujitsu Enterprise Postgres (1) Setup

While TDE (Transparent Data Encryption) is considered a checklist feature in some parts of the PostgreSQL community this topic comes up all over again. The same is true with our customers, it doesn’t matter at all if it technically makes(…)

PostgreSQL: Transaction IDs and Virtual Transaction IDs

In the last post we’ve looked at the basics when it comes to row locking in PostgreSQL and how that looks like in pg_locks. In this post we’ll look at transaction IDs and virtual transaction IDs(…)

SQL Server Always-On: Centralizing Backup History Across Replicas

Replace brittle T-SQL links and manual checks with a central PowerShell orchestrator to reliably manage Always On backup data at scale.

PostgreSQL: An introduction to row locking

Sometimes it is necessary to troubleshoot locks in PostgreSQL to figure out what is going on in the system. While locks are important and necessary in a database system, too many locks can also be an issue, performance wise and(…)