Info

SQL Server Pain Relief: Office Hours with Brent Ozar Unlimited®

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 specialist Brent Ozar, and his highly-qualified SQL Server Medical Team as they give you an inside look into some of the best solutions to your server problems. Tune in to get the best tips for performance tuning, virtualization, disaster recovery and much more. When you’re ready to do your own surgery, grab our free First Responder Kit at www.BrentOzar.com.
RSS Feed
SQL Server Pain Relief: Office Hours with Brent Ozar Unlimited®
2017
August
July
June
May
April
March
February
January


2016
December
November
October
September
August
July
June
May
April
March
February
January


2015
December


All Episodes
Archives
Now displaying: February, 2017
Feb 22, 2017

This week, Erik, Tara, and Richie discuss clustered and unclustered indexes, query timeouts, fill factor, mirroring vs. log shipping, IO tests, temp tables and common table expressions, and tempdb spills.

Feb 15, 2017

This week, Erik, Tara, and Richie discuss tempdb etiquette for developers, elastic search vs full-text search, server CPU spiking issues, source control in a database project, querying transaction logs, and more.

Feb 8, 2017

This week, Brent, Erik, Tara, and Richie discuss compatibility levels, SQL server SPN problems, Always On Availability Groups,  failover clustering, capturing DML stuff, disc defragmentation, replication snapshots and reindexing, load testing, PowerShell, and whether you should pursue the path of a DBA.

Feb 1, 2017

This week, Brent, Erik, and Richie discuss AlwaysOn Availability Groups, execution plans, speeding up log shipping, applying wrong service packs, why servers "page wildly" when copying mid to large-size files from one SQL server to another, their favorite high availability solutions, and much more!

1