MSSQL

  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 …

I will configure SQL Server AlwaysOn Availability Groups step by step in this article. First I want to tell about SQL Server Alwas ON. What …

  Sometimes you may want to execute a script in more than one instance. It is a solution to connect to each instance individually, but …

  Step 1: Create SP sp_help_revlogin on master database of Source / Primary instance The following script create two stored-procedures. You will use the first one …

  Sometimes you may need to restart one of the Always On servers. In such a case, you will need to failover the Availability Group …

  Sometimes you may need to restart one of the servers you use Always ON. Suppose you have 2 servers and that you have 10 …