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 this article, I will share the necessary steps to connect to Oracle through the linux operating system and the solutions to the problems …

  Let’s assume that the sql_id of the query that we will improve is “bjyanqt9q718f”. First of all, we run the following procedure and create …

  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 …

  If you increase the INITRANS parameter in tables and indexes with very high I/O, it will make less I/O because multiple operations can be …

  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 …