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 …

  In some cases, we may need to know how many percent of the ASM disks are used. The following query shows the percentage of …

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

  In this article I will tell you how to add the MS DTC service to the windows cluster. First, we open Disk Management. You …

  In this article, we will examine the settings that should be done on a Numa Node system. You must make these settings on systems …

  In order to change the size of the Redolog files, it is necessary to create redolog files of the desired size and drop the …

  If Redo Log Switch count is too much, you can increase the redo log sizes if you need. However, the larger the Redo Log, …