October 29, 2026 · Zwiegnet Consulting
Install PostgreSQL 18 on AlmaLinux 10 from AppStream or the PGDG repo, run initdb, configure pg_hba.conf with scram-sha-256, and allow remote access through firewalld with SELinux enforcing.
Read More
October 14, 2026 · Zwiegnet Consulting
List all databases on a Microsoft SQL Server instance with SSMS, a sys.databases query, sp_databases, sqlcmd or PowerShell.
Read More
October 10, 2026 · Zwiegnet Consulting
Run mysql_upgrade after every MySQL version upgrade so tables stay optimized and backups keep working.
Read More
October 6, 2026 · Zwiegnet Consulting
Convert MySQL Slave to Master Convert MySQL Slave to Master If you ever have some sort of major failure, or you are just testing your fail over capabilities, you have…
Read More
September 18, 2026 · Zwiegnet Consulting
Install Oracle Express Oracle Linux 6 Install Oracle Express Oracle Linux 6 Preparing Oracle Enterprise LinuxDisk/Swap Setup As you can see we have root VG for the OS (60GB)/home Volume…
Read More
September 13, 2026 · Zwiegnet Consulting
Index SQL Server Database Index SQL Server 2008R2 Database Every once in a while it’s a good idea to re-index your tables when you are using Microsoft SQL Server. Unlike…
Read More
August 14, 2026 · Zwiegnet Consulting
Create New Database SQL Server Create New Database SQL Server 2008R2 The first thing you need to do is open SQL Server Management Studio from here login with the necessary…
Read More
August 13, 2026 · Zwiegnet Consulting
Fix Microsoft SQL Express Memory Issues Fix Microsoft SQL Express Memory Issues In this example, we have Microsoft SQL Server express. We know that express only can use 1GB RAM…
Read More
August 12, 2026 · Zwiegnet Consulting
Percona Live Amsterdam (September 9-11, 2026) brings together MySQL, PostgreSQL, Valkey, MongoDB and MariaDB users to talk about running open source databases in production.
Read More
August 10, 2026 · Zwiegnet Consulting
Backup SQL Server Express Backup SQL Server Express 2008R2 Open up SQL Server Management Express Studio, and Expand Databases For this example, we will be backing up a SharePoint Server,…
Read More