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 »Oracle Flashback Query
Oracle Flashback Query allows us to query as much as possible of the past committed data. We can query the data in the past …
Read More »How To Create Differential Backup Using SQL Server Maintenance Plan
We perform maintenance operations in SQL Server using Maintenance Plan. In this article, we will create a maintenance plan for differatial backup. I will share …
Read More »Order By Clause in SQL Server(TSQL)
With Order By Clause, you can sort the records returned as a result of the Select statement as ascending or descending according to the …
Read More »Where Clause in SQL Server and SQL Server Operators(TSQL)
We use WHERE clause to filter when reading, updating, and deleting data from a table. If we run select, Update, or delete statements without …
Read More »Ambiguous column name Error and SQL Server Alias(TSQL)
When reading data from tables, we may need to give different names to tables and columns. We can do this by defining alias to …
Read More »Merge Statement in SQL Server(TSQL)
With the Merge Statement, we can run INSERT, UPDATE, and DELETE commands at one time to synchronize two tables of the same structure. First, …
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 »ORA-00600 qcisSetPlsqlCtx
Depending on the timezone differences ORA-00600 error can be occured when opening the database. The argument for this error is [qcisSetPlsqlCtx: tzi init], which …
Read More »How To Create Full Backup Using SQL Server Maintenance Plan
We perform maintenance operations in SQL Server using Maintenance Plan. In this article we will create a maintenance plan for full backup. I will share …
Read More »