SQL Server 2017 introduces a set of useful functions like STRING_AGG(), STRING_SPLIT(), TRIM()… and many more. In this tip, I am going to discuss one of the built-in aggregate functions – “STRING_AGG()”. The function concatenates values from rows as one value with a separator, and the main advantage is it doesn’t add the separator at the […]
Change the name of master database files – SQL Server on Linux
Read more
In my recent blog, I discussed about how to move master database to another location. One of the readers requested to blog about renaming the master database files. So, we are going to explore step by step process of renaming the files in this blog. Change the name of master database files Connect to SQL Server […]
Enable or Disable SQL Server Service on Linux
Read more
In my previous blog, we walked through how to Stop, Start or View SQL Server Service Status on Linux. If you find SQL Server service is disabled or you want to disable or enable it, how would you do it on Linux system? It may sound very basic step, but if you don’t know the […]