SQL Server Pain Relief: Office Hours

By Brent Ozar

SQL Server Pain Relief: Office Hours is like listening in while patients bring their SQL Server pains to the emergency room, and the doctors give their opinions. Join your host, performance tuning spe... more

Download on the App Store

Download on the App Store

Get it on Google Play

FAQs about SQL Server Pain Relief: Office Hours:

How many episodes does SQL Server Pain Relief: Office Hours have?

The podcast currently has 96 episodes available.

SQL Server Pain Relief: Office Hours episodes:

November 23, 2016 Office Hours - 11/23/2016
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.
...more
36min
November 16, 2016 Office Hours - 11/16/2016
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.
...more
31min
November 09, 2016 Office Hours - 11/09/2016
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!
...more
27min
November 02, 2016 Office Hours - 11/02/2016
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.
...more
36min
October 19, 2016 Office Hours - 10/19/2016
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.
...more
37min
October 12, 2016 Office Hours - 10/12/2016
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.
...more
35min

FAQs about SQL Server Pain Relief: Office Hours:

How many episodes does SQL Server Pain Relief: Office Hours have?

The podcast currently has 96 episodes available.