linux Archives - {coding}Sight https://codingsight.com/tag/linux/ Blog for SQL Server DBAs and Developers Tue, 27 Jun 2023 04:22:43 +0000 en-US hourly 1 https://wordpress.org/?v=6.5.2 https://codingsight.com/wp-content/uploads/2021/10/cropped-Soсial_-Fb_180х180-1-32x32.png linux Archives - {coding}Sight https://codingsight.com/tag/linux/ 32 32 Install SQL Server 2019 Ubuntu Linux Server Step by step https://codingsight.com/how-to-install-sql-server-on-linux-system-step-by-step/ Fri, 30 Apr 2021 08:34:08 +0000 http://codingsight.com/?p=13322 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 on a virtual machine if necessary), we come to the primary goal. It is to install MS SQL Server on Ubuntu. A side note before we proceed: This article focuses on using …

The post Install SQL Server 2019 Ubuntu Linux Server Step by step appeared first on {coding}Sight.

]]> How to install MySQL Server on Ubuntu 18.04 in 2 Different Ways https://codingsight.com/quick-guide-on-installing-mysql-on-ubuntu/ Thu, 18 Feb 2021 08:48:05 +0000 http://codingsight.com/?p=12108 This article will present the step-by-step installation process of the MySQL server on Ubuntu. For demonstration purposes, I created a virtual machine using Oracle VM virtual box and set up Ubuntu 18.04 on the virtual box. It’s important to note that this guide is suitable for installation on all versions of Ubuntu. I’d recommend you …

The post How to install MySQL Server on Ubuntu 18.04 in 2 Different Ways appeared first on {coding}Sight.

]]> Deploy SQL Server AlwaysOn Availability Groups on Linux https://codingsight.com/deploy-sql-server-alwayson-availability-groups-on-linux/ Fri, 11 Dec 2020 16:13:36 +0000 https://codingsight.com/?p=11020 In the previous article, I explained how we could install Ubuntu 18.04 and SQL Server 2019 on the virtual machines. Now, before we proceed further, let’s go through the configuration. We created three virtual machines, and the details are the following: Host Name IP Address Role LinuxSQL01 192.168.0.140 Primary Replica LinuxSQL02 192.168.0.141 Synchronous Secondary Replica …

The post Deploy SQL Server AlwaysOn Availability Groups on Linux appeared first on {coding}Sight.

]]> How to Install Ubuntu 18.04 and SQL Server 2019 on Linux https://codingsight.com/how-to-install-ubuntu-18-04-and-sql-server-2019-on-linux/ Mon, 30 Nov 2020 19:18:15 +0000 https://codingsight.com/?p=10700 The previous article explained the creation of a virtual machine using Oracle VM Virtual machine. Now, we will learn how to install Ubuntu 18.04 and SQL Server 2019 on Linux. Install Ubuntu Linux First, we need an operating system ISO file. Once the file is downloaded, we mount it on a virtual disk drive: Launch …

The post How to Install Ubuntu 18.04 and SQL Server 2019 on Linux appeared first on {coding}Sight.

]]> Сreating a Virtual Machine With Oracle VM Virtual Box https://codingsight.com/creating-virtual-machine-with-oracle-vm-virtual-box/ Wed, 25 Nov 2020 13:08:33 +0000 https://codingsight.com/?p=10658 Microsoft announced cross-platform support of SQL Server – the SQL Server 2017 and SQL Server 2019 work on Microsoft Windows and Linux. We can install SQL Server 2017 and higher on Red Hat Enterprise Linux, Ubuntu, and SUSE Enterprise Server. We can also set up high availability and disaster recovery mechanism for SQL Server on …

The post Сreating a Virtual Machine With Oracle VM Virtual Box appeared first on {coding}Sight.

]]> SQL Server 2019 New Features https://codingsight.com/sql-server-2019-new-features/ Thu, 14 Feb 2019 08:44:45 +0000 https://codingsight.com/?p=6220 Microsoft’s leading database is an essential tool, with in-cloud and on-premises versions providing incredible storage and analytic tools. It’s additionally turned into an essential application for data scientists, giving a structure to building and testing machine learning models. There is more in SQL Server, and the new release version can indicate where Microsoft thinks your …

The post SQL Server 2019 New Features appeared first on {coding}Sight.

]]> Overview of DMV Tool using DBFS FUSE with Docker Containers on Linux Machine – PART2 https://codingsight.com/overview-of-dmv-tool-using-dbfs-fuse-with-docker-containers-on-linux-machine-part2/ Tue, 18 Sep 2018 09:31:18 +0000 https://codingsight.com/?p=5225 After reading this article, you will be able to the following: Create a Linux Docker container using the Docker commands. Perform required configuration change to setup Docker. Install DBFS FUSE and related dependent packages. Mount the file-system and data extraction procedures using the configuration file. Run DBFS program to run custom SQL queries. Push Docker …

The post Overview of DMV Tool using DBFS FUSE with Docker Containers on Linux Machine – PART2 appeared first on {coding}Sight.

]]> Overview of DMV Tool using DBFS FUSE with Docker Containers on Linux Machine- PART1 https://codingsight.com/overview-of-dmv-tool-using-dbfs-fuse-with-docker-containers-on-linux-machine-part1/ Thu, 23 Aug 2018 18:22:20 +0000 https://codingsight.com/?p=5040 This article is intended for database administrators and system administrators who plan to configure the DBFS FUSE file-system on a Linux machine using the Docker containers. I would recommend reading the previous articles “Introduction to Docker and Docker toolbox” and “Docker and SQL Server on Linux”. This article assumes that the reader has a rough …

The post Overview of DMV Tool using DBFS FUSE with Docker Containers on Linux Machine- PART1 appeared first on {coding}Sight.

]]> Docker and SQL Server on Linux https://codingsight.com/docker-and-sql-server-on-linux-part-1/ Tue, 19 Jun 2018 12:30:08 +0000 http://codingsight.com/?p=4406 SQL Server 2017 is the biggest release and most important releases in the Microsoft product history simply because of the freedom that it gives to install the product anywhere. The advent of the Docker containers and growing emphasis on open source solutions opened the door to greater technological innovation and advancement. This article discusses the …

The post Docker and SQL Server on Linux appeared first on {coding}Sight.

]]> Getting Started with Mssql-cli Command-Line Query Tool https://codingsight.com/getting-started-with-mssql-cli-command-line-query-tool/ Fri, 11 May 2018 15:58:54 +0000 http://codingsight.com/?p=4042 A recent announcement on the release of several SQL Server tools has raised expectations across various groups. Product requirements and business are almost always a trade-off, and striking the right balance in a product in terms of the toolset is a sign of a successful product. After testing the SQL Operations Studio, I feel that it’s …

The post Getting Started with Mssql-cli Command-Line Query Tool appeared first on {coding}Sight.

]]>