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.

The Tutorial Guide to SQL Server DROP TABLE Statement

Database development, Statements

The SQL DROP statement is a command that deletes existing database components or the entire...
Read More

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 devices to the computer/server or...
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

Automation of Database Maintenance in SQL Server 2019 Express Edition

SQL Server

This article explains how to automate the database maintenance tasks in SQL Server Express Edition....
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 the MySQL Server secured. Suppose you...
Read More

MySQL SHOW USERS: How to List All Users in a MySQL

Database administation, Database Optimization & Structure

This article explains different methods to populate the details of the Users in MySQL. We can view...
Read More

How to SHOW or LIST Tables in MySQL

Database development, Tables

There are two primary methods to view the tables in MySQL: The MYSQL SHOW TABLES command. Querying the Information_schema.tables table. In...
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

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