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)

Migrating disk-based tables to memory-optimized tables of a SQL database - January 6, 2022
How to move tables to another filegroup of a SQL database - December 14, 2021
Configure ODBC Drivers for Oracle 19c - December 9, 2021

Migrating disk-based tables to memory-optimized tables of a SQL database

January 6, 2022 by Nisarg Upadhyay

In this series of articles, we will learn how to convert the disk-based table to an in-memory table of SQL Database.

How to move tables to another filegroup of a SQL database

December 14, 2021 by Nisarg Upadhyay

This article explains the different methods to move tables between different filegroup of SQL databases.

Configure ODBC Drivers for Oracle 19c

December 9, 2021 by Nisarg Upadhyay

This article explains the process to configure the ODBC driver for oracle 19c. I am covering the following topics:

Configure a Linked Server between SQL Server and PostgreSQL using ODBC drivers

December 6, 2021 by Nisarg Upadhyay

This article explains configuring a linked server between SQL Server 2019 and PostgreSQL. In my previous article named Configure ODBC drivers for PostgreSQL, we got introduced to the ODBC driver of PostgreSQL. We also learned how we could download, install, and configure it. In this article, we will explore how we can utilize the ODBC driver to access the data of the PostgreSQL from SQL Server 2019.

How to download and install SQL Server 2016 express edition

December 2, 2021 by Nisarg Upadhyay

In this article, you are going to learn about SQL Server 2016 express download and installation process. The SQL Server 2016 express edition is a free version of SQL Server that offers limited features. The express edition of SQL Server can be used in any of the following scenarios:

Transfer error messages between SQL Server instances using SSDT 2017

November 29, 2021 by Nisarg Upadhyay

This is the fourth article in the series of Migrating SQL Server Objects using SSDT 2017. In the third article, we learned how we could transfer SQL logins between the servers. In this article, we will learn how to copy error messages to another instance using the Transfer Error Messages Task of SSDT 2017.

Transfer SQL Logins between SQL Server instances using SSDT 2017

November 16, 2021 by Nisarg Upadhyay

This is the third article in the series of Migrating SQL Server Objects using SSDT 2017. In the second article, we learned how we can transfer the stored procedure of the master database. In this article, we will learn how to copy SQL Logins to another instance using SSDT 2017.

Transfer Stored Procedures between master databases on SQL Server instances using SSDT 2017

November 9, 2021 by Nisarg Upadhyay

This is the second article in the series of Migrating SQL Server Objects using SSDT 2017. In this article, we will learn how to copy user stored procedures created in the SQL Server master database.

Transfer SQL Jobs between SQL Server instances using SSDT 2017

November 5, 2021 by Nisarg Upadhyay

In this series of articles, we will learn how we can clone the SQL Server instance using SSDT 2017. In my previous article, we learned how to Install and configure SSDT 2017 on Windows 10. In this series of articles, we will migrate the following SQL Server components to another server using SSIS tools provided in SSDT 2017:

Install and configure SSDT 2017 on Windows 10

October 28, 2021 by Nisarg Upadhyay

In this article, we are going to learn how we can install and configure the SSDT 2017 on Windows 10. The SQL Server data tools 2017 (SSDT 2017) is a development tool used for database development, SQL Server analysis service data models, SQL Server report service reports, and Integration service packages.

Configure ODBC drivers for PostgreSQL

October 22, 2021 by Nisarg Upadhyay

In this article, we are going to understand the process to configure the ODBC driver for PostgreSQL. For the demonstration, I have installed PostgreSQL on my workstation. The details of the server and database are following:

Creating databases in Oracle 19c using the Database Configuration Assistant

October 19, 2021 by Nisarg Upadhyay

In this article, we understand how to create a new database in Oracle 19c using a database configuration assistant. The database configuration assistant allows us to create a new database using a pre-defined template or create a database with various configuration options. In this article, we are going to learn both methods.

Installing Oracle 19c on Windows Server 2019

October 13, 2021 by Nisarg Upadhyay

In this article, we understand the step-by-step installation process of Oracle 19c on Windows Server 2019. The minimum hardware requirement to install an Oracle database server is following:

How to write SQL queries with spaces in column names

September 29, 2021 by Nisarg Upadhyay

In this article, we are going to learn how we can write a SQL query with space in the column name. Blanks spaces are restricted in the naming convention of the database object’s name and column name of the table. If you want to include the blanks space in the object name or column name, the query and application code must be written differently. You must be careful and precise while writing dynamic SQL queries. This article explains how we can handle object names and columns with blank space in SQL Server and MySQL.

SQL queries to change the column type

September 22, 2021 by Nisarg Upadhyay

This article covers the different SQL queries to change the column type. We are going to learn how we can change the data type of the columns of the following databases:

How to install PostgreSQL on Windows

September 14, 2021 by Nisarg Upadhyay

In this article, we are going to learn how we can install and configure PostgreSQL on windows 10. PostgreSQL, also known as Postgres, is a free and open relational database management system.

Understanding Postgres check constraints

September 9, 2021 by Nisarg Upadhyay

This article covers the Postgres CHECK constraint and its usage. In this article, we are going to learn:

Learn MySQL: MySQL Copy table

September 7, 2021 by Nisarg Upadhyay

This article explains the MySQL copy table process. In this article, you will learn how we can copy data from one table to another table. These tables could be in the same database or different databases. The MySQL copy table process can copy a specific dataset or all data from the source table to the destination table. We can use the MySQL copy table process to replicate the issues that occurred on production servers, which helps developers rectify the issues quickly.

How to install SQL Server developer edition

August 31, 2021 by Nisarg Upadhyay

In this article, we are going to learn how we can install the SQL Server developer edition. We are installing the SQL Server 2017 developer edition on my workstation.

Managing the Windows Internal Database (WID)

August 25, 2021 by Nisarg Upadhyay

In this article, we are going to learn about the windows internal database. Microsoft windows server and their components use the Microsoft WID database to store their data. It is used to store the relational data of the following services:

Automate the SQL Server DBCC CheckDB command using Maintenance Plans

August 19, 2021 by Nisarg Upadhyay

In this article, I am going to explain how we can create a maintenance plan to automate the SQL Server DBCC CheckDB command.

Understanding SQL Server DBCC DBREINDEX command and its usage

August 2, 2021 by Nisarg Upadhyay

In this article, I am going to explain the DBCC DBREINDEX statement, its syntax, and its usage. Additionally, I am also going to cover the differences between the DBCC REINDEX and ALTER INDEX statements.

Understanding xp_fileexist and its usage

July 9, 2021 by Nisarg Upadhyay

In this article, we are going to learn about xp_fileexist, its usage, and alternatives. To access the file system using SQL Server queries, we can use the following extended stored procedures.

An overview of the sp_helptext statement

June 28, 2021 by Nisarg Upadhyay

In this article, we are learning about the sp_helptext statement. I am going to show the various examples of the usage of it. I will also explain the two alternatives of the sp_helptext statement.

ALTER DATABASE SET SINGLE_USER statement in SQL Server

June 7, 2021 by Nisarg Upadhyay

In this article, we are going to explore the purpose of the ALTER DATABASE SET SINGLE_USER statement. The ALTER DATABASE SET SINGLE_USER is used to put the database in single-user mode. When any database is in single-user mode, the new user cannot connect to the database. However, the users that are already connected to the database do not get disconnected.