MSSQL

  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 …

  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 …

  Buffer Pool Extension is a feature that was introduced in SQL Server 2014. With this feature, SQL Server uses the disk we specified for …

SQL Server is a relational database management system (RDBMS) that Microsoft has provided to us. You can find a lot of articles about SQL Server …

  A few weeks ago a client called around 11:00 pm and said that they received an error in a very critical Microsoft SQL Server …