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, rest...
Radio and PodcastLive Radio & PodcastsTechnology
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...
SQL Server Pain Relief: Office Hours with Brent Ozar Unlimited® Podcast Guide
Listen to SQL Server Pain Relief: Office Hours with Brent Ozar Unlimited®, a Technology podcast by Brent Ozar Unlimited®. Stream 100 episodes in English, follow new audio stories, and play episodes online on Radio and Podcast.
Show Topic
Browse this show under Technology podcasts.
Episodes
20 episodes are loaded now from a catalog of 100. More episodes can be opened from this page.
Discover More
Explore Technology podcasts, United States podcasts and English podcasts.
Episodes
20 of 100 episodesOffice 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...
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 o...
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 ser...
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...
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,...
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 a...
Office Hours - 11/7/2018
This week, Tara and Richie discuss offline file database and log backup solutions, VSS database backups, monitoring products, parameterizati...
Office Hours - 10/31/2018
This week, Brent, Tara, Erik, and Richie discuss load balancing, preventing auto-updates, compatibility modes, capturing deadlock chains wit...
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 Serv...
Office Hours - 10/17/2018
This week, Brent, Erik, and Richie discuss small vendor apps, "Slow in the Application, Fast in SSMS?", virtualization, licensing, msdb back...
Office Hours - 10/10/2018
This week, Brent, Tara, and Richie discuss splitting large database files across multiple files, security auditing solutions, what Brent is...
Office Hours - 10/03/2018
This week, Tara and Richie discuss database corruption, CLR, DBCC issues, adding identity columns to databases, distributed transactions, tr...
Office Hours - 9/19/2018
This week, Brent, Tara, Erik, and Richie discuss moving views between databases, Cluster Quorum File Share on AlwaysOn, checking for corrupt...
Office Hours - 9/12/2018
This week, Brent, Erik, Tara, and Richie discuss syncing logins and database data via log shipping, monitoring page life expectancy, cumulat...
Office Hours - 9/5/2018
This week, Brent, Tara, Erik, and Richie discuss whether you should keep autoshrink on, AG multisite failovers, next version of SQL Server,...
Office Hours - 8/29/2018
This week, Brent, Erik, and Richie discuss Microsoft cumulative updates, AlwaysOn Encrypted, query tuning, poison waits, the DBA career, CXP...
Office Hours - 8/15/2018
This week, Brent, Tara, Erik, and Richie discuss error log issues, issues with moving a 2-node AG to a different VM, adding a rowversion col...
Office Hours - 8/8/2018
This week, Brent, Tara, Erik, and Richie discuss troubleshooting port blocking, page life expectancy issues, problems with turning off CPU s...
Office Hours - 8/1/2018
This week, Erik and Richie discuss monitoring tools, finding all unused tables across databases, query tuning, deleting vs hanging on to ind...