Nisarg Upadhyay

Author
Recent Posts

Nisarg Upadhyay is a SQL Server Database Administrator and Microsoft certified professional who has more than 8 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 B.Tech from Ganpat University. He can be reached on nisargupadhyay87@outlook.com

Latest posts by Nisarg Upadhyay (see all)

Copy SQL Databases between Windows 10 and CentOS using SQL Server data tools - October 19, 2022
Changing the location of FILESTREAM data files in SQL Database - October 14, 2022
Manage SQL Databases in CentOS: Manage filegroups of user databases - October 5, 2022

Learn MySQL: Create and drop temp tables

August 18, 2020 by Nisarg Upadhyay

In this article, we are going to learn how to create a temp table and further drop these tables. The temporary tables are session-specific tables that are created within the session. When the session closes, the table is dropped by itself. A temporary table exists within a session only; therefore, a table created by one session is not visible to another session. For example, Session ID 501 has created a temporary table then session ID 502 cannot access it or manipulate it. Two different sessions can have a temporary table with the same name.

Export data from MySQL tables to Azure SQL database

August 12, 2020 by Nisarg Upadhyay

In this article, I am going to explain how we can export the data of the on-premise MySQL database to Azure SQL database. This task can be performed in two phases.

Learn MySQL: Add data in tables using the INSERT statement

August 7, 2020 by Nisarg Upadhyay

In my previous article, Learn MySQL: Sorting and Filtering data in a table, we had learned about the sorting and filtering of the data using WHERE and ORDER BY clause.

Backup SQL databases to Azure using the database maintenance plan

August 6, 2020 by Nisarg Upadhyay

In this article, we are going to learn how we can back up the SQL database to Azure using a database maintenance plan. To demonstrate the process, I have restored the AdventureWorks2017 database on my workstation. I have created an Azure container named sqlbackups in my storage account.

Configure ODBC drivers for MySQL

August 5, 2020 by Nisarg Upadhyay

In this article, I am going to explain ODBC drivers. We will go through the process to set up the ODBC driver for MySQL and use it to create an SSRS report. First, let me talk about ODBC drivers.

Compress and split SQL database backups using WinRar

August 4, 2020 by Nisarg Upadhyay

Recently, we have received a strange request from our customer. They want us to set up a schedule a backup job that generates a backup of SQL database, compress the backup file in multiple compressed archive files (WinRAR files.) We tried to explain to the customer that the SQL Server native backups are capable of compressing the backup file, and it can split a large and compressed backup into multiple backup files. But they insisted us to use the WinRAR software to compress and split the backup.

Split SQL database backups into multiple backup files using SSMS

July 29, 2020 by Nisarg Upadhyay

In this article, I am going to explain how we can split the large backup file into multiple small backup files using SSMS 2016. I will also explain how we can combine multiple backups to restore a database and split the backup of the SQL database using SQL Server Management Studio (SSMS).

Learn MySQL: Sorting and Filtering data in a table

July 28, 2020 by Nisarg Upadhyay

In this article, we will learn how we can sort and filter data using the WHERE clause and sort the data using the ORDER BY clause. In my previous article, Learn MySQL: Querying data from MySQL server using the SELECT statement, we learned how to generate the ER diagram using reverse-engineering the database using MySQL workbench and basics of SELECT statement and usage. Ins this article, we will learn how we can sort and filter data using the WHERE clause and sort the data using the ORDER BY clause.

Learn MySQL: What is pagination

July 27, 2020 by Nisarg Upadhyay

In this article, I am going to explain that in MySQL, what is pagination and how we can implement it. When we are populating a large dataset from the MySQL database, it is not easy to read all the records on the same page. Using pagination, we can divide the result-set into multiple pages, and that increases the readability of the result set. In this article, I am going to explain:

Learn MySQL: Querying data from MySQL server using the SELECT statement

July 27, 2020 by Nisarg Upadhyay

In this series of articles, we are going to learn about the basics of the MySQL database server. In this article, I am going to explain how we can query the data from the MySQFL server using the SELECT statement.

Enforce SQL database best practices using SQL Server Policy-Based Management

July 24, 2020 by Nisarg Upadhyay

In this article, I am going to explain how we can enforce the SQL database best practices using Policy-Based Management. The policy-based management feature of SQL Server was introduced in SQL Server 2005. This feature was useful because it helps database administrators to define and enforce the database policies based on the organizations’ requirements.

Monitor the growth of SQL databases using the Default Trace

July 23, 2020 by Nisarg Upadhyay

Monitoring the growth of the SQL Database is one of the essential tasks of the SQL Server DBA. In this article, I am going to explain how we can monitor the growth of the SQL database using the default trace. First, let me explain the default trace in SQL Server.

