Author: Nisarg Upadhyay

Nisarg is a SQL Server Database Administrator and Microsoft certified professional who has more than 5 years of experience with SQL Server administration and 2 years with Oracle 10g database administration. He has expertise in database design, performance tuning, backup and recovery, HA and DR setup, database migrations and upgrades. He has completed the Bachelors in Information Technology from Ganpat University.

How to Change Default MySQL Port in Windows 10

SQL Server

A network port is a communication endpoint used by applications, incoming connections, and external...
Read More

Automation of Database Maintenance in SQL Server 2019 Express Edition


This article explains how to automate the database maintenance tasks in SQL Server Express Edition. In terms of automation of database...
Read More

Drop Temp Table in SQL Server and PostgreSQL

Database development, Statements, Tables

This article explains different ways to drop the temp table in SQL Server and PostgreSQL. As the name suggests, temporary tables are used...
Read More

Reset the Root Password of MySQL on Windows

Database administation, Security

When we install MySQL on Windows, we usually specify the password of the root user. This helps keep...
Read More

Different Ways to Populate the Users of MySQL

Database administation, Database Optimization & Structure

This article explains different methods to populate the details of the Users in MySQL. We can view the list of users by using any of the...
Read More

Install and Configure XAMPP Software on Windows Server 2019

Database development, Tools & technologies

XAMPP is a cross-platform web server used to develop and test programs and web applications, created by the Apache friends organization....
Read More

Different Ways to View Tables in MySQL Server

Database development, Tables

There are two primary methods to view the tables in MySQL: The MYSQL SHOW TABLES command. Querying...
Read More

SQL Server RAISERROR Statement with Simple Examples

Database administation, Database development, Stored Procedures, Troubleshooting Issues

The SQL RAISERROR statement is used to send a custom message to the client application. It also can be used to debug the application and...
Read More

SQL DROP Index, DROP Table, and DROP Database Statements Explained with Examples

Database development, Statements

The SQL DROP statement is a command that deletes existing database components or the entire databases with all their data permanently....
Read More

How to Delete Entire MySQL Database

Database administation, Work with data

In some cases, we need to drop the entire database from the MySQL community server. This is simple...
Read More