Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
In this article, we will change database recovery model in SQL Server via SSMS or script. Also I will share scripts to to find recovery …
Read More »
MSSQL
What is Database Checkpoint in SQL Server
Database Checkpoint process is one of the most important part of SQL Server Architecture. Before you read this article, you need to understand the significance …
Read More »
Database Recovery Mode in SQL Server
This article contains information about database recovery mode in SQL Server. You will find many information about FULL,SIMPLE and BULK LOGGED Recovery models and differences …
Read More »
SQL Server Does Not Truncate the Transaction Log After Log Backup and Can Not Shrink the Transaction Log
If you regularly backup your sql server transaction log of your database that uses full recovery model, it truncate the Transaction Log file after each …
Read More »
How To Configure MSDTC For SQL Server
In this article, we will explain what is MSDTC and configure MSDTC(Microsoft Distributed Transaction Coordinator) for an application that will connect to SQL Server with …
Read More »