Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. Erik Steiger discusses the operational pain ...

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. The team at Readiness each ...

[!INCLUDE ssEnterpriseEd10] and later versions support backup compression. When creating a log shipping configuration, you can control the backup compression behavior of log backups. For more ...

A monthly overview of things you need to know as an architect or aspiring architect. Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with ...

This article describes troubleshooting steps that might help resolve problems that occur after the Replication Log Reader Agent fails in SQL Server. When the ...

Have you ever started SQL Server only to discover your database labeled “In Recovery,” you know how upsetting it can be—especially when the process appears to ...

MySQL and PostgreSQL are two of the most used open source SQL databases, and both fulfill the role of a general-purpose database well. How do you choose which one to use for a project? Let's look at ...

Have you ever faced a data loss scenario in your SQL Server database? It's a nightmare that no DBA wants to experience. The transaction log plays a crucial role in preventing such disasters. Think of ...

SQL Server's transaction log is a critical component of the database engine, ensuring data integrity and providing the ability to recover databases in the event of a failure. A lesser-known but ...

Margaret Rouse is an award-winning technical writer and teacher known for her ability to explain complex technical subjects simply to a non-technical, business audience. Over… DBMSs are important ...

Learn the basics of log management, including what logs are, what benefits they can bring, and what features to look for in a log management solution. Log management is an important component of ...