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.

Configure SQL Server Log Shipping

Database administration, Transaction Log

This article explains the step by step deployment process of the SQL Server Log shipping. It is the...
Read More

Configure SQL Jobs in SQL Server using T-SQL

Code Management, Database development, Stored Procedures, T-SQL

SQL Server Agent is a component used for the database tasks automation. For instance, we need to perform Index maintenance on Production...
Read More

Configure Database Mirroring in SQL Server

Tools & technologies, Utilities & Extensions

Database mirroring is a SQL Server high availability solution provided by Microsoft, with the following components. Principal database...
Read More

Different Ways to Monitor SQL Server AlwaysOn Availability Groups

Availability Groups, Database administration

In my previous articles, I have explained the step-by-step process of deploying an AlwaysOn...
Read More

SQL Server High availability: Install SQL Server failover clustered instance Part 2

Database administration, Database Optimization & Structure

In my previous article, I have explained the step-by-step process of installing SQL Server Failover Clustered Instance. In this article, I...
Read More

SQL Server AlwaysOn Availability Groups: Installation and configuration, Part 2

Availability Groups, Database administration

In my previous article, I have explained the process of installing and creating a failover cluster and how to enable the AlwaysOn...
Read More

SQL Server AlwaysOn Availability Groups: Installation and Configuration. Part 2

Availability Groups, Database administration

In my previous article, I have explained the process of installing and creating a failover cluster...
Read More

SQL Server AlwaysOn Availability Groups: Installation and configuration, Part 1

Availability Groups, Database administration • One Comment

In this article, I will explain the process of installing pre-requisites to deploy the SQL Server AlwaysOn availability group. For the...
Read More

How to install SQL Server vNext and Azure data studio on Ubuntu 18.04

Azure, Cloud

Azure data studio is a cross-platform database management tool. This tool is used to connect, configure, and administrate SQL Server...
Read More

Move System Databases in the SQL Server Failover Cluster

Database administration, Database Optimization & Structure

Recently, I was assigned to a project – our customer purchased a new SAN, and they wanted us...
Read More
Close