Glenn Berry (@GlennAlanBerry) of SQLskills.com discusses all of the recent hoopla about Database Mirroring being deprecated and what that may mean for Standard Edition customers 6-10 years from now.
SentryOne's Aaron Bertrand (@AaronBertrand) discusses a few additional places to get information useful for decisions about creating new indexes that are suggested as "missing" by various tools.
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.
Aaron Bertrand (@AaronBertrand) discusses some obstacles he recently encountered when configuring an Availability Groups lab environment and how some assistance from the community helped him isolate and solve the issues.
Aaron Bertrand (@AaronBertrand) of SQL Sentry discusses a couple of advantages and a hefty list of limitations with filtered indexes in SQL Server 2008 and above, with links to no less than 36 Connect items!
SQLskills' Joe Sack (@josephsack) walks us through an interesting scenario where we might blame a query performance issue on parameter sniffing or bad statistics, when it actually turns out that a check constraint is the best solution to keep the optimizer honest.
