Posts by Brent Ozar Unlimited Team

Office Hours Podcast

[Video] Office Hours 2019/1/2 (With Transcriptions)

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…
Read More
Office Hours Podcast

[Video] Office Hours 2018/11/7 (With Transcriptions)

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. Here’s the video on YouTube: You can register to attend next week’s Office Hours, or subscribe to our podcast to listen on the go. Enjoy the…
Read More
Office Hours Podcast

[Video] Office Hours 2018/10/31 (With Transcriptions)

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). Here’s the video on YouTube: You can register to attend next week’s Office…
Read More
Office Hours Podcast

[Video] Office Hours 2018/10/24 (With Transcriptions)

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. Here’s the video on YouTube: You…
Read More
Office Hours Podcast

[Video] Office Hours 2018/10/10 (With Transcriptions)

This week, Brent, Tara, and Richie discuss splitting large database files across multiple files, security auditing solutions, what Brent is currently teaching at the client location, SQL Server in containers, heap index maintenance, contained databases, extended events, the difference between a junior and Senior DBA, page file sizing, and more. Here’s the video on YouTube:…
Read More
Office Hours Podcast

[Video] Office Hours 2018/10/3 (With Transcriptions)

This week, Tara and Richie discuss database corruption, CLR, DBCC issues, adding identity columns to databases, distributed transactions, tracking how recently a procedure was executed, maintenance plans, recompiling stored procs, parameter sniffing issues, troubleshooting replication with Always On, forecasting database growth and estimating capacity issues, tools for database growth forecast reports, RCSI, and much more.…
Read More
Office Hours Podcast

[Video] Office Hours 2018/8/1 (With Transcriptions)

This week, Erik and Richie discuss monitoring tools, finding all unused tables across databases, query tuning, deleting vs hanging on to indexes, sharding databases, query editors, aggressively-locked indexes, why a plan would not be in the plan cache, and Richie’s current housing situation. Here’s the video on YouTube: You can register to attend next week’s Office Hours,…
Read More
Menu
{"cart_token":"","hash":"","cart_data":""}