Videos

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

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

Videos
0
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
Office Hours Podcast

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

This week, Brent, Erik, Tara, and Richie discuss using SQL Server 2016 vs 2017 for production environment, reporting, reindexing jobs, Azure vs Amazon, parameter sniffing, creating custom alerts for agent jobs, activity monitor, troubleshooting SQL Server 2014, replication, turning off auto-updating stats on tempdb, and why Brent can’t get a tan. Here’s the video on…
Read More

[Video] SSIS Design Patterns: Extract, Load, and Transform – and Save 50% on Training

Videos
0
This week, we’re sharing Instant Replay videos from our training classes. Last but not least this week, Andy Leonard is talking about the Extract-Load-Transform design pattern in SSIS – different from the old Extract-Transform-Load: That video is from the Instant Replay recordings of Andy’s 2 1/2 day class, Expert SSIS Training. The reviews are great.…
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

[Video] Interpreting Missing Index Recommendations

Indexing, Videos
0
This week, we’re sharing Instant Replay videos from our training classes. Next up is Pinal Dave talking about missing index requests from the dynamic management views. It doesn’t matter whose script you use – they’re all built atop SQL Server’s missing-index DMVs, and they all have the same limitations. Treat the missing index requests the…
Read More
PowerShell for DBAs

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

Processes and Practices, Videos
0
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

[Video] SQL Query Optimization: Why Is It So Hard to Get Right?

Videos
0
The first paper on cost-based query optimization was published in 1979 by Patricia Selinger from IBM Research. This paper laid the basic framework for optimizing relational queries that is still in place today. While there have been many technical enhancements since 1979, query optimizers still fail to pick the best plan when faced with a…
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
Office Hours Podcast

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

Videos
0
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

Videos
0
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

Videos
0
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
Menu