Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
We perform maintenance operations on SQL Server using Maintenance Plan. In this article I will describe the process of running a sql server job. I …
Read More »MSSQL
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 »Deleting Maintenance Plan History
We perform maintenance operations on SQL Server using Maintenance Plan. This article describes how to delete the maintenance plan history. I will share links to …
Read More »GRANT, REVOKE and DENY Commands in SQL Server(TSQL)
You can use GRANT, REVOKE, and DENY commands on many database objects in SQL Server. With the GRANT command, you can authorize a user. With …
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 »Updating Statistics Using Maintenance Plan
We perform maintenance operations on SQL Server using Maintenance Plan. In this article I will describe the process of updating statistics. For more detailed information …
Read More »SubQueries in SQL Server(TSQL)
In SQL Server, you can write query in a query. You can write the subqueries in the SELECT section, FROM section, and the WHERE …
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 »ORACLE_OCM ORA-12012 ORA-29280
Ora-12012, Ora-29280 errors relate to Oracle configuration manager (OCM). Typically, OCM jobs fail due to the old installation after database upgrade operations. Possible errors …
Read More »Checking Database Consistency Using Maintenance Plan
We perform maintenance operations on SQL Server using Maintenance Plan. In this article I will describe the process of checking the database consistency (dbcc checkdb). …
Read More »