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
Backing up your Azure SQL databases and restoring them to a local SQL Server can be a crucial part of your disaster recovery strategy or testing process. In this guide, we’ll walk you through each step required to back up your Azure SQL databases and restore them locally using SQL Server Management Studio (SSMS). Step … Read more
Microsoft SQL Server 2016 (MSSQL 2016) is a very reliable database system, and even today, many businesses still use it. It’s a common approach—if it works, don’t touch it. Moreover, upgrading to a later version of SQL requires purchasing a rather expensive license. In this article, we will discuss how to perform backups and restores … Read more
Microsoft SQL Server 2012 (MSSQL 2012) is a very reliable database system, and even today, many businesses still use it, even though it is no longer supported by Microsoft. It’s a common approach—if it works, don’t touch it. Moreover, upgrading to a later version of SQL requires purchasing a rather expensive license. In this article, … Read more
Database migration is a common task for database administrators, but it is often associated with potential issues that may not be immediately obvious. Before starting the migration, there are two important recommendations: 1. Make sure to use the Data Migration Assistant (DMA) — a Microsoft tool that helps identify features that have been deprecated or changed … 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
In the previous article, we showed how to use the SqlBak API to automate backup health checks: detecting failed jobs, offline servers, missing recent backups, and retention policy issues. The next logical step is to bring that data into Grafana so backup monitoring becomes part of your overall observability stack alongside CPU, RAM, disks, and … Read more
Database backups are often configured once and then quietly forgotten — until something goes wrong. In modern environments, teams may operate dozens or hundreds of database servers supporting ERP, CRM, and other critical systems. At the same time, they are managing many other priorities — sales, inventory, procurement, HR, production, and more — each with … Read more
Starting from version 17, PostgreSQL introduced native support for incremental backups, enabling more efficient and storage-friendly backup strategies. One of the key requirements for incremental backups is enabling WAL (Write-Ahead Log) file summarization. This article explains how to enable WAL summarization by updating PostgreSQL configuration settings. 1. Backup the Configuration File Before making any changes, … 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
