2020-07-24 (first published: 2018-12-27)
4,106 reads
Evgeny Garaev
2020-07-07
543 reads
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,735 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)
835 reads
2019-09-26
562 reads
2019-08-27
816 reads
2019-08-16
614 reads
2019-08-01
918 reads
2019-07-23
5,939 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
2,289 reads
Blogs
It’s 2021, so why are you reading this?
If you’re reading this, there’s a good chance you’re straight, white, male, and English-speaking....
Daily Coping 20 Jan 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
[Coping] Hidden Wounds
By Brian Kelley
Through high school and college, I carried deep wounds due to what was going...
Forums
Find unmatched between 2 tables using field as selection criteria
I have the following tables as a example. Table 1 EmpID, LastName, FirstName 1,Smith,John...
update using self-join - confirm it looks at old values
I'm doing an update using a self-join, and just want to confirm something. If...
Representative Data Challenges
Comments posted to this topic are about the item Representative Data Challenges
Ask SSC