In my previous article, I have explained the process of installing and creating a failover cluster and how to enable the AlwaysOn availability group.
In this article, I am going to explain the step-by-step deployment process of SQL Server AlwaysOn Availability groups using wizards. The deployment configurations look the following way:
In my previous article, I have explained the architecture of the AlwaysOn availability group and pre-requisites to deploy it successfully. In this article, I will explain the process of installing pre-requisites to deploy the SQL Server AlwaysOn availability group.
For the demonstration, I have prepared a demo set up at my work station. See the following components:
| Virtual Machine | Host Name | Purpose |
| Domain Controller | DC.Local | The domain controller is installed on this machine |
| Primary Replica | SQL01.DC.Local | This machine acts as a Primary replica in the Availability group |
| Secondary Replica | SQL02.DC.Local | This machine acts as a Secondary replica in the Availability group. This replica is in a Synchronous commit mode |
| Secondary Replica with | SQL03.DC.Local | This machine acts as a secondary replica in the Availability group. This replica is in an Asynchronous commit mode |
I will explain the following actions:
Azure data studio is a cross-platform database management tool. This tool is used to connect, configure, and administrate SQL Server instances installed locally or in the cloud. This tool can be installed on the following operating systems:
Initially, Microsoft introduced this tool as the “SQL Server operations studio.” Later they renamed it Azure Data Studio. You can get more information about it here.
In this article, I am going to explain the step-by-step installation process of SQL Server 2017 and Azure data studio on Ubuntu. I have divided the article into two parts. Firstly, we will install SQL Server 2017, and later I will explain the process of installing Azure Data Studio. For demonstration purposes, I have created a virtual machine and installed Ubuntu 18.04 on it. You can download Ubuntu here. Read More
Recently, I was assigned to a project – our customer purchased a new SAN, and they wanted us to replace the old one with a new SAN. User and system databases utilized SAN, meanwhile, the operating system and SQL were installed on the server’s local disks. Lucky us..!! The idea was to move the existing user and system databases to a new SAN and keep the downtime as minimum as possible. So, to minimize the downtime, instead of reinstalling OS and SQL, we decided to use the following approach.
In my previous article, I have explained the step-by-step process of installing a node in existing SQL Server Failover Cluster Instance. Along with that, I have also demonstrated manual failover and automatic failover.
In this article, I am going to demonstrate the process of adding a disk in a failover cluster and then move the existing database to a new drive. Read More
In this article, I am going to explain the process of installing SQL Server on failover cluster instance (FCI) on the primary node. First, let’s look at the prerequisites.
In my previous article about T-SQL regular expressions, I have explained the LIKE operator, its usage and provided several examples with it. In this article, we are going to discuss the SUBSTRING, PATINDEX, and CHARINDEX functions of T-SQL. These functions can be used to perform pattern matching. Read More
Microsoft SQL Server has many built-in functions that can be used to format the output and represents it in the desired format.
In this article, the following built-in string functions supported in Transact SQL will be discussed with examples provided:
In my previous article, I have briefly covered database statistics, its importance, and why statistics should be updated. Moreover, I have demonstrated a step by step process to create a SQL Server maintenance plan to update statistics. In this article, the following issues will be explained: 1. How to update statistics using T-SQL Command. 2. How to identify the frequently updated tables using T-SQL and also how to update the statistics of tables with frequently inserted/ updated / deleted data . Read More
A regular expression is a rule which defines how characters can appear in an expression. It’s a sequence of character or text which determines the search pattern. In SQL databases, selecting values based on regular expressions defined in the WHERE condition can be very useful. Following are a few use cases of how you can use regular expressions. Read More
