Community driven content discussing all aspects of software development from DevOps to design patterns. The Google Cloud Architect Professional Certification validates your ability to design, develop, ...

-- 16.0.1050.5 RTM GDR 2/14/2023 https://support.microsoft.com/en-us/topic/kb5021522-description-of-the-security-update-for-sql-server-2022-gdr-february-14-2023 ...

In this context, we will discuss how to remove a memory-optimized filegroup from the database. However, the process of achieving this may raise a question: According to Microsoft, is it possible to ...

Here, I am going to discuss some basic and most important configurations of the SQL Server Instance and Database Level which might be ignored and can cause performance issues. Although this is not the ...

1) Stop the managed recovery process (MRP) on the STANDBY database 2) Determine the SCN of the STANDBY database. 3) Take an incremental backup off the PRIMARY database 4) Transfer all backup sets to ...

For almost half a century, ACID transactions (satisfying the properties of atomicity, consistency, isolation, and durability) have been the abstraction of choice for ensuring consistency in ...

In the previous blog Merge Operations, we described that how a CFP transitions across various stages in its life cycle. In this blog, we will walk through an actual example to show the state ...

Backups Log truncation cannot occur during a backup or restore operation. In SQL Server 2005 and later, you can create a transaction log backup while a full or differential backup is occurring, but ...