Aaron Bertrand announces the first update (0.9.6) to the SentryOne Plan Explorer extension for Azure Data Studio. Find out what's in it and how to get it.
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.
