SQL Server 2017 adds a new DMF, sys.dm_os_file_exists, a replacement of xp_fileexist that suits both Windows and Linux. Here is how to use it.
SQL SERVER – New DMV in SQL Server 2017 – sys.dm_os_enumerate_fixed_drives. A Replacement of xp_fixeddrives
SQL Server 2017 adds sys.dm_os_enumerate_fixed_drives, a new DMV that shows free space on each drive and replaces xp_fixeddrives. Here is the query I use.
TRIM Function in SQL Server: SQL in Sixty Seconds #040
The TRIM function removes spaces from the ends of a string, and SQL Server has had it since 2017. The tests here show which characters TRIM leaves behind, the LEADING and TRAILING keywords, and a WHERE clause that read 884 pages against 3.
Modeling Friends and Followers With SQL Server Graph Tables
Build SQL Server graph tables for follows, mutual connections and friends of friends, then use shortest paths and compare a junction table.