Brent Ozar is formerly a developer and systems administrator and currently database administrator at Microsoft SQL Server, he is one of the rare Microsoft Certified Masters, co-authored SQL Server 2008 Internals and Troubleshooting, he also host the SQL Server Pain Relief Podcast.

Appearances

Add Appearances
Recent episodes featuring Brent Ozar
Office Hours - 1/2/2019
SQL Server Pain Relief: Office Hours
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.
Office Hours - 12/19/2018
SQL Server Pain Relief: Office Hours
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...
Office Hours - 12/12/2018
SQL Server Pain Relief: Office Hours
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!
Office Hours - 12/5/2018
SQL Server Pain Relief: Office Hours
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.
Office Hours - 11/28/2018
SQL Server Pain Relief: Office Hours
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!
Share Profile
Are you Brent? Verify and edit this page to your liking.
Stats
Location
San Diego, CA, USA
Episode Count
141
Podcast Count
1
Total Airtime
2 days, 22 hours