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:

June 28, 2017 Office Hours - 6/28/2017
This week, Erik, Tara, and Richie discuss performance and load testing tools, sysadmin update SQL server restart, defragmenting column store indexes, Amazon Redshift, installing Microsoft updates, Always On Availability Groups, Redgate SQL Clone, as well as their thoughts on the current DBA job market.
...more
30min
June 21, 2017 Office Hours - 6/21/2017
This week, Brent, Erik, Tara, and Richie discuss cross-database transactions in AGs, agent job owners, column store indexes, linked servers, migrating SQL Server databases to AWS cloud, synchronous readable secondary, rebuilding indexes, backups using SANs, licensing, Always On Availability Groups on CDC, Azure Cosmo DB, compression, and encryption.
...more
30min
June 14, 2017 Office Hours - 6/14/2017
This week, Brent, Erik, Tara, and Richie discuss setting up an archive process, CTEs vs temp tables, deadlocks, alternatives to replication, Erik and Brent's pre-con for this year's PASS Summit, and more...
...more
27min
June 07, 2017 Office Hours - 6/7/2017
This week, Brent, Erik, and Richie discuss running SQL Server 2017 CTP on Linux, receive side scaling on servers and VMware, query tuning, nested roles vs. assigning roles to users, hierarchical data type, apps and scripts for automating restores, and learning Azure and AWS.
...more
33min
May 31, 2017 Office Hours - 5/31/2017
This week, Brent and Richie discuss sp_Blitz Backups, change history tracking, exams and certifications, using Azure for DR-only, which version of SQL server to use for a new DB, adding additional data files, load balancing, trace flag 2371, dealing with reporting services, and much more.
...more
28min
May 24, 2017 Office Hours - 5/24/2017
This week, Brent, Erik, and Richie discuss disabling telemetry in SQL Server 2016, proper place for log files, Availability Groups, measuring data returned from a single query, whether CHECKDB should be done on tempdb, limiting tempdb usage for each session, transfering large amounts of data from on-prem to the cloud, and Iron Chef spoilers.
...more
33min
May 17, 2017 Office Hours - 5/17/2017
This week, Erik, Tara, and Richie discuss enforcing password expirations for SA logins, keeping things in sync between servers, development/prototyping missions of on-premise vs. cloud, ways of backing up databases, and more.
...more
23min
May 10, 2017 Office Hours - 5/10/2017
This week, Tara and Richie discuss increasing the size of tempdb, splitting database across several files, tracking DML changes to a table, upgrading different versions of service packs, recommendations for improving T-SQL skills, trace flags, replication, Always On Availability Groups, compatibility level of databases, and more...
...more
28min
May 03, 2017 Office Hours - 5/3/2017
This week, Brent, Tara, and Richie discuss choosing batch sizes, SQL 2017 on Linux, how much memory to leave on the OS for the SQL server, parameter sniffing, allocation unit size of SQL server, triggers, X-Files, aliens and much more!
...more
33min
April 26, 2017 Office Hours - 4/26/2017
This week, Erik talks about troubleshooting remote queries, his thoughts on SQL Server 2017, licensing, index rebuilds, index fragmentation, why you shouldn't restart SQL server every day, and much more!
...more
28min

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.