June 2013 - SQLPerformance.com

Optimization Phases and Missed Opportunities

Posted by Paul White on June 26, 2013 15 Responses »

Jun 262013

Paul White (@SQL_Kiwi) talks about optimization stages and explains how to get more insight into missed opportunities.

Prepare a new VM for SQL Server 2014 CTP1

Posted by Aaron Bertrand on June 25, 2013 6 Responses »

Jun 252013

Aaron Bertrand (@AaronBertrand) of SQL Sentry gives some quick advice about SQL Server 2014 CTP1: Plan to install it in its own virtual machine, because at this point it doesn't play well with others.

Avoid HA/DR Solution Self-Delusion

Posted by Joe Sack on June 18, 2013 1 Response »

Jun 182013

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.

Attention users running SQL Server 2008 and SQL Server 2008 R2

Posted by Aaron Bertrand on June 17, 2013 7 Responses »

Jun 172013

Aaron Bertrand (@AaronBertrand) of SQL Sentry points out a recent swapping out of cumulative updates for SQL Server 2008 and SQL Server 2008 R2.

SQL Server Standard Edition High Availability Futures

Posted by Glenn Berry on June 11, 2013 2 Responses »

Jun 112013

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.

Don't just blindly create those "missing" indexes!

Posted by Aaron Bertrand on June 6, 2013 13 Responses »

Jun 062013

SQL Sentry'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.