Since Microsoft has launched SQL Server on Linux, you would be working on both the platforms Linux and Windows. You can now add Bash shell on Windows 10 to play with SQL Server on Linux instead of using any third party tool like Putty or other SSH clients. Note: Bash/WSL is still in “beta” version. It […]
Install SQL Server Agent on Ubuntu (Linux)
Read more
With the release of SQL Server vNext CTP 1.4, the SQL Server Agent support is included. It enables DBAs to schedule any task using a SQL Server Agent Job on Linux machine. In this post, I will explain how to install the SQL Server Agent package on the Ubuntu system. Before you start installation SQL […]
SQL SERVER ON LINUX INSTALLATION – PART4 – Install SQL Server Tools on Ubuntu – Updated!
Read more
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. […]
Main File Directory Structure of SQL Server on Linux
Read more
During the exploration of the SQL Debian package, we discussed what all the files get installed at which location on Linux machine. However, there are some important folders and files which I would say to remember when you are working on Linux machine. You may find them helpful, if you want to troubleshoot some issue or want to […]
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 […]