Automating Azure SQL Database index maintenance using Elastic Job Agents

July 14, 2020 by Nisarg Upadhyay

In this article, I am going to explain how we can automate the index and statistics maintenance of Azure SQL Database using an Elastic Job Agent.

Move SQL databases to a different server using SQL Server log shipping

July 14, 2020 by Nisarg Upadhyay

As a SQL Server DBA, we are responsible for moving the customer SQL databases to other servers. Recently, I was assigned the same project. One of the customers wanted to move their SQL database to a separate server. Following were the challenges:

How to configure an iSCSI initiator on Windows Server 2016

July 7, 2020 by Nisarg Upadhyay

In this article, I am going to explain how we can configure the iSCSI initiator and use it to connect to the iSCSI virtual disk on the target server.

Refresh a SQL Database using the maintenance plan

July 2, 2020 by Nisarg Upadhyay

In this article, I am going to explain how we can refresh a SQL Database using the Maintenance plan. To demonstrate the process, I have configured two virtual machines. I have installed SQL Server 2016 on both. To refresh the SQL database on destination database server, we will generate a copy-only backup of the SQL database on source database server. I have created a network share directory. Both the source and destination server have the read-write permission on it. The backup file will be copied on a shared directory. Once the database is restored to the destination, we will delete the file from the network share directory.

Installing and configuring a iSCSI Target Server on Windows Server 2016

June 30, 2020 by Nisarg Upadhyay

In this article, I am going to explain how we can install and configure the iSCSI Target Server Role on Windows Server 2016. iSCSI stands for Internet Small Computer System Interface and iSCSI Target Server allows you to boot multiple computers from a single operating system (OS) image.

MySQL Create Table statement with examples

May 13, 2020 by Nisarg Upadhyay

In this article, I am going to explain the MySQL CREATE TABLE statement with examples. The following syntax contains basic statements to create a table in MySQL.

How to backup and restore MySQL databases using the mysqldump command

May 12, 2020 by Nisarg Upadhyay

In this article, I am going to explain different ways to generate the backup in the MySQL database server. As we know, data is a valuable asset to the organization. As database administrators, it is our primary and crucial job to keep the data available and safe. If the system or data center fails, database corruption, and data loss, we must be able to recover it within the defined SLA.

Deploy MySQL InnoDB Clusters for high availability

May 8, 2020 by Nisarg Upadhyay

In this article, I am going to explain how we can deploy the MySQL InnoDB cluster. InnoDB Cluster is a high availability solution provided by MySQL that has single and multi-master capabilities and failover detection.

Deploying Azure Databases for MySQL server using Azure Portal

April 24, 2020 by Nisarg Upadhyay

In this article, I am going to explain the step by step process to create an Azure Database for MySQL Server. Azure Database for MySQL is a fully-managed database as a service that uses MySQL community edition. It can manage the mission-critical workload with dynamic scalability. We can use it to develop various applications that leverage open-source tools and cross-platform applications. Let me explain these steps of a deployment process of MySQL Server on Azure.

Enterprise Data Masking in MySQL

April 15, 2020 by Nisarg Upadhyay

In this article, I am going to explain Data Masking feature in MySQL. The data masking is the MySQL enterprise edition feature. You can download the trial version of MySQL enterprise edition from here. Data Masking is a process of hiding confidential data like credit card information, SSNs, addresses etc. to safeguard sensitive data.

How to install MySQL database server 8.0.19 on Windows 10

March 19, 2020 by Nisarg Upadhyay

In this article, I am going to explain the step by step installation process of MySQL database server 8.0.19. MySQL is open-source, cross-platform relational database management server developed by Swedish company “MySQL AB” and later acquired by Oracle corporation. MySQL is offered as an open-source MySQL community server edition and enterprise server edition. In this article, I am going to install the MySQL Community server edition.

How to access data from Azure Blob Storage using Power BI

March 17, 2020 by Nisarg Upadhyay

In this article, I am going to explain how we can access the data from the Azure Blob Storage using Power BI. To do that, we are going to use the below tools:

Azure BLOB Storage account: We have uploaded the source CSV file to it
Power Query editor: To choose the data that we want to load in the Power BI report
Power BI Desktop: To view the data imported from the CSV file

How to install SQL Server 2012 express edition

March 9, 2020 by Nisarg Upadhyay

In this article, I am going to explain how we can install SQL Server 2012 express edition using the SQL Server installation center. Additionally, I will also explain how we can use the SQL Server installation configuration file to perform an unattended (silent) installation. First, download the SQL Server express edition from this location. Once the installation file is downloaded, let us begin the installation process.