Videos

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

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

This week, Erik and Richie discuss monitoring tools, finding all unused tables across databases, query tuning, deleting vs hanging on to indexes, sharding databases, query editors, aggressively-locked indexes, why a plan would not be in the plan cache, and Richie’s current housing situation. Here’s the video on YouTube: You can register to attend next week’s Office Hours,…
Read More
Office Hours Podcast

[Video] Office Hours 2018/7/18 (With Transcriptions)

This week, Brent, Erik, and Tara discuss their SQL server specialization, CPU-ready time, making SSIS changes globally rather than one at a time, creating an Always On AG farm, Azure managed instances, going from log shipping to Availability Groups, tracking folks that executed queries, moving databases into Availability Groups, an exciting update to SQL Server…
Read More
Office Hours Podcast

[Video] Office Hours 2018/7/11 (With Transcriptions)

This week, Brent, Richie, and Erik discuss best account practices for SQL Server, change tracking, disabled indexes, measuring queries to gauge their speed, overcoming issues between Management Studio and integration services, deadlocks and long-running processes, query tuning, and lock escalation. Here’s the video on YouTube: You can register to attend next week’s Office Hours, or subscribe to…
Read More

[Video] Installing SQL Server Updates in an Availability Group, and Save 50% on Training

This week, we’re sharing Instant Replay videos from our training classes. Today’s Instant Replay is Edwin Sarmiento talking about how he approaches applying service packs and cumulative updates on Always On Availability Groups: That video is part of the Instant Replay recordings of Edwin’s extensive live 3-day Senior DBA’s Guide to Always On Availability Groups.…
Read More
PowerShell for DBAs

[Video] PowerShell Functions and Parameters, and 50% Off Training Classes

This week, we’re sharing some of the Instant Replay videos from our training classes. First up is Drew Furgiuele talking about PowerShell functions and parameters: That’s module 4.1 of Drew’s PowerShell for Database Administrators class. It’s 2 days of lectures and labs – Drew talks about how to do something, then gives you a challenge for…
Read More
Office Hours Podcast

[Video] Office Hours 2018/6/13 (With Transcriptions)

This week, Brent and Richie discuss using full-text index, Elasticsearch, server restart issues, sp_blitzfirst, Always On availability groups, issues with users connecting to SQL Server, learning the basics of Python on SQL Server 2017, VMWare Hyper-V configuration issue, and more. Here’s the video on YouTube: You can register to attend next week’s Office Hours, or subscribe to…
Read More
Menu
{"cart_token":"","hash":"","cart_data":""}