2020-07-07
328 reads
Evgeny Garaev
Logshipping to SQL Server on Linux
An example of a database migration from SQL Server 2016 on Windows to MS SQL Server 2017 on Linux.
2020-06-25 (first published: 2018-06-05)
1,543 reads
Disk space used by the SQL Server instance
I have found this query valuable. Sometimes you need to see just overall consumption without any detailed information. It is also useful in overall trend analysis and disk space planning.
2020-06-16 (first published: 2020-06-12)
464 reads
2019-09-26
559 reads
2019-08-27
807 reads
2019-08-16
601 reads
2019-08-01
910 reads
2019-07-23
5,042 reads
Offline R Services installation and patching
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.
2019-03-28
1,508 reads
2019-03-14
949 reads
Blogs
Spark .NET - Spark ML TF-IDF
By Ed Elliott
Spark ML in .NET for Apache Spark Spark is awesome, .NET is awesome, machine...
Daily Coping 7 Jul 2020
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
Publish ADF from code to further environments
By Kamil
Struggling with #ADF deployment? adf_publish branch doesn’t suit your purposes? Don’t have skills with PowerShell? I have good...
Forums
Help needed in checking dates spans and status
Hello All, I have a requirement where we need to merge spans if the...
List of all OWNERS, not db_owner
How can I get a list of all database owners in an instance (not...
Document recovery procedure
Trying to document a process in an event of disaster and different reasons. In...
Ask SSC