the sql dba community must be very small, he knows everyones names :D. i've been a dba for 4 years now, and got a job as a jr dba at a Microsoft Gold partner company,and the first thing they mentioned to me me was look up Brent Ozar and ola Hallengren.
15:50 That is why, in 2019, you need to bounce Windows machines regularly. Servers, clients, old, new, whatever. Linux and Unix actually have good memory management and don't need regular bounce, at least not for this reason.
18:30 Copying big files between host and RDC sessions must be the worst thing to do, since it is using the memory of the host, the memory of the client session, and the network, but in a way it wasn't designed cause it is not a slim command (like XCOPY) but part of the Windows clipboard function, which is written to copy 7 bytes content on average (text or file). Not to mention it tends to be slow.
I don't buy what he's saying about the file caches. Why would Windows continue to cache data from disk if SQL Server's in a position to actively request it from the OS? That's not the behavior for *other* types of operations, after all, so I'm not sure why SQL Server would be treated different from another application.
16:40 Agreed to be careful what software to trust, but if it was written by Mark Russinovich, I don't know what more of a clue you are waiting on to get "better" fixes. Remember, MS bought software from this one guy. Some people really think that the vendor is the almighty, and everybody else is stupid.
