Himalaya: Listen. Learn. Grow.

4.8K Ratings
Open In App
title

SQL Server Pain Relief: Office Hours

Brent Ozar

6
Followers
3
Plays
SQL Server Pain Relief: Office Hours

SQL Server Pain Relief: Office Hours

Brent Ozar

6
Followers
3
Plays
OVERVIEWEPISODESYOU MAY ALSO LIKE

Details

About Us

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.

Latest Episodes

Office Hours - 1/2/2019

This week, Brent, Erik, Tara, and Richie discuss whether you need to premake a destination database in order to run sp_databaserestore, restoring production statistics on dev servers to simulate productions behavior, dealing with duplicate SPNs, tools for detecting all SQL Servers in a production environment, SQL performance monitoring, dealing with very large indexes, and Brent's recent cruise.

17 min2019 JAN 3
Comments
Office Hours - 1/2/2019

Office Hours - 12/19/2018

This week, Erik, Tara, and Richie discuss disaster recovery, Python vs C# for SQL Server, whether you should perform log backups on primary or secondary on AGs, why Postgres is so popular, using mount points for tempdb, attention events, database corruption, MERGE statements, restoring a table from a database, features they look forward to in SQL Server 2019, and how Santa is able to visit all those homes in one night...

29 min2018 DEC 20
Comments
Office Hours - 12/19/2018

Office Hours - 12/12/2018

This week, Erik and Richie discuss TSQL classes, scalar functions, index reorganize vs rebuild, daily image backups on a fringe SQL server on VMWare, number of databases per AG, best practices for ETL operations, and more!

20 min2018 DEC 13
Comments
Office Hours - 12/12/2018

Office Hours - 12/5/2018

This week, Tara and Richie discuss deletes on heaps, Docker, using containers in production environment, advice for new DBA, downgrading server hardware, agent jobs, setting SQL Memory Min and Max to the same value, how to prove CPU pressure to management using the Power BI report using blitz prox, corruption, patching, backups, sargability, and more.

25 min2018 DEC 6
Comments
Office Hours - 12/5/2018

Office Hours - 11/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!

25 min2018 NOV 29
Comments
Office Hours - 11/28/2018

Office Hours - 11/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.

30 min2018 NOV 22
Comments
Office Hours - 11/21/2018

Office Hours - 11/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.

20 min2018 NOV 15
Comments
Office Hours - 11/14/2018

Office Hours - 11/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.

16 min2018 NOV 8
Comments
Office Hours - 11/7/2018

Office Hours - 10/31/2018

This week, Brent, Tara, Erik, and Richie discuss load balancing, preventing auto-updates, compatibility modes, capturing deadlock chains without tracing or extended events, blocking, which user should own databases, asynchronous processing, compressing databases, reindexing on Always On AGs, and "Making a Murderer" spoilers (not really).

27 min2018 NOV 1
Comments
Office Hours - 10/31/2018

Office Hours - 10/24/2018

This week, Brent, Tara, and Richie discuss increasing a table's varchar field from 1 to 2, predicting how long CHECKDB should take, SQL Server configuration options, reporting, reducing high waits, analysis services for SQL Azure, advice to first time PASS attendees, compatibility levels, cardinality estimator, PowerShell, and Tara's hairdo.

28 min2018 OCT 25
Comments
Office Hours - 10/24/2018

Latest Episodes

Office Hours - 1/2/2019

This week, Brent, Erik, Tara, and Richie discuss whether you need to premake a destination database in order to run sp_databaserestore, restoring production statistics on dev servers to simulate productions behavior, dealing with duplicate SPNs, tools for detecting all SQL Servers in a production environment, SQL performance monitoring, dealing with very large indexes, and Brent's recent cruise.

17 min2019 JAN 3
Comments
Office Hours - 1/2/2019

Office Hours - 12/19/2018

This week, Erik, Tara, and Richie discuss disaster recovery, Python vs C# for SQL Server, whether you should perform log backups on primary or secondary on AGs, why Postgres is so popular, using mount points for tempdb, attention events, database corruption, MERGE statements, restoring a table from a database, features they look forward to in SQL Server 2019, and how Santa is able to visit all those homes in one night...

29 min2018 DEC 20
Comments
Office Hours - 12/19/2018

Office Hours - 12/12/2018

This week, Erik and Richie discuss TSQL classes, scalar functions, index reorganize vs rebuild, daily image backups on a fringe SQL server on VMWare, number of databases per AG, best practices for ETL operations, and more!

20 min2018 DEC 13
Comments
Office Hours - 12/12/2018

Office Hours - 12/5/2018

This week, Tara and Richie discuss deletes on heaps, Docker, using containers in production environment, advice for new DBA, downgrading server hardware, agent jobs, setting SQL Memory Min and Max to the same value, how to prove CPU pressure to management using the Power BI report using blitz prox, corruption, patching, backups, sargability, and more.

25 min2018 DEC 6
Comments
Office Hours - 12/5/2018

Office Hours - 11/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!

25 min2018 NOV 29
Comments
Office Hours - 11/28/2018

Office Hours - 11/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.

30 min2018 NOV 22
Comments
Office Hours - 11/21/2018

Office Hours - 11/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.

20 min2018 NOV 15
Comments
Office Hours - 11/14/2018

Office Hours - 11/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.

16 min2018 NOV 8
Comments
Office Hours - 11/7/2018

Office Hours - 10/31/2018

This week, Brent, Tara, Erik, and Richie discuss load balancing, preventing auto-updates, compatibility modes, capturing deadlock chains without tracing or extended events, blocking, which user should own databases, asynchronous processing, compressing databases, reindexing on Always On AGs, and "Making a Murderer" spoilers (not really).

27 min2018 NOV 1
Comments
Office Hours - 10/31/2018

Office Hours - 10/24/2018

This week, Brent, Tara, and Richie discuss increasing a table's varchar field from 1 to 2, predicting how long CHECKDB should take, SQL Server configuration options, reporting, reducing high waits, analysis services for SQL Azure, advice to first time PASS attendees, compatibility levels, cardinality estimator, PowerShell, and Tara's hairdo.

28 min2018 OCT 25
Comments
Office Hours - 10/24/2018
success toast
Welcome to Himalaya LearningClick below to download our app for better listening experience.Download App