MS SQL is one of the most popular SQL databases. It is created in 1988 for the OS/2. During time SQL Server has a lot of versions which has different versions. In this tutorial, we...
SQL is a defacto language used to manage, query, select, filter data in a relational database. Similar to the programming languages SQL provides comments in order to make the SQL query or clause more readable...
MySQL is the most popular open-source database in the world. MySQL is a Relational Database Management System (RDMS) which is used to store data in a relational manner inside different tables. What makes MySQL different...
MS SQL Server provides some functions in order to make database administrators life easier. A typical database store different type of values. In some cases, we may need to cast and convert these values into...
SQL databases provide structured data storage capabilities. We can store data in tables with columns and rows. Other useful features for SQL databases are update capabilities. We can update SQL databases data in different ways...
Apache Kafka is a distributed streaming platform. Let’s explain it in more details. Apache Kafka is three key capabilities where publish and subscribe to streams of records, similar to a message queue or enterprise messaging...
The server is a computers type which consists of purposeful hardware and software used to provide different services to the clients. Servers generally use different and special applications to provide services. A server can contain...
MySQL or MariaDB database servers can be managed in different ways. Generally, GUI tools are provided because of their easiness. But in some cases command line connection may be required to connect and management MySQL...
During the connection to the Oracle Database server with the sqlplus we may get an error with the ORA-12162 specifier. This error will prevent to connect to the Oracle Database Server. “ORA-12162: TNS:net service name is...
sqlplus or sqlplus64 tools are used to connect and manage Oracle Databases. sqlplus64 is 64 bit version of the sqlplus. After installating these tools successfully when we try to run sqlplus command we may get...
