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.

Identifying Cost-Saving Opportunities in Azure DevOps


This article explores various methods that can be used to reduce costs while using Azure DevOps....
Read More

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 databases with all their data permanently....
Read More

How to Change Default MySQL Port in Windows 10


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,...
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. In terms of automation of database...
Read More

Drop Temp Table in SQL Server and PostgreSQL

Database development, PostgreSQL, SQL Server, 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 administration, MySQL, Security

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

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

Database administration, Database Optimization & Structure, MySQL

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

How to SHOW or LIST Tables in MySQL

Database development, MySQL, Tables

There are two primary methods to view the tables in MySQL: In this article, we are going to explore them both....
Read More

SQL Server RAISERROR Statement with Simple Examples

Database administration, Database development, Stored Procedures, Troubleshooting Issues

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