Author: Ekrem Önsoy

The original article was written in Turkish by Ekrem Önsoy and translated to English by dbtut with the consent of the author. The copyright of the article belongs to the author. The author shall not be liable in any way for any defect caused by translation.
11 Jan by Ekrem Önsoy

Suddenly, AlwaysOn AG Replica was failed.

  Last night, a customer started to receive error messages about one of the Replica in an AlwaysOn Availability Group configuration. Error messages were related to the delay of replication and the failure of the corresponding Replica. I connected to the server and started reviewing the AlwaysOn AG Dashboard and related logs. I saw that […]
9 Jan by Ekrem Önsoy

DCOM was unable to communicate with the computer “server_name.domain_name” using any of the configured protocols; requested by PID

  ERROR: DCOM was unable to communicate with the computer “server_name.domain_name” using any of the configured protocols; requested by PID     5cac (C:\Windows\system32\ServerManager.exe). Event Id in the Windows System Event Log: 10028. EXPLANATION: We started to encounter this error after removing 3 nodes from an environment with AlwaysOn Availability Groups. The number of nodes […]
8 Jan by Ekrem Önsoy

How To Move an Azure SQL Database to a Local Instance

  Today a software developer friend has requested to move a database in Azure SQL Database to a local server with its data. What I did was to export the SQL Database to a available Storage in Azure, and then download the generated * .bacpac file to an appropriate server in the local environment, and […]
7 Jan by Ekrem Önsoy

Unable to access the ‘database_name’ database because no online secondary replicas are enabled for read-only access

ERROR: Error: Microsoft ODBC Driver 11 for SQL Server : Unable to access the ‘database_name’ database because no online secondary replicas are enabled for read-only access. Check the availability group configuration to verify that at least one secondary replica is configured for read-only access. Wait for an enabled replica to come online, and retry your […]
6 Jan by Ekrem Önsoy

CONCAT Function in SQL Server(TSQL)

  I would like to talk to you about a new Built-in Function, CONCAT, that comes with SQL Server 2012. As you know, before SQL Server 2012, we used a method like the following to combine some values and text in SELECT: [crayon-5c3e651293b27083126659/] If all fields were text as above, this was not a problem. […]
5 Jan by Ekrem Önsoy

The EXECUTE permission was denied on the object ‘sp_sqlagent_update_agent_xps’, database ‘msdb’, schema ‘dbo’.

  ERROR: [298] SQLServer Error: 229, The EXECUTE permission was denied on the object ‘sp_sqlagent_update_agent_xps’, database ‘msdb’, schema ‘dbo’. [SQLSTATE 42000] (DisableAgentXPs) EXPLANATION: You may experience this error when you try to run the SQL Server Agent service. The problem is that the Windows (Local or Domain) account that you use to run SQL Server […]
4 Jan by Ekrem Önsoy

SQL Server 2016: Dynamic Data Masking

  I tested the Dynamic Data Masking feature in my SQL Server 2016 test environment, and I want to share the result with you. I used the PhoneNumber field in the AdventureWorks2012.Person.PersonPhone table for the test. Using the Dynamic Data Masking feature, I mask 3 characters in the middle of the values in the PhoneNumber […]