Home

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.
CodingSight - Configure SQL Server Log Shipping

Configure SQL Server Log Shipping

October 22, 2020• Database administration, Transaction Log

This article explains the step by step deployment process of the SQL Server Log shipping. It is the...
Read More →
CodingSight - Configure SQL Jobs in SQL Server using T-SQL

Configure SQL Jobs in SQL Server using T-SQL

October 19, 2020• 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 →
CodingSight - Configure Database Mirroring in SQL Server

Configure Database Mirroring in SQL Server

October 16, 2020• 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

February 21, 2020• 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

January 27, 2020• 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

January 21, 2020• 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

January 21, 2020• 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

January 18, 2020• 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

December 13, 2019• 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

December 03, 2019• 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