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.

Drop Temp Table in SQL Server and PostgreSQL

12:01 Database development, Statements, Tables

This article explains different ways to drop the temp table in SQL Server and PostgreSQL. As the...
Read More

Reset the Root Password of MySQL on Windows

12:20 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

Different Ways to Populate the Users of MySQL

10:44 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

12:56 Database development, Tools & technologies • One Comment

XAMPP is a cross-platform web server used to develop and test programs and web applications,...
Read More

Different Ways to View Tables in MySQL Server

10:54 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

15:11 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

09:24 Database development, Statements

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

How to Delete Entire MySQL Database

14:13 Database administation, Work with data

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

SQL DEFAULT Constraint to Insert Column with a Default Value to SQL Server Table

13:43 Database development, Tables

To insert data into a table having columns with default constraints, we can use the DEFAULT constraint to a default value in a table. This...
Read More

3 Methods to Rebuild All Indexes for All Tables with T-SQL in SQL Server Database

12:36 Database development, Indexes, Languages & Coding, T-SQL, Tables

There are several methods of how to rebuild all indexes of all tables in SQL Server, among them:...
Read More