Understanding the Database Level Collation and Impact of Changing it for a Database

When you develop an application or write a code in the SQL database system, it is crucial to understand how data will be sorted and compared. You can store your data in a specific language, or you may want SQL Server to treat case-sensitive and case insensitive data separately. Microsoft has provided an SQL Server setting called Collation to control and address such requirements.

CodingSight - Database Level Collation
Read More

How to Get SQL Server Statistics Information Using System Statistical Functions

Often, we need to gather system statistics regarding running SQL Server Instances, such as the number of total connections attempted to SQL Server instance since its start, or the time that SQL Server spent in active operations, etc. Microsoft brought us a separate set of system functions to retrieve the system-related statistics.  Today, I am going to explain such system statistical functions with the use cases.

CodingSight - Get SQL Server Statistics Information using System Statistical Functions
Read More

Configure SQL Server Always ON Availability Groups between Two Synchronous Replicas. Part 2

We already covered some theory about configuring Always ON Availability Groups for Linux-based SQL Servers. The current article will focus on practice.

We are going to present the step-by-step process of configuring the SQL Server Always ON Availability Groups between two synchronous replicas. Also, we’ll highlight the usage of the configuration-only replica to perform automatic failover.

Before we start, I would recommend you to refer to that previous article and refresh your knowledge.

CodingSight - Configure Two Node Synchronous Replicas and a Configuration-Only Replica on PACEMAKER Cluster between 3-Node Ubuntu Linux Systems. Part 2
Read More

Understanding Always ON Availability Group between Linux-Based SQL Server Instances. Part 1

SQL Server Always ON Availability Group is a solution meant to achieve high availability and disaster recovery for SQL Server databases. We can configure this functionality between the Windows-based SQL Server installations, Linux-based SQL Server installations, and even between Linux and Windows-based SQL Server installations together.

CodingSight - Understanding Always ON Availability Group between Linux-Based SQL Server Instances
Read More

How to Install SQL Server Tools on Ubuntu 18.04 Linux System – Step by Step

In the previous articles, we covered sequential steps necessary to build a virtual machine, install Ubuntu 18.04 operating system, and configure SQL Server 2019 on that Ubuntu machine. This is 3rd part of this series. Our goal is to demonstrate the step-by-step process of installing SQL Server Tools and its components on the Ubuntu 18.04 Linux system.

How to Install SQL Server Tools on Ubuntu 18.04 Linux System – Step by Step
Read More

Install SQL Server 2019 Ubuntu Linux Server Step by step

After exploring the processes of building a virtual machine to install Ubuntu Linux 18.04 there, and installing this OS in practice, we come to the primary goal. It is installing the SQL Server instance on our new Ubuntu Linux. If you don’t have the OS in question installed and configured yet, do it, following the step-by-step guideline in the previous article about installing Ubuntu 18.04 on a virtual machine. Now we can proceed to the task of installing SQL Server 2019 in that environment.

CodingSight - Installing Ubuntu on Linux
Read More

Installing Ubuntu 18.04 for SQL Server 2019 on Virtual Machine Using VMware Workstation

Microsoft has been supporting SQL Server for Linux-based operating systems since the SQL Server 2017 release. The current article will focus on installing one of the popular Linux operating system Ubuntu 18.04 and describe the process step by step. The goal is to install the latest SQL Server 2019 on this operating system. We have to perform each step correctly to configure SQL Server 2019 in your production environment or set up your own lab.

CodingSight - Installing Ubuntu for SQL
Read More