I'll be forever grateful to John for:
- Ctrl+R in SSMS
- Ctrl+H with 'Use: Regular expressions'
- and the wisdom of using Portable Apps on Production servers
John blogged a lot at SQL Blog, and I would expect his posts to remain online for the foreseeable future. The blog archive is a great reference source, but I can't imagine it will compare to the peculiar charm John has in person. I would love to have John Paul Cook as a teacher. But at least the digitization of medical records will be in good hands.