MSSQL

  Policy-Based Management is a feature that introduced with SQL Server 2008. It allows us to set the rules we want in our systems, to …

  First of all, don’t forget to take backup for the security of your data. You can change the database’s collation with the following code. …

Sometimes the name of the server changes and the SQL Server instance name must change accordingly. For example, suppose your server name is a test …

  Policy-Based Management is a feature that introduced with SQL Server 2008. It allows us to set the rules we want in our systems, to …

  You can read the article “How To Create SQL Server Audit” to get more information about Audit and create an audit. You can read …

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. …