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

Total: 7 Average: 4.6

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:

Read More

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

Total: 3 Average: 3.7

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:

  1. Installing a failover clustering role
  2. Create a failover cluster
  3. Enable AlwaysOn availability group features in SQL Server

Read More

Using Alerts and Operators in SQL Server

Total: 4 Average: 4.5

Introduction

With all the advancements in SQL Server and data, it feels great that such native SQL tools as Alerts and Operators are still available. They are the key SQL Server Agent features that are related to anything in SQL Server automation. 

Their roles are clear:

  • Alerts, when configured, let database administrators know when a specified event has occurred. 
  • An operator is an object defined within SQL Server that maps anyone or a group that can receive notifications when these events occur.

Read More

Implementing Full-Text Search in SQL Server 2016 for Advanced Users

Total: 4 Average: 4.3

This article tells about advanced methods of Full-Text Search usage for data professionals. It enables better search experience in their day-to-day database analysis.

Additionally, the readers will get beyond basic knowledge of Full-Text Search and its implementation. You will see the importance of advanced searching methodology using Full-Text Search to get quick and reliable results.

Prerequisites

First, let’s go through prerequisites since the article is focused on advanced uses of Full-Text Search.

T-SQL Know-How

The article assumes that to implement the walk-through(s), the readers are familiar with writing and running T-SQL scripts against databases with a basic understanding of SQL Server. Read More

Implementing Full-Text Search in SQL Server 2016 for beginners

Total: 6 Average: 4.3

This article talks about the full-text search and its implementation for the beginners to get started.

Additionally, the readers will know the important things to make the full-text search work properly.

This article also highlights the importance of using Full-Text Search to match text patterns and meet similar sorts of requirements.

About Full-Text Search

Let’s understand the Full-Text Search with the help of definitions.

Simple Definition

Full-Text Search is used to optimally search character-based data for quick answers.

Microsoft Definition

Full-Text Search in SQL Server and Azure SQL Database (cloud version of SQL database) let users and applications run full-text queries against character-based data in SQL Server tables. Read More

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

Total: 1 Average: 5

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:

  1. Microsoft Windows
  2. Linux
    • Redgate
    • Debian
    • Ubuntu
  3. macOS

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

Dynamic Data Masking in SQL Server for Advanced Users

Total: 2 Average: 5

This article gives a high-level understanding of dynamic data masking in SQL Server along with its use cases, best practices and security implications for advanced SQL users (including developers and testers). Additionally, the readers of this article are going to get familiar with applying different types of dynamic data masking. The article also highlights the importance of advanced-level use of data masking in day-to-day database development and testing tasks.

Read More

Deploying a SQL Server Docker Container

Total: 4 Average: 4.8

Introduction

Containerization has become the dominant topic after the Server Virtualization and Cloud Computing Eras. While many thought leaders assert that current computing paradigms are not particularly new, containerization, as we have it today, can be viewed as having been born after cloud computing. Using containers on-premise allows us to perform migration to the cloud while building a containerized environment mimics the features of solutions deployed in the cloud.

Progression of Computing Read More

Move System Databases in the SQL Server Failover Cluster

Total: 6 Average: 3.7

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.

  1. Attach a new SAN to an existing server, create new drives on it, and add those drives to an existing failover cluster instance.
  2. Stop SQL Server, copy master, model, and msdb databases on new drives and start the SQL services.
  3. Move User databases to new drives and remove the old SAN.

Read More