Aaron Bertrand (@AaronBertrand) shows a quick demo that illustrates why you should be very careful about oversizing varchar / nvarchar columns.
Tim Radney of SQLskills walks through multiple automation methods you can use to manage and maintain your Azure SQL Databases.
Jonathan Kehayias of SQLskills discusses SQL Server on VMware, and how to monitor CPU performance – with or without access to vCenter.
Paul Randal (@PaulRandal) explains how the SQLskills Wait Types Library uses anonymous data from SentryOne to indicate whether a wait type is commonly experienced.
Paul White (@SQL_Kiwi) takes you on an optimizer journey, exploring how SQL Server comes up with cardinality estimates for COUNT queries.
Guest author Derik Hammer (@SQLHammer) dismisses the common myth that table variables perform better than #temp tables because they are always in memory.
Glenn Berry (@GlennAlanBerry) explains why you need to be very careful about your physical processor choice when configuring servers to run SQL Server 2016 Standard Edition.
Aaron Bertrand (@AaronBertrand) kicks off his "Performance Myths" series, showing a "redundant" non-clustered index outperforming the clustered index with the same key.
Aaron Bertrand (@AaronBertrand) begins a new series aimed at debunking common myths about SQL Server performance.
Erin Stellato demonstrates how to use the new DBCC CLONEDATABASE feature, in combination with Query Store, to test index and query changes.