BCP

Video details

· BCP out, 17 min

· BCP in, 5 min

· BCP in errors, 18 min

· BCP With Hyperbac, 10 min

Backup and Restore

Video details

· Basic  Backup, 4 min

· Remote Backups, 3 min

· RESTORE with move, 12 min

· Simple Backup Procedures, 19 min

· Backup with Init, 6 min

· Backup File Extensions, 6 min

Perfmon

Video details

· Windows Performance Monitoring: Part 1, 1 hr 17 min

· Windows Performance Monitoring: Part 2, 1 hr 4 min

Schemas

Video details

· Introduction to Schemas, 8 min

· Schemas as Documentation, 9 min

· Schemas: Ownership Chaining and Schema Ownership, 23 min

PowerShell

Video details

· PowerShell Basics, 20 min

· Scripting DB Objects in PowerShell , 22 min

· Scripting DB Objects in Powershell (Advanced Topics), 20 min

· Working with PSDrive in PowerShell , 13 min

· Powershell with –NoExit, 5 min

· Change SQL Server Job Owner, 18 min

· Grant DB Permissions, 9 min

· Grant Schema Permissions in Powershell, 18 min

· Building a Powershell BCP Routine, 31 min

· Powershell Profiles, 8 min

· Pass Params to Scripts (Powershell), 8 min

· Find DB Files with Powershell, 2 min

· Index Scripting Problems, 22 min 

Beginning PowerShell for DBAs:

· Beginning PS... 1 of 6, 1 hr 27 min

· Beginning PS... 2 of 6, 38 min

· Beginning PS… 3 of 6, 0 min

· Beginning PS… 4 of 6, 0 min

· Beginning PS… 5 of 6, 0 min

· Beginning PS… 6 of 6, 0 min

Other

Video details

· Trace Flag 1807, 8 min

· When did SQL start?, 7 min

· sp_HelpIndex Shortcut, 6 min

· Moving DB Files, 17 min

· Interpreting Disk Queues, 10 min

· Running Websites with AD Accounts, 13 min

· Find Log Space Used, 2 min

· Using ServerProperty , 8 min

· RunAs Magic, 24 min

· Select Into with Identity(), 5 min

· Troubleshoot DB Connection with Telnet, 6 min

· Troubleshoot Missing DB File, 3min

· Recover SQL Passwords, 12 min