Tag: linux

SQL Server 2019 New Features

Amarendra Babu

SQL Server 2019

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 data needs will go over the next few years.

Like all the previous versions, the Microsoft SQL Server 2019 latest version is also jam-packed with new features and capabilities. It will help organizations evaluate and test relational data with multiple integrations of various software. By creating a simplified view of data, users can have a comprehensive view of information.

Read More

Overview of DMV Tool using DBFS FUSE with Docker Containers on Linux Machine – PART2

Prashanth Jayaram

After reading this article, you will be able to the following:

  1. Create a Linux Docker container using the Docker commands.
  2. Perform required configuration change to setup Docker.
  3. Install DBFS FUSE and related dependent packages.
  4. Mount the file-system and data extraction procedures using the configuration file.
  5. Run DBFS program to run custom SQL queries.
  6. Push Docker container image to GitHub repository.
  7. And more…

Read More

Overview of DMV Tool using DBFS FUSE with Docker Containers on Linux Machine- PART1

Prashanth Jayaram

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 knowledge of the Docker Containers and SQL Server. Read More

Docker and SQL Server on Linux

Prashanth Jayaram

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 following topics:

  1. Introduction to Docker container
  2. Pre-requisite to build Docker container
  3. A walkthrough of the setup process to build a SQL Server instance running on the Linux CentOS and in a Docker container
  4. How to connect to the database engine
  5. How to connect to the database engine externally
  6. And more…

Read More

Getting Started with Mssql-cli Command-Line Query Tool

Prashanth Jayaram

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 a promising tool for many developers, administrators, and DevOps specialists. In my opinion, the mssql-cli tool adds another feature to SQL Server in order to make it a leading database product.

Read More

Getting Started with SQL Server 2017 on Linux in the Azure portal

Prashanth Jayaram

SQL Server 2017 now is considered as a hybrid database enterprise solution as it expands its market and is ported to other operating system platforms. It also includes mainstream support for Linux machines. The Cloud makes the life of administrator much easier, now it’s no longer daunting task to configure the SQL Server instance. The easiest way to explore SQL Server on Linux is to provision a virtual machine through Microsoft Azure portal – portal.azure.com. The Linux azure virtual machine will come pre-configured with Linux and SQL Server 2017.

Read More