SQL Server Database Recovery

What are Backup Checksums and How to Disable Them in SQL Server

In this article, we learn about backup checksums and how to disable them using SSMS The Checksum property in SQL Server can be put to use to detect what the changes are being made in SQL Server rows or expressions over a period of time. Tracking data and changes in an application like SQL Server can be very challenging and resource intensive at times. To help users deal with this challenge, they have been provided with the checksums property. Once you apply this to any given field or table,...

Read more »

A Quick Lowdown on Affinity Masks in SQL Server

This article explains all key points of CPU Affinity Masks in SQL Server.   To make the process of multi-tasking easier, Microsoft Windows often makes a shift in the process threads belonging to different processors.  This can help when looked from a point of view of the operating system, but this can also lag the performance of the application when there is a heavy load on the system. As the processor cache for each process will be reloaded along with the data. The performance...

Read more »

How Snapshot Replication Works in MS SQL Server

This article explains the snapshot process by going into the details of its working. Snapshot replication in SQL Server comes handy when you wish to share your database exactly the way it is right now, not focusing on any of the updates that would be made in it. Snapshot replication feature of SQL Server helps users to share data the way it appears in the current moment to the subscribers. It is important to note that although the snapshot replication process can be used in isolation, it...

Read more »