Azure SQL Database or Managed instance is a Microsoft cloud offering for SQL Server in the managed cloud environment. Usually, we connect databases from SQL Server Management Studio, Azure Data Studio, or applications for query data.
Read more »
Ubuntu
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 »
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 »
How to install MySQL on Ubuntu
March 10, 2020In this article, it will be shown how to install MySQL 5.7 and 8.0.19 versions on an Ubuntu 18.04 machine.
Read more »
SQL Server Installation & Troubleshooting on Ubuntu
August 15, 2019A couple of years ago, Microsoft announced that SQL Server would be available on Open Source (Linux). In this article, we will go through the installation of Microsoft SQL Server on Linux (Ubuntu) and each step in detail.
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 »
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.
SQL Server 2019 installation on Ubuntu without a Docker Container
December 10, 2018Until now, we learned to install and configure SQL Server 2019 using the Docker container. In this article, we will directly install SQL Server on the Ubuntu Linux and explore more on this.
SQL Server 2019 on Linux with Ubuntu
November 29, 2018In my previous articles, we installed SQL Server 2019 on the windows environment (vs Linux / Ubuntu). We also explored some of the important enhancements in SQL Server 2019
SQL Server 2019 on Linux with a Docker container on Ubuntu
November 29, 2018In the first article of the series on SQL Server 2019 and Ubuntu, we prepared the virtual machine environment and installed Ubuntu 18.10 in it. In this part of the article, we will install the latest SQL Server 2019 Preview CTP 2.1.
Read more »
SQL Server 2019 on Linux with Ubuntu and Azure Data Studio
November 29, 2018In the previous articles of this series on using SQL Server 2019 on Ubuntu, we have explored the following
Read more »