MSSQL

  If you define the availability group asynchronous in the SQL Server Always ON architecture, the secondary database is slightly behind. You can find details …

  Sometimes we need to take backups on an AG basis. Finding databases that are included in individual AG and getting their individual backups will …

  In this article We create a share on a server and then we map this share on a server. I selected MSSQL as Category. …

  In Always On Availability Group Architecture, you can read from the Secondary Server. So how do you use it in your applications? In this …

  As you know, when you define SQL Server services through sql server configuration manager, they are automatically authorized with the minimum privileges they may …

  When creating a SQL Login, you can select the Enforce Password Policy option as described in my article “How To Create a Login On …

  After SQL Server Setup has been performed, it is necessary to make some settings in Security Policy in Windows for the performance of SQL …

  Microsoft has announced that it will remove Database Mirroring in the future because it has developed the Always On technology. But since SQL Server …

  Replication is one of the High Availability solutions. But it is not usually used as a High Availability solution. We would use SQL Server Always …

  Page is the most basic unit of SQL Server on storage. Each page consists of 8 KB. The mdf or ndf files that allocate …