Videos

  1. Home
  2. Videos
  3. (Page 4)
Office Hours Podcast

[Video] Office Hours 2018/5/23 (With Transcriptions)

This week, Brent, Tara, and Richie discuss relaying SQL Server performance updates to upper management, differential backups in AlwaysOn Availability environment, replication, Troubleshooting THREADPOOL Waits, an acceptable amount of preemptive waits, Postgres, and the technologies Richie is working with these days. Here’s the video on YouTube: You can register to attend next week’s Office Hours, or subscribe…
Read More
PowerShell for DBAs

[Video] Office Hours 2018/4/18 (With Transcriptions) with Special Guest Drew Furgiuele

This week Drew Furgiuele joins Brent and Richie to discuss patching, job interview suggestions, using PowerShell to solve various SQL Server issues, roles and responsibilities of a SQL or a database architect, enabling query store on production servers, SARGability, moving SSRS from the main production server, tempdb issues, Availability Groups troubleshooting, Drew’s upcoming Powershell class,…
Read More
Failover Clustered Instances

[Video] Office Hours 2018/4/11 (With Transcriptions) with Special Guest Edwin M Sarmiento

This week @EdwinMSarmiento joins Brent, Tara, Erik, and Richie to discuss high availability disaster recovery, migrating from on-premises server to Amazon’s RDS, AlwaysON Availability Groups, auto-growth issues, rebuilding vs dropping/re-creating indexes, log shipping, using Service Broker with Always On Availability Groups, updating stats issues, VLF counts, measuring transaction log usage, upgrading versions, and much more.…
Read More

[Video] Office Hours 2018/4/4 with Special Guest Pinal Dave

This week, Pinal Dave joins Brent, Tara, and Richie to discuss replication latency, partitioning tables, transactional replication, troubleshooting 3-rd party application performance, SQL ConstantCare® update, SQL Server errors, copying data over from a database with read-only access, reducing blocking timeouts, backups to the cloud, and more replication questions! Here’s the video on YouTube: You can…
Read More

[Video] Office Hours 2018/1/17 (With Transcriptions)

This week, Tara, Erik, and Richie discuss 3rd-party tools for object-level restore, patching, stringing multiple CTEs, Meltdown and Spectre, instance stacking, organizing DBA teams, DBCC checks, moving local databases to Amazon RDS, CTEs vs temp tables, and backups and restores. Here’s the video on YouTube: You can register to attend next week’s Office Hours, or subscribe to…
Read More

[Video] The Junior DBA Workout Plan

Squat, deadlift, overhead press, and bench press. In the gym, it’s easy to figure out what you need to be doing to get stronger. When you show up to work, you’re overwhelmed by all the things happening on your server(s), and you can’t figure out where to begin. In this session, we’ll talk about building…
Read More
Office Hours Podcast

[Video] Office Hours 2018/1/10 (With Transcriptions)

This week Brent, and Richie discuss validating backups using the backup set table, how to figure out if you’re a Mid-Level or Senior DBA, rollbacks, compatibility modes while upgrading SQL Server versions, MAXDOP settings, and Brent’s car purchasing tip. Here’s the video on YouTube: You can register to attend next week’s Office Hours, or subscribe to our…
Read More

[Video] Office Hours 2018/1/3 (With Transcriptions)

This week Brent and Richie discuss the latest big Intel CPU security flaw, distributed transactions, rebuilding indexes, SQL Server health check, GDPR regulations, Availability Groups issues, improving server performance, patching for instances that share DBs from multiple applications, using heaps, and more… Here’s the video on YouTube: You can register to attend next week’s Office Hours, or subscribe…
Read More

[Video] Office Hours 2017/12/20 (With Transcriptions)

This week Brent, Erik, and Richie discuss truncating & repopulating, failed logins, their choice for high availability, PowerBI, read committed isolation, parameter sniffing, database mirroring, extended events and failing queries and re-indexing large tables. Here’s the video on YouTube: You can register to attend next week’s Office Hours, or subscribe to our podcast to listen on the…
Read More
Menu
{"cart_token":"","hash":"","cart_data":""}