Read Statistics Histogram using DMV

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. […]

Read more
SQL RPM package details On CentOs System

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. […]

Read more
Main File Directory Structure of SQL Server on Linux

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 […]

Read more
Uninstall SQL Server Tools on Ubuntu System

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 […]

Read more
Uninstall SQL Server on Ubuntu System

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 […]

Read more
An in-depth look at mssql-server.service file on SQL Server on Linux

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 […]

Read more
top or htop to check the health of SQL Server on Linux

Being a Windows user, your first place to check the health of SQL Server is Windows task manager. Since Microsoft has launched SQL Server on Linux operating system, you might be wondering how to check the health of SQL Server on Linux machine now. You can use classical Linux task manager by running the “top” […]

Read more
SQL Debian package details On Ubuntu System

A curious mind knows no limits. I was exploring the public preview of SQL Server on Linux to figure out what all the packages get installed during a complete installation (SQL Server, SQL Server Tools, and ODBC) of SQL Server on Linux. I ended up with a couple of interesting findings and thought to write […]

Read more