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 […]
SQL SERVER ON LINUX INSTALLATION – PART4 – INSTALL SQL SERVER AGENT ON RHEL
Read more
In my previous tips, I explained about install RHEL Server on the virtual machine, install SQL Server 2017 on Red Hat Enterprise Linux, and Install SQL Server Command-Line Tools on RHEL. In this tip, I will explain how to install SQL Server Agent on a Linux server, so we can create SQL Server jobs to schedule repetitive work. […]
SQL SERVER ON LINUX INSTALLATION – PART2 – INSTALL SQL SERVER ON RHEL
Read more
In the previous blog, we discussed how to install RHEL Server on the virtual machine. In this quick tutorial, we will install SQL Server 2017 on Red Hat Enterprise Linux (RHEL). Connect to the RHEL virtual machine and log on to the server by keying username and password Switch to root user (superuser) su root […]
SQL Server 2017 – DMV – sys.dm_os_host_info
Read more
I always love to get my hands dirty with new features of SQL Server. I was exploring SQL Server on Linux, and at a point, I had to check the operating system details of the Linux system. Being lazy to figure out Linux OS command to check the operating system details, I started figuring out […]
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 2017 – DMF – sys.dm_db_log_info
Read more
The release of Microsoft SQL Server 2017 brought a lot of very interesting new features. One of them is the addition of DMF sys.dm_db_log_info. It allows having a look at the structure of the transaction log without using the undocumented DBCC LOGINFO command. DMF – sys.dm_db_log_info It returns VLF information of the transaction log file […]
SQL Server 2017 sys.dm_os_enumerate_fixed_drives
Read more
In SQL Server 2017, you can use the new DMV sys.dm_os_enumerate_fixed_drives to identify free disk space. The DMV is replacement of xp_fixeddrives. Old way XP_FIXEDDRIVES New Way SELECT * FROM sys.dm_os_enumerate_fixed_drives; I wish Microsoft could have included the capacity of the drive. Not including the drive capacity requires the DBA to perform additional computations to […]
SQL Server 2017 – The operating system returned the error 21
Read more
Recently, I was exploring SQL Server 2017 CTP 2.0 using SQL Server Management Studio V17. Till the time, I was restoring the databases using tsql script on the SQL Server 2017 instance, and I didn’t encounter any issue. But, When I tried to restore a database backup using GUI using SSMS V17, I encountered the […]