Paul White (@SQL_kiwi) talks about a regression in the optimizer's handling of aggregates against partitioned tables when moving from SQL Server 2005 to SQL Server 2008+.
Paul White (@SQL_Kiwi) continues his discussion about optimization and how recognizing transformations can help you make better decisions about potential query re-writes.
SQLskills.com's Joe Sack (@josephsack) discusses some of the assumptions people can make when deciding on high availability / disaster recovery solutions they're going to use with SQL Server.
Paul Randal (@PaulRandal) of SQLskills.com discusses the myth that DROP and TRUNCATE operations are not logged, and shows that this is simply not true.
Wanted to give a heads-up about some of the sessions we're presenting at PASS Summit, some great pre-conference seminars, and a contest you'll really want to consider entering in June and July.
Jonathan Kehayias (@SQLPoolBoy) of SQLskills.com takes a look at snapshot performance, with some surprising observations about what happens if you have more than one concurrent snapshot.
Aaron Bertrand (@AaronBertrand) talks about a subtle way that ad hoc queries can interfere with SQL Server performance by taking up more space in the plan cache than they really need.