Found this useful for database migrations. This helps to identify how much space will need to be allocated for a new server and how a SQL Sever instance is using discs currently.
Note. This won't show correct information on Linux instances and if you use mounting points in Windows.
SELECT SUBSTRING(physical_name, 1, 3) DiskDrive, (8.0*sum(size))/1024/1024 GB FROM sys.master_files GROUP BY SUBSTRING(physical_name, 1, 3);
2019-08-01
960 reads
2019-07-23
10,342 reads
The R Services installation package is not included in the MS SQL Server installation package. When you install MS SQL Server with R Services the installer actually download the package from the Internet.
2021-02-12 (first published: 2019-03-28)
8,648 reads
2020-07-24 (first published: 2018-12-27)
4,683 reads
An example of a database migration from SQL Server 2016 on Windows to MS SQL Server 2017 on Linux.
2020-07-09 (first published: 2018-06-05)
2,356 reads
