Erin Stellato uses a simple example to demonstrate the performance benefits you might expect from enabling memory-optimized tempdb metadata in SQL Server 2019.
Glenn Berry explains why, if given the choice, the next time you purchase hardware to run SQL Server, you should opt for AMD instead of Intel processors.
Itzik Ben-Gan describes nested window functions and how they could simplify some tedious query scenarios. He asks for your help voting for these to be included in SQL Server.
Tim Radney talks about some of the typical SQL Server mishaps he comes across out in the wild, and resources you can use to avoid them in your own environments.
