Recently, there was another high-profile case (not the first): an AI agent broke a small company’s business. https://x.com/lifeof_jer/status/2048103471019434248 Most of the discussion around it focuses on AI safety — and for good reason.Why did the agent have that level of access?What permissions should have been limited?What guardrails were missing? Those are important questions. But there’s … Read more

Microsoft SQL Server 2008 (MSSQL 2008) and its updated version, SQL Server 2008 R2, are very reliable database systems, and even today many businesses still use them despite being unsupported by Microsoft. It’s a common approach—if it works, don’t touch it. Moreover, upgrading to a newer version of SQL Server requires purchasing a relatively expensive … Read more

Backup is a critical part of database operations. Incremental backups can significantly reduce the performance load on a PostgreSQL server. This article covers the process of creating incremental backups of PostgreSQL on Windows, as well as restoring them. What is an Incremental Backup? An incremental backup is not a backup of the entire database, but … Read more

One of the key differences between PostgreSQL and other DBMSs is its large and diverse community, which creates a wide range of tools for working with and administering the system. This is undoubtedly a good thing, but sometimes such variety can be overwhelming — many tools exist for the same task, and it’s not always … Read more

Full database backups are a great thing, but creating them frequently can be inconvenient. If the database is large, the backup will also be large, and creating it can put a significant load on the server and the network when transferring the backup to storage. To avoid doing full backups all the time and to … Read more

By default, the SqlBak Docker container includes client utilities for working with databases, such as sqlcmd, mysql, mysqldump, psql, pg_dump, and pg_restore. However, these utilities may not be backward compatible with older database versions. For example, when connecting to a MySQL 8.1 database using the mysqldump utility from the Docker container, which is designed for MySQL … Read more

If your MySQL database is running in Docker, backing it up is no more complicated than backing up a database installed directly on the server. However, there are tips, tricks, and best practices that can simplify the process. Backup the database, not the container Although MySQL in Docker is ultimately just a program interacting with … Read more

Backup of virtual machines has long been the industry standard. While Docker is not a direct alternative to virtual machines, there are many similarities between them. So, how do you handle backup Docker containers? In this article, we will explore various approaches to backup Docker containers and their specific features. What should be backed up … Read more