If there is a variable in the script we run and we have not declared this variable, we will get this error. For example, with the help of the following script, let’s create a table named “databaseandlogins” in the “TestDB” database. [crayon-5c3e710f9d88d662567849/] Then try to add data to this table as follows. [crayon-5c3e710f9d897192061945/] When […]
Sometimes, we can receive the below error. SSPI handshake failed with error code 0x8009030c, state 14 while establishing a connection with integrated security; the connection has been closed. Reason: AcceptSecurityContext failed. The Windows error code indicates the cause of failure. The logon attempt failed [CLIENT: 1.1.1.1] The reason for this error may be that […]
It is often time consuming job to gather detailed information about the backups of Oracle databases with RMAN. You need to collect information from many different environments. However, it is easier to access RMAN backup information with queries. You can reach detailed information about the backups taken in the last x days with the […]
DPM (Data Protection Manager) is Microsoft’s software for backup. Before reading this article, I recommend you to read other articles related to DPM on our website. If you type DPM in the search bar, the related articles will appear. You can open the DPM Administration Console and come to the Monitoring tab as shown […]
With UNION and UNION ALL Opertors, we can merge multiple sql statement’s result in a single result set. When we merge two SQL statements with the UNION operator, duplicate records are listed once in the result set. When we merge two SQL statements with the UNION ALL operator, all results are listed. If there […]
When calculating the size of a table in an Oracle database, it is incorrect to just look at the data size. It is necessary to calculate the size of the index, lobsegment and lobindex objects of the table. Because when we move the table to another database, all objects belonging to the table will […]
Sometimes the application owners can come to you because the application cannot connect to the database. In this case, a DBA must first test the connection from the application server to the database. It is very easy to test this connection if you have SSMS (SQL Server Management Studio) on the application server. You […]
In this article, we will examine the loops and conditions we use in TSQL. Conditions in TSQL: IF Statement in SQL Server: You can use it as follows. [crayon-5c3e710f9e6dc477481427/] IF…ELSE Statement in SQL Server: You can use it as follows. We’re running the same IF … ELSE Statement twice by changing the parameter value. […]
In Oracle databases running on Linux, you can access the relevant session information from each user processes. In most cases, it is necessary to detect queries that use excessive resources in the operating system. For this determination, the process id of the corresponding process on linux can be matched with the session’s spid information […]
It is a very critical step to correctly determine SQL Server Data Types when designing tables to prevent unnecessary growth of the database. The space that data types allocate on the disk is different. For example, suppose you have a column in your table that will contain numbers. If the value of this column will […]
