Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
Last night, a customer started to receive error messages about one of the Replica in an AlwaysOn Availability Group configuration. Error messages were related …
Read More »Ekrem Önsoy
The computer ‘xxx’ is joined to a cluster
We had a job adding a new node to a Cluster the other day. During this process, I encountered the error you would see in …
Read More »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 …
Read More »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 …
Read More »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 …
Read More »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 …
Read More »The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine
ERROR: The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine. (System.Data) EXPLANATION: I received an error message when I wanted to import a …
Read More »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 …
Read More »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 …
Read More »A transport-level error has occurred when receiving results from the server
ERROR: A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 – The semaphore timeout period has expired.) …
Read More »