Not all questions require a video answer. Here are some simple no-brainer ones:
Q: BehindTheScenesDBA: With all its limitations, what do you think about memory-optimized tables? Have you recommended to a client to use it?
A: They don’t make any sense for the vast, vast, VAST majority of clients, and no, I’ve never recommended them. In-memory temp tables are different though, and I cover when to use those in this module of my Fundamentals of TempDB class.
Q: Sultan: Does this mean Azure storage is now as fast as a Y2K SAN?
A: Well, a couple of VM types are now competitive