Info

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 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.
RSS Feed
SQL Server Pain Relief: Office Hours with Brent Ozar Unlimited®
2017
October
September
August
July
June
May
April
March
February
January


2016
December
November
October
September
August
July
June
May
April
March
February
January


2015
December


All Episodes
Archives
Now displaying: Page 3
Sep 21, 2016

This week, Brent, Richie, Tara, and Erick, discuss enhancing queries, database corruption, availability groups, parameter sniffing, sending mail via SQL server, whether SQL 2016 is solid or not, other versions of SQL, physical servers vs virtual servers, and much more!

Sep 14, 2016

This week, Brent, Richie, and Erick, discuss execution plans for table value functions, how to prepare for the Senior DBA course, source control software, generating fragmentation, backups, and the new TV shows the team is looking forward to this season.

Sep 7, 2016

This week, Brent, Richie, Erick, and Tara discuss parameter sniffing, database backups, referential integrity in databases, clustering, creating and using indexes, in-place upgrades, benchmarking tools, and more.

Aug 31, 2016

This week, Brent, Richie, and Tara discuss corruption, resetting query stats, fixing parameter sniffing issues, how to suggest features for our scripts, and why Brent is sporting an Oracle sweatshirt.

Aug 24, 2016

This week, Richie and Erik discuss in-place instance upgrades, availability groups, replication (sort of), the cloud, job security, business intelligence and user adoption, and much more!

Aug 10, 2016

This week, Brent, Richie, Erik, and Tara get together in Round Rock, TX, for Dell DBA Days, to talk through your SQL questions and answers.

They discuss what they are working on at Dell during the event, as well as Windows Kerberos and NTLM Authentication, Always On Availability Groups, Microsoft's Document DB, automating restore databases to other servers, why they are wearing "fun" hats, and much, much more!

Aug 3, 2016

This week, Richie, Erik, and Tara discuss availability groups, sharding databases, using DNS entries to mask DB server names, and Erik's internet buttons.

Jul 27, 2016

This week, Brent, Richie, Erik, and Tara discuss speeding up performance, how to make SSRS highly available, what to do with SSIS packages when making upgrades, Windows Core, and how to hide data from DBAs when they have SA access.

Jul 20, 2016

This week, Brent, Richie, Erik, and Tara discuss new Microsoft certifications for data science, index rebuilds, replication, patching SQL server, and what to say to a manager who says he needs an active/active HA solution but has no idea what that means.

Jul 13, 2016

This week, Erik, Tara, Jessica, Doug, and Angie discuss queries, installing multiple instances of SQL server on a Windows VM, using DENY Database rules, migrating databases to Amazon RDS, availability groups, using filtered indexes, and more!

Jul 6, 2016

This week, Brent, Tara, Jessica, Richie, Doug, and Angie discuss snapshot replication, file and table-level restores, whether you should enable lock pages in memory, redistributing data across files or a database, and Doug's new video class.

Jun 29, 2016

This week, Erik, Richie, Doug, and Angie discuss a script for getting more information on a specific index, using partition tables, shrinking data and log files, stress testing SQL servers, as well as some entertaining things to ask Siri!

Jun 22, 2016

This week, Brent, Richie, Doung, and Tara talk through your SQL Server questions and answers.

Jun 15, 2016

This week, Brent, Angie, and Tara talk through your questions about monitoring tools, transactional replication, configuration management, source control software suggestions and much more!

Jun 8, 2016

This week, Angie, Erik, Doug, Jessica, and Richie discuss DB migration, rebuilding large indexes, recommendation for SQL dev ops tools, best practices for disabling SA accounts, compression, and more!

Jun 1, 2016

This week, Brent, Angie, Erik, Tara, Jessica, and Richie answer your SQL Server questions.

May 25, 2016

This week, Angie, Erik, Tara, and Richie answer your SQL Server questions.

May 18, 2016

This week, Brent, Angie, Erik, Jessica, and Richie answer your SQL Server questions.

May 11, 2016

This week, Brent, Angie, Erick, Jessica, Richie, and Tara talk through your SQL Server questions and answers.

May 4, 2016

Richie, Erick, Angie, and Tara discuss deadlocks, replication, SQL Server 2016 features, and more.

Apr 27, 2016

This week, Brent, Erick, Jessica, Angie, and Tara discusss and answer your SQL Server questions.

Apr 20, 2016

On this episode of Office Hours, Brent, Erick, Jessica, Richie, and Tara answer your SQL Server questions.

Apr 13, 2016

On this episode of Office Hours, Jessica, Richie, and Tara answer your SQL Server questions.

Apr 6, 2016

Brent, Erik, Jessica, and Richie,  answer your SQL Server questions.

Mar 30, 2016

Oh this episode of Office Hours, Erik, Jessica, Richie, and Angie answer your SQL Server questions.

« Previous 1 2 3 4 Next »