Info

SQL Server Pain Relief: Office Hours

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
2019
January


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


2017
December
November
October
September
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: November, 2018
Nov 28, 2018

This week, Brent, Tara, and Richie discuss storing phone numbers in a database, forced parameterization, how AI will affect DBA jobs in the future, what languages a DBA needs to learn, backup issues, measuring the overhead of transparent data encryption in terms of CPU on SQL Server, starting SQL server without tempdb, and much more!

Nov 21, 2018

This week, Brent, Tara, and Erik discuss update statistics, how soon it is safe to use a new version of SQL Server, VMs vs physical servers, backups, disabling TCP Chimney Offset in VMware, SQL Server on Linux, performance troubleshooting, most valuable tools to have in your SQL Server DBA toolkit, nolock and read uncommitted, and more.

Nov 14, 2018

This week, Tara, Erik, and Richie discuss using Docker in dev environment, in-place upgrades, disaster recovery, the minimum amount of CPU and RAM for new SQL Server VMs, troubleshooting long-running SQL agent jobs, dbcc checkdb running longer than normal, and more.

Nov 7, 2018

This week, Tara and Richie discuss offline file database and log backup solutions, VSS database backups, monitoring products, parameterization, page latch waits, SQL ConstantCare™, and Availability Groups on 2017 Standard Edition.

1