Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux

Before reading this article, you might want to read the article “How To Create a FileSystem on ZFS (Mount Point)” to create a mount point on …

In Postgres you could be managing many databases on a Cluster. In some cases you may need to query the size all of these databases. …

Before shrinking the SQL Server log file, I recommend you read articles “What is SQL Server Transaction Log” and  “What is Database Recovery Model” that …

When we create filesystem on ZFS, mount process happens by default and mount point created. This mount point can then be mounted on the linux …

SQL Server Transaction Log is the log file with .ldf extension. Every transaction that occurs in SQL Server and database modifications performed by these transactions …

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 …

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 …

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 …

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 …

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 …