Understanding SQL Server Lockdown to Secure Database Environment
Security is the main concern these days in every sector. Database Security is also a major worry...
How to Change Server Level Collation of Running SQL Server Instance
In my previous article I have explained the basics of SQL Server Collation. I would suggest you first read that article (if you haven’t...
How to Change Database Collation in SQL Server: Step-by-Step Guide
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...
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...
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...
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...
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...
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 (refer to the step-by-step guideline about...
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...
