SQL Server
How To Restore SQL Server Database
Microsoft SQL Server (MSSQL) is a relational database management system used on Windows servers. The latest versions are also available…
Category: Databases
SQL Server
How to Rename a SQL Server Database
The Microsoft SQL Server provides you multiple ways to rename a database. You can either use SQL Server management studio…
SQL Server
(Fixed) Cannot drop the database because it is being used for replication. (Microsoft SQL Server, Error: 3724)
Error: Sometimes I face issues with the database deletion in the SQL server. If we have configured replication in the…
MySQL
How to drop a MySQL user using the command line interface
MySQL is an relational database management system provide authentication mechanism to prevent unauthorized access. In MySQL, user management is an…
PostgreSQL
How to Install PostgreSQL and pgAdmin4 in Ubuntu 20.04
PostgreSQL is a powerful, reliable, robust and open source object-relational database system. The latest version of this database system is…
MySQL
How to Install MySQL 8.0 on Ubuntu 20.04
MySQL is the popular relational database management system used for storing structured data in table formats. It is open source…
MySQL
How to Check MySQL Version
MySQL is a relational database management system. At the writing time of this tutorial MySQL, 8 is the latest version…
Ubuntu
How To Install MySQL 8.0 on Ubuntu 18.04
MySQL is the most popular relational database management system. As an assumption MySQL is used by every third website running…
MongoDB
How to Use LIKE Statement in MongoDB
MongoDB is an powerful Nosql database server. MongoDB uses JSON-like documents with optional schemas to store data. Its always a…
MongoDB
How to Enable Authentication in MongoDB
Having the ability to authenticate users with your database is an important security feature. This is especially true when that…