MSSQL

We will create sql server audit step by step in this article. We need to create an Audit file to record transactions made by people …

I wanted to write this article to make it easier for you to choose between SQL Server’s technologies used for HA (High Availability) and DR …

  You can use the following script to collect the enviroment information that are set on the user you are connecting to the database. This …

  Database Snapshot is the creation of an unchangeable image of the database, you can think of it as taking current photo of database. If …

  Snapshot technology is used during the first synchronization in other types of replication. Below you can find more articles about the types of replication. …

  Merge Replication is a technology developed for applications that want to update on the same table through multiple servers. In other words, Publisher and …

You may get an error as follows when you want to change and save a column type or size in a table in the database. …

It uses the technology of Transactional Replication. As a difference, every subscriber is also publisher. You can read my article “Transactional Replication On SQL Server“. …

When you delete the database, remove the tick on “Delete backup and restore history information for databases” and check “Close existing connections”. Thus, the database …

When you want to back up your database, you may see “Cannot open backup device” error as you see in the picture below. To resolve …