MSSQL

In some cases, we may want to increase the size of the database by inserting random data into the database. In the script below, we …

  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 …

  Instant File Initialization is a feature that introduced with SQL Server 2005 and Windows Server 2003-Windows XP. To enable this feature, the SQL Server …

  In order to understand this article more clearly, I suggest you read the article “SQL Server Replication Types“. First, the snaphot of the table …

  You have created a user in Postgresql, but software developer ask for change the user name or you have to change it for different …

  In the article “How To Authorize non-admin Logins To Read DMWs and DMFs“, I explained how to give dmw and dmf read privileges to …

  Some logins may want to see queries that requested from the database. They can see these queries from SQL Server  DMWs(Dynamic Management View) and …

  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 …

  With the Log Shipping technology, the backup of the SQL Server Transaction Log file is periodically transferred to another instance and recovered on the …

  I will use SQL Server 2014 in this article. Other versions can be installed in similar ways. SQL Server Always On Failover Cluster was …