All Episodes

Add User to Windows Group with Powershell

Change DB Compatibility Level in Powershell

Get a Specific Method in Powershell

Good Interview Still Don't Get the Job: Part 1

Good Interview Still Don't Get the Job: Part 2

Keeping your Sanity when out of Work: Part 1

Keeping your Sanity when out of Work: Part 2

Build .Net Objects in Powershell

TSQL: Grouping Basics

Source Control in SSMS

Setup Server-Side Trace

Grouping Sets

T-SQL: Over() and Partition By

Troubleshoot SSIS: "Script component cannot build user component"

T-SQL: Find Last Day of Month

Deploy Packages

Powershell Profiles

HTML Styles: Part 1

Basic HTML for DBAs

Building a Powershell BCP Routine

Compression Basics

RunAs Magic

Scripting DB Objects in Powershell (Advanced Topics)

Write Good Dynamic SQL

Scripting DB Objects in PowerShell

Cool New SSMS Features for DBAs

BCP With Hyperbac

Interpreting Disk Queues

Backup with Init

When did SQL Server Start?

BCP in errors

BCP in

Katmai Server Group Management

Basic Backup