In addition to rolling out patches to address two zero-days affecting SQL Server and .NET, Microsoft introduced Common Log File System hardening with signature verification.

After experiencing weekly CDC failures caused by transaction log issues and logs suddenly chewing up disk space, I found myself repeatedly investigating the same questions: Why is the log so large?

Log Replay Service (LRS) has been used for migrations to Azure SQL Managed Instance since the service launched in November of 2018. Under the hood, LRS relies on the implementation of log shipping, ...

I am a Backend Developer and Software Engineer with a solid background in Artificial Intelligence in academic and professional fields, looking forwa ...

At today’s Ignite 2025 event, Microsoft announced one of the biggest Azure data updates in years. The company has announced the general availability of SQL Server 2025. That has come after a long ...

Let's follow up the last column with a step-by-step breakdown shows how the PowerShell script automates SQL Server backups, manages retention, logs activity and verifies data integrity. In my first ...

A couple of months ago, I wrote an article on how to use PowerShell to back up a database within SQL Server Express Edition. Even though the technique that I described in that post works, the script ...

Abstract: Generating accurate SQL from users’ natural language questions (text-to-SQL) remains a long-standing challenge due to the complexities involved in user question understanding, database ...