SQL Server Pain Relief: Office Hours with Brent Ozar Unlimited®

We retired this podcast, because we couldn't parse it for 10 consecutive times.

http://static.libsyn.com/p/assets/2/0/e/f/20effe5b6b2db43e/Office_Hours_Artwork.png

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.

Website: http://www.brentozar.com/
Description: 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.
Language: 🇬🇧 English
last modified: 2019-05-03 01:44
last episode published: 2019-01-02 21:16
publication frequency: 7.84 days
Contributors: Brent Ozar Unlimited helps you make SQL Server faster and more reliable. The team discusses SQL Server setup issues, indexes, queries, AlwaysOn, SAN tuning, virtualization, and more”.; Author; Brent Ozar; Owner
Explicit: false
Number of Episodes: 142
Rss-Feeds: Detail page
Categories: Education Software How-To Technology Training Science & Medicine

0 Likes 0 Followers 1 Subscribers

Sign up / Log in to like, follow, recommend and subscribe!

Recommendations

Episodes

Date	Title & Description	Contributors
2019-01-02	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 ...
2018-12-19	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 corru...
2018-12-12	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!
2018-12-05	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 managem...
2018-11-28	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 encryptio...
2018-11-21	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 valuabl...
2018-11-14	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 nor...
2018-11-07	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.
2018-10-31	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...
2018-10-24	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 ...