SQL Server Pain Relief: Office Hours

This week, Brent and Richie discuss their hardware setups, lazy spools, SQL 2016 Service Pack 1, Always On Availability Groups, Database IDs, GroupBy.org, SQL on Linux, and new features they would like to see in the new version of SQL.

This week Richie, Tara, and Erik discuss replication, mirroring, memory grants, sp_BlitzCache, failover cluster instances, VLFs, restoring databases, qualifying schema and object names, multiple instances, and table variables.

This week Richie and Erik discuss log backups, migrating from SQL 2008 R2 to 2014, shrinking databases, tuning long-running queries, execution plans, sequencing, encryption, and much more!

This week, Brent, Richie, Tara, and Erick, discuss vendor licensing, rebuilding indexes, analysis services, using trace flag 174, and the team's PASS Summit impressions and highlights.

This week, Brent answers your questions about table partitioning, best practices for vmware configuration, rebuilding indexes, transitioning from physical SQL failover cluster to vmware or hyper-v, database backups, security issues with cross-database chaining, and why you should never use vague adjectives when describing database sizes.

This week, Brent, Richie, and Erick, discuss estimating compression savings, disabling triggers, suggestions to first-time Pass Summit attendees, tools for database version control, transitioning from SQL 2000 to 2016, troubleshooting failovers, and how to convince your manager to upgrade to newer version of SQL.