SQL Server Pain Relief: Office Hours

By Brent Ozar

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 spe... more

Download on the App Store

Download on the App Store

Get it on Google Play

FAQs about SQL Server Pain Relief: Office Hours:

How many episodes does SQL Server Pain Relief: Office Hours have?

The podcast currently has 96 episodes available.

SQL Server Pain Relief: Office Hours episodes:

September 27, 2017 Office Hours - 9/27/2017
This week, Richie and Erik discuss altering database columns, separating log files, encryption, NOLOCK issues, developing new skills and experience, troubleshooting deadlocks, Oracle, calling C# method from a stored procedure and what kind of headset Erik uses.
...more
35min
September 20, 2017 Office Hours - 9/20/2017
This week, Brent, Tara, Richie, and Erik discuss a most excepted solution for SA and securing an instance, how many VLFs should a database have, merge replication issues, query tuning tips, database restores, and Larry Ellison's self-driving database.
...more
31min
September 13, 2017 Office Hours - 9/13/2017
This week, Brent and Erik discuss Availability Group issues, database diagram tools, AWS vs Azure, diagnosing asyncio waits, troubleshooting deadlocks, extended events, using same login credentials for everyone in the company, adjusting and more.
...more
36min
August 30, 2017 Office Hours - 8/30/2017
This week, Brent, Erik, and Richie discuss Availability Groups, versions of sp_BlitzIndex™, SQL Server installation issue, backing up SSRS reports, SQL Server on Linux, failovers, detaching/attaching databases, extended events, career progression of a DBA, and more.
...more
32min
August 23, 2017 Office Hours - 8/23/2017
This week, Brent, Erik, Tara, and Richie discuss index fragmentation, Azure disc speeds, Availability Groups, database restores, optimize for ad hoc setting, forced parameterization, BI consultants, index views, SPN registrations, and more.
...more
33min
August 02, 2017 Office Hours - 8/2/2017
This week, Brent, Erik, and Richie discuss unit testing, tSQLt, availability groups, duplicate indexes, reporting services 2016 on availability groups, troubleshooting Entity Framework queries, joining views in tables, SQL Server caching issues, and why procedures have plans inside the cache.
...more
36min
July 26, 2017 Office Hours - 7/26/2017
This week, Brent, Erik, Tara, and Richie discuss SQL Server performance monitoring, ASYNC_IO_COMPLETION, AWS SQL server licensing and fees, rebuilding indexes, licensing model for Blitz scripts, stored procedures, using (or not using) primary key on a table, choosing ORMs and other tools, and more.
...more
30min
July 19, 2017 Office Hours - 7/19/2017
This week, Erik and Richie discuss performance tuning, relativity, Always On Availability Groups, parameter sniffing, technical debt, unit testing, deadlocks, testing storage performance, and more...
...more
36min
July 12, 2017 Office Hours - 7/12/2017
This week, Brent, Richie, Erik, and Tara discuss partitioning tables, native backups vs 3rd party agent backups, page life expectancy, query tuning, deadlocks, drawbacks of RCSI, triggers, replication, Always On Availability Groups, and forest fires.
...more
38min
July 05, 2017 Office Hours - 7/5/2017
This week, Brent and Tara discuss separating data and logs on separate drives, statistics time, scalar UDFs, Licensing, encryption, gathering SQL error logs and agent job history, replication, upcoming training courses from Brent Ozar UnlimitedⓇ, and what DBA topics they struggle with the most.
...more
27min

FAQs about SQL Server Pain Relief: Office Hours:

How many episodes does SQL Server Pain Relief: Office Hours have?

The podcast currently has 96 episodes available.