In this article, we will learn to install SQL Server 2019 on the RedHat Linux 18 on a virtual machine.
Read more »
Linux
Configure an iSCSI initiator in Ubuntu 18.04
November 26, 2020In this article, I am going to explain how we can configure iSCSI initiator and iSCSI target server on ubuntu 18.04. In my previous article, we have learned the step by step configuration process of configuring the iSCSI target and initiator in Windows Server 2016. The following are the links to these articles:
Read more »
Install SQL Server Linux (2017 version) on SUSE Linux in Amazon EC2 instance
October 26, 2020In this article, we will install and configure SQL Server Linux (2017 version) on SUSE Linux in the Amazon EC2 Instance.
Read more »
SQL Server Always On Availability Groups for SQL Server Linux instances
October 6, 2020In this 29th article of the SQL Server Always On Availability Groups series, we configure the AG between SQL Server Linux instances.
Read more »
![user database [LinuxAGSQL]](https://s33046.pcdn.co/wp-content/uploads/2020/10/user-database-linuxagsql-624x475.png)
Restore a SQL database from Windows SQL Server to SQL Server Linux instance
October 5, 2020Database professionals get the standard requirement for SQL database restores from production to non-production instances. As you know, SQL Server runs on the Linux and Windows operating systems starting from SQL Server 2016. Suppose you are exploring the SQL Server Linux instance features and configurations.
Read more »
Deploy MySQL InnoDB Clusters for high availability
May 8, 2020In this article, I am going to explain how we can deploy the MySQL InnoDB cluster. InnoDB Cluster is a high availability solution provided by MySQL that has single and multi-master capabilities and failover detection.
Read more »
How to connect to a remote MySQL server using SSL on Ubuntu
April 28, 2020In this article, the steps to connect to remote MySQL databases using Secure Sockets Layer (SSL) will be shown. MySQL is one of the most popular relational database management systems and by default, is configured to accept only connections from the machine where MySQL is installed. To connect to the MySQL database which sits on another machine, the additional configuration must be set to accept the remote connection with secure SSL encryption.
Read more »
SQL Server Linux installation for Amazon EC2 instance with Red Hat OS
January 9, 2020This article installs SQL Server on Linux on the Amazon EC2 instance with Red Hat OS prepared in the earlier article.
Read more »
Installation of SQL Server Linux on Red Hat in Amazon EC2 instances
December 17, 2019This article explores the configuration of the Red hat Amazon EC2 instance for SQL Server installation.
Read more »
Using SSH keys to connect to a remote MySQL Server
November 28, 2019In this article, it will be described how to connect to remote MySQL Server on Linux OS using SSH key pairs. Windows OS will be used as a host from which will be established a connection using PuTTY as a client. Besides using PuTTY as a client for establishing the connection to remote machines, it will be used to generate and use secure shell – SSH keys as well.
Read more »
How to Connect to a Remote MySQL Server Using SSH
October 18, 2019This article will explain how to set up a connection from a Windows host OS using a PuTTY client to a remote MySQL server on Linux Ubuntu 18.04.
Read more »
SQL Server Transactional Replication on Linux
September 12, 2019In this article, we will talk about how to send the SQL Server Transactional Replication on Linux Environment.
Read more »
Creating your own SQL Server docker image
September 9, 2019In this article, we will review how to create custom SQL Server docker images and run the containers from the custom images, upload the custom images to the docker hub.
Read more »
SQL Server Merge Replication on Linux
August 15, 2019Replication is a process to manage multiple copies of the same data at a different node. Microsoft SQL Server supports Merge Replication, Transaction Replication, Peer to Peer Replication and Snapshot Replication.
Read more »
Azure Kubernetes Service (AKS) – Managing SQL Server database files
June 18, 2019In this article, we will review on managing database files of SQL Server running on Azure Kubernetes service.
SQL Server in Kubernetes Cluster using KOPS
May 24, 2019In this article, we will review how to create a Kubernetes cluster in AWS using KOPS, provision Elastic Block Store (EBS) as persistent volume to store the database files and deploy SQL Server in the K8s cluster.
Read more »
SQL Server in Azure Kubernetes Service (AKS)
May 22, 2019In this article, we will review how to create a Kubernetes cluster in Azure Kubernetes Service, provision the persistent volume to store the database files and deploy SQL server on Kubernetes cluster.
Read more »
Change default database file and backup paths in SQL Server on Linux
January 10, 2019In a previous article, we explored the process to change default SQL dump file location in SQL Server. In this article, we will view the process to change the default database files and backup locations in SQL Server on Linux.
Read more »
Uninstalling SQL Server on Ubuntu
December 31, 2018We learned to install SQL Server 2019 installation on Ubuntu without a Docker Container in one of my previous articles, but we might also get a request to uninstall SQL Server running on Ubuntu as well. Both the installation and the uninstallation of SQL Server is different in Linux than of Windows OS. In windows, we can remove or uninstall any program using the add or remove programs feature. In Ubuntu, We need to run the commands in order to uninstall the programs. However, before performing uninstallation, we need to take care of the below point.
Read more »
Monitoring Disk Space on Linux – Helpful Commands for SQL Server DBAs
December 25, 2018In this article, we will explore the different Linux commands related to the disk space.
- ‘ls’ command
- ‘df’ command
- ‘du’ command
Changing SQL Dump file locations in SQL Server on Linux
December 24, 2018In this article, we will talk about SQL Dump files and the process to change the dump directory in Linux SQL Server.
Renaming a SQL Server instance on Ubuntu Linux
December 20, 2018In my previous articles, we installed the SQL Server 2019 CTP 2.1 on Ubuntu Linux. You can follow the below articles to prepare the SQL instance on Linux.
Helpful Linux commands for SQL Server DBAs – iotop and iostat
December 13, 2018In the article, we will learn how to use the ‘iotop’ and ‘iostat’ commands with various configuration options.
Renaming Logical and Physical file names in SQL Server on Linux
December 12, 2018Each database in SQL Server contains at least two files i.e. Data file (*.mdf) and log file (*.ldf). These database files have a logical name and the physical file name. Below we can view the simple architecture of a database in SQL Server.
Helpful Linux commands for SQL Server DBAs – top
December 11, 2018SQL Server 2017 and SQL Server 2019 supports both the Linux operating system. As part of performance troubleshooting or monitoring resources in Windows system, we need to check certain things like disk space, CPU or Memory consumption, check running processes, uptime etc. We can get the information, on a windows based SQL server, from the task manager.
