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.

Understanding MySQL TRUNCATE TABLE by Practical Examples

Database development, MySQL, Statements, Tables

MySQL TRUNCATE TABLE statement is a DDL statement used for removing all records from the MySQL...
Read More

SQL DROP TABLE Statement and Various Use Cases

Database development, Statements, Tables

The SQL DROP TABLE statement serves to drop the table from the database. It removes the table and its data and indexes associated with it....
Read More

Five Different Methods To Start, Stop, And Restart SQL Server Services

Tools & technologies

When we install the SQL Server, it also installs the following services: SQL Server database engine service to manage and access data in...
Read More

Install and Configure SQL Server 2019 on Windows Server 2016

Tools & technologies

SQL Server 2019 was introduced in November 2019. The RTM version of SQL Server 2019 is 15.0.2000.5....
Read More

Manage MDF Files in SQL Server 2019

Database administration, Work with data

An SQL Server database contains primary data files, secondary data files (optional), and transaction log files. The primary and secondary...
Read More

Deploy SQL Server AlwaysOn Availability Groups on Linux

Availability Groups, Database administration

In the previous article, I explained how we could install Ubuntu 18.04 and SQL Server 2019 on the virtual machines. Now, before we proceed...
Read More

SQL Server Express Edition: Installation, Benefits, and Limitations

Tools & technologies

The SQL Server Express edition is a free version of SQL Server 2019. You can use it to deploy small...
Read More

How to Install Ubuntu 18.04 and SQL Server 2019 on Linux

Tools & technologies

The previous article explained the creation of a virtual machine using Oracle VM Virtual machine. Now, we will learn how to install Ubuntu...
Read More

Сreating a Virtual Machine With Oracle VM Virtual Box

Availability Groups, Database administration, Tools & technologies

Microsoft announced cross-platform support of SQL Server – the SQL Server 2017 and SQL Server 2019 work on Microsoft Windows and Linux....
Read More

Create, Deploy, and Execute the SSIS package using SQL Server Agent

Business intelligence, SSIS

This article explains how to create an SSIS package using SQL Server Data Tools, deploy it with the...
Read More
Close