IT Tutorial Latest Tutorials About Database, Application, Operating System, Network, Artifical Intelligence, Programming Languages Tutorials & Useful Scripts & Tips and Tricks

Hi, I will explain Create Table ( CTAS ) and Data Types in Oracle SQL in this post of Oracle SQL Tutorial series.  2,699 views last month,  168 views today

Hi, I will explain SQL Subquery and Nested Queries in Oracle SQL in this post of Oracle SQL Tutorial series.  813 views last month,  35 views today

Google Indexing Indexing of new sites takes place by getting them into the Google archive. When Google bots find a suitable SEO criterion during the first visit of a new website, it provides an advantage in the first index. On-site and off-site SEO is very important. However, getting hundreds of …

At times, as a DBA, users need to copy tables from one database to another in a similar instance or in an alternate SQL instance, for example, replicating explicit tables from a creation database to a DEV one for testing or troubleshooting purposes. SQL Server offers a ton of techniques …

Hi, I will explain Union and Union All in Oracle SQL in this post of Oracle SQL Tutorial series.  381 views last month,  17 views today

Hi, I will explain Union and Union All in Oracle SQL in this post of Oracle SQL Tutorial series.  361 views last month,  18 views today

Hi, I will explain SQL Full Outer Join in Oracle SQL in this post of Oracle SQL Tutorial series.  468 views last month,  10 views today

Summary: Many times SQL database administrator looking for ways to recover data from SQL Server Transaction logs, The user can read this article to perform this task. We have given the best possible and also the easiest way to restore data from (.ldf) file. In case you are facing database …

Hi, I will explain SQL Right Outer Join in Oracle SQL in this post of Oracle SQL Tutorial series.  354 views last month,  14 views today

Hi, I will explain SQL Left Outer Join in Oracle SQL in this post of Oracle SQL Tutorial series.  350 views last month,  12 views today

Hi, I will explain SQL Inner Join in Oracle SQL in this post of Oracle SQL Tutorial series.  329 views last month,  11 views today

Hi, I will explain SQL Join and Join Types in Oracle SQL in this post of Oracle SQL Tutorial series.  370 views last month,  14 views today

Summary: To ensure smooth migration from Exchange Server to Office 365, you need to do extensive and careful planning. There are many things to consider before you plan such an exercise. In this post, we’ve mentioned a complete checklist of the things you need to consider before migrating from Exchange …

Summary: In this article, we are going to discuss how to get database online from restoring state in SQL Server. It is not a common issue, when the SQL database struck in restoring state it will create immense inconveniences for the database administrators. So in this article we have discusses …

ASM Command-Line Utility (ASMCMD): -ASMCMD is a command-line utility -ASMCMD provides commands for managing Oracle ASM -You can manage the following things by ASMCMD -: Oracle ASM instances Disk groups File access control for disk groups Files Directories within disk groups Templates for disk groups Volumes Types of ASMCMD Commands: …

Hi, When I try to use SCP command to transfer any file,  I saw”  Host key verification failed, lost connection and RSA host key for has changed and you have requested strict checking. ” error.  226 views last month,  5 views today

In this article we are going to discuss sysbench, the actual standard for MySQL benchmarking. We are going to take a look at sysbench usage basics and how can we use sysbench for learning about MySQL and the second is the most important aspect for us. We will practically use …

Hi, When I create the new Standby Instance,  I saw” failed to start ASMB (connection failed) state=0x1 and WARNING: ASMB exiting with error and Starting background process ASMB ” lots of same error in the alertlog.  332 views last month,  5 views today

Summary: In this post, we will guide you on how to fix error code 1067 in SQL server by using a couple of easy methods. “Hello! I am facing issues with my SQL Server. It is showing an error message “Windows could not start SQL Server (mssqlserver) service on local …

Hi, I will explain EXISTS Operator in Oracle SQL in this post of Oracle SQL Tutorial series.  409 views last month,  10 views today

Hi, When I startup the new Oracle Instance,  I got ” ORA-27301: OS failure message: No space left on device ORA-27302: failure occurred at: sskgpcreates ORA-27300: OS system dependent operation:semget failed with status: 28 ORA-27154: post/wait create failed ” error.  407 views last month,  15 views today

In this article, we are going to talk about the new feature in MySQL 8 related privilege system, which is Roles. So, let’s talk about roles, this article is completely devoted to roles. Other users may have complex privileges, a common example for this is a user used to report, …

Most of the time the horrible things that each DBA needs to manage are database corruption. Each DBA stores his/her critical data in the SQL, which size increment with time. At whatever point the SQL database gets damaged, it likewise damages metadata in the SQL server. Presently, fixing this corruption …