Installing SQL Server on Linux does not install SQL Server tools by default. You have to install it individually. In my previous posts of this series, I discussed how to create a virtual machine using Windows Hyper-V, how to install Ubuntu Server on the created virtual machine and how to install SQL Server on the […]
Read Statistics Histogram using DMV
Read more
DMV: sys.dm_db_stats_histogram (object_id, stats_id) For a long time, the DBCC SHOW_STATISTICS command was the only way to get information about statistics. It displays current query optimization statistics for a table or indexed view. It was always a painful task, if you wanted to capture output of the DBCC SHOW_STATISTICS for all tables in one go. […]
New String Function – TRIM – in SQL Server vNext
Read more
As SQL developer, you must have often come across a scenario where you need to remove the empty spaces at the beginning and the end of the string. To achieve that, you may have used the string functions RTRIM and LTRIM. You may wish to have the TRIM function in SQL Server as it is […]
SQL RPM package details On CentOs System
Read more
You have already explored the installation of SQL Server and SQL Server tools on CentOs. In this post, we will see what all the packages and files get installed during the SQL Server installation on Linux (CentOs) using rpm package manager but before let’s first understand; What is RPM? RPM originally stands for Red Hat Package Manager. […]
Uninstall SQL Server Tools on Ubuntu System
Read more
If you remember, Installing SQL Server on Linux does not install SQL Server tools by default. You have to install it separately. The same way when you uninstall SQL Server, it won’t uninstall mssql-tools, you have to uninstall separately. In the previous blog post, we discuss how to uninstall mssql-server on Ubuntu System. Here, we […]
Uninstall SQL Server on Ubuntu System
Read more
There are scenarios where you want to uninstall the SQL Server vNext CTP1. This blog describes how to uninstall Microsoft SQL Server on Ubuntu system. It will completely remove Microsoft SQL Server along with repository, data directories, and binary of the SQL Engine. Note: During uninstall mssql-server package, it does not remove all the files […]
SQL Server Package Installation Requirements on Ubuntu, RHEL, & Docker
Read more
This blog provides a walkthrough of SQL Server Package Installation requirement for Ubuntu, RHEL & Docker. When you are going to install SQL Server vNext CTP1, you make sure that you are meeting the package installation requirement as per Operating System. Requirements for package installation on Ubuntu Ubuntu 16.04 Minimum of 3.25 GB of RAM […]
An in-depth look at mssql-server.service file on SQL Server on Linux
Read more
In previous blogs, we discuss how to Stop, Start, View, and Enable or Disable SQL Server Service on Linux. Here, we will be discussing mssql-server.service file and will also be talking about dumping the ELF binary file “/opt/mssql/bin/sqlservr” to see – it calls what all the sfp files. The mssql-server.service is a configuration file. It […]
SQL Server ON Linux Installation – Part1 – Install SQL Server on CentOS
Read more
In the previous post, we learned how to install SQL Server on Ubuntu Server. Today, we will learn how to install SQL Server on CentOS. The CentOS is a community driven free operating system. I would like to highlight that Microsoft does not officially support SQL Server on CentOS. But, installing SQL Server on CentOs […]
SQL Server Configuration Manager on Linux
Read more
The mssql-conf is a configuration tool that installs with SQL Server vNext for both Red Hat Enterprise Linux and Ubuntu systems. You can think of this tool as a replacement for SQL Server Configuration Manager which exists on Windows. It allows you to initialize multiple configuration options for the SQL engine. This tool creates a configuration […]