Midnight DBA cover art

All Episodes

Midnight DBA — 234 episodes

#
Title
1

Just Mad

E
2

What is a Stored Procedure

E
3

A Million Monkeys

E
4

Simplicity Defined

E
5

Guy Love

E
6

Denny in the Dark

E
7

Displayja Vu

E
8

Kill the Internet

E
9

MS Manners

E
10

Saving Private Denny

E
11

Dueling Mothers

E
12

Spying on You

E
13

I Ship You

E
14

The New MCM

E
15

6'4" 240

E
16

Being John Microsoft

E
17

The Adventure of the New Mic

E
18

Special Education Unit

E
19

No DBA Left Behind

E
20

Twaint

E
21

Happy NutUp Or ShutUp Day

E
22

The Longest Time

E
23

Girl Talk

E
24

Delete^10

E
25

Fappy

E
26

Like a Boss

E
27

DoppelGanger

E
28

Upgrade or Die!

E
29

Hey Scotty!

E
30

Sloppy Seconds

E
31

CISPA Report

E
32

Junior Associate Janitor

E
33

Stay Gold

E
34

The One Armed Shoe Tyer

E
35

Sean's Killing Spree

E
36

A New Leaf

E
37

Change Startup Params in Powershell

E
38

Drop Tables in Powershell

E
39

Truncate Tables in Powershell

E
40

Server Configuration Settings in Powershell

E
41

Fix AutoShrink in Powershell

E
42

Get SQL Server Root Dir in Powershell

E
43

Attach DBs in Powershell

E
44

Calling Detach Methods in Powershell

E
45

Get IP and DNS in Powershell

E
46

Change Schema in Powershell

E
47

Change SQL Server Permissions in Powershell: Part 1

E
48

Change SQL Server Permissions in Powershell: Part 2

E
49

Read SQL Server Error Logs in Powershell

E
50

Cycle Error Log on all Servers using Powershell

E
51

Zombie Jesus Weekend

E
52

The SANs Of Time

E
53

Largest SQL Server Installs

E
54

Fake Projects for Steve

E
55

MVP Summit 2012

E
56

Dealing with Sql_variant in SSIS

E
57

Yet here we are

E
58

Change Agent Job Properties in Powershell

E
59

Deploying SSRS Reports

E
60

Data-driven Subscriptions in SSRS

E
61

Goodbye Chef

E
62

Sean's Pretty Hands

E
63

NCC-1701-DBA: 1 of 6

E
64

Jen's Milkshake

E
65

Forced Reboot

E
66

Best Habit for Coders

E
67

Querying Dev Metadata

E
68

DBAs of Our Lives

E
69

Xmas Special

E
70

Bring in the Nerds

E
71

STOP!!!

E
72

It's Being Mailed

E
73

SOPA Sucks

E
74

Stop Looking at Me

E
75

Sexy Hat Night

E
76

Campfire Stories

E
77

Slightly Used Interview

E
78

Itzik Rules

E
79

We LOVE Mark

E
80

Change Users Password

E
81

Troubleshoot Default Schema

E
82

Find File Lock

E
83

P.I.O.

E
84

UNION and UNION ALL

E
85

Server Properties

E
86

Optimize For Adhoc Workloads

E
87

DBCC FixProblems

E
88

Format Multiple SSRS Table Fields

E
89

The Reverse Godfather

E
90

Create and Edit a Simple SSRS Report

E
91

Insert Into vs. Select Into

E
92

Season 3 Opener

E
93

Windows Crash Dump Analysis

E
94

Best Backup Class Evar: 5 of 6

E
95

Best Backup Class Evar: 6 of 6

E
96

Season 2 Finale

E
97

LOL Cats

E
98

Rapture Party

E
99

Best Backup Class Evar: 4 of 6

E
100

Cherry Cheesecake

E
101

Allan! Allan! Allan! Allan! Allan!

E
102

Installed Anally

E
103

Itzik knows all

E
104

The Peeping Jedi

E
105

Pimp-A-Thon

E
106

Don Gill

E
107

Falling Asleep on Tyra Banks

E
108

Uninstall a CU in SQL Server 2008 R2

E
109

Get Away from Me

E
110

Best Backup Class Evar: 3 of 6

E
111

Database Performance

E
112

The Blanket Bonus

E
113

I would yank for Melissa

E
114

Leaking MVPee

E
115

Simple Mode prevents STDs

E
116

Best Backup Class Evar: 2 of 6

E
117

They kept felons

E
118

Find query timeouts in Profiler

E
119

You got munkey lips

E
120

Sean gets 69

E
121

Best Backup Class Evar: 1 of 6

E
122

Hottub of Bellydancers

E
123

Sledgehammer of Justice

E
124

Hack-attak a damaged DB

E
125

Sum DB Sizes with Powershell

E
126

Useless Superpowers

E
127

Replace sp_MSForEachDB with Powershell

E
128

Smell my Guitar

E
129

Stallin SQL like a Mofo

E
130

Adam Machanic has soft hands

E
131

Bathrobe Bonanza

E
132

Sexual Harassment

E
133

Merkin Glue

E
134

Grant Fritchey is our Hero

E
135

Denny 'Five Fingers' Cherry

E
136

The Mark Souza Sandwich

E
137

Steve Jones in the House!!

E
138

No Management DBs

E
139

Your Face or Mine?

E
140

What kind of pistol?

E
141

Olympic Cornholing

E
142

The Unnamed Episode

E
143

Polishing Dung

E
144

Monitor Backups with Powershell

E
145

Audit Service Accounts with Powershell

E
146

Sean's Man-crush

E
147

Quick, get the Bedazzler!

E
148

Aristocratic Corn

E
149

User Processes: 1 of 2

E
150

User Processes: 2 of 2

E
151

When to Leave your Job: 1 of 5

E
152

When to Leave your Job: 2 of 5

E
153

When to Leave your Job: 3 of 5

E
154

When to Leave your Job: 4 of 5

E
155

When to Leave your Job: 5 of 5

E
156

Firing DBAs: Part 1

E
157

Firing DBAs: Part 2

E
158

Firing DBAs: Part 3

E
159

Firing DBAs: Part 4

E
160

Beginning T-SQL: SQL Saturday #41 - Atlanta

E
161

T-SQL Codig Sins: SQL Saturday #41 - Atlanta

E
162

Adopting New Features: 1 of 4

E
163

Adopting New Features: 2 of 4

E
164

Adopting New Features: 3 of 4

E
165

Adopting New Features: 4 of 4

E
166

Plagiarism: 1 of 4

E
167

Plagiarism: 2 of 4

E
168

Plagiarism: 3 of 4

E
169

Plagiarism: 4 of 4

E
170

No Religion at Work: 1 of 4

E
171

No Religion at Work: 2 of 4

E
172

No Religion at Work: 3 of 4

E
173

No Religion at Work: 4 of 4

E
174

Manage DB Files in Powershell

E
175

Stuff Auction: 1 of 3

E
176

Stuff Auction: 2 of 3

E
177

Stuff Auction: 3 of 3

E
178

Breaking up with your Boss: 1 of 4

E
179

Breaking up with your Boss: 2 of 4

E
180

Breaking up with your Boss: 3 of 4

E
181

Breaking up with your Boss: 4 of 4

E
182

Beginning Execution Plans

E
183

Resumes: 1 of 3

E
184

Resumes: 2 of 3

E
185

Resumes: 3 of 3

E
186

Companies don't Care

E
187

Bill Ramos Talks Tools: 1 of 2

E
188

Bill Ramos Talks Tools: 2 of 2

E
189

The Early Bird Gets Brian Knight: 1 of 2

E
190

The Early Bird Gets Brian Knight: 2 of 2

E
191

Paul and Kim Tripp: 1 of 2

E
192

Paul and Kim Tripp: 2 of 2

E
193

Get Jiggy with Allen White: 2 of 2

E
194

Get Jiggy with Allen White: 1 of 2

E
195

PASS Summit 09 Interview: Itzik Ben-Gan, 1of2

E
196

PASS Summit 09 Interview: Itzik Ben-Gan, 2 of 2

E
197

DBAs@Midnight: Managing Tasks 1 of 2

E
198

DBAs@Midnight: Managing Tasks 2 of 2

E
199

DBAs@Midnight: No Moving Schema

E
200

Fix SSIS Pkg Import Errors

E
201

Add User to Windows Group with Powershell

E
202

Change DB Compatibility Level in Powershell

E
203

Get a Specific Method in Powershell

E
204

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

E
205

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

E
206

Keeping your Sanity when out of Work: Part 1

E
207

Keeping your Sanity when out of Work: Part 2

E
208

Build .Net Objects in Powershell

E
209

TSQL: Grouping Basics

E
210

Source Control in SSMS

E
211

Setup Server-Side Trace

E
212

Grouping Sets

E
213

T-SQL: Over() and Partition By

E
214

Troubleshoot SSIS: "Script component cannot build user component"

E
215

T-SQL: Find Last Day of Month

E
216

Deploy Packages

E
217

Powershell Profiles

E
218

HTML Styles: Part 1

E
219

Basic HTML for DBAs

E
220

Building a Powershell BCP Routine

E
221

Compression Basics

E
222

RunAs Magic

E
223

Scripting DB Objects in Powershell (Advanced Topics)

E
224

Write Good Dynamic SQL

E
225

Scripting DB Objects in PowerShell

E
226

Cool New SSMS Features for DBAs

E
227

BCP With Hyperbac

E
228

Interpreting Disk Queues

E
229

Backup with Init

E
230

When did SQL Server Start?

E
231

BCP in errors

E
232

BCP in

E
233

Katmai Server Group Management

E
234

Basic Backup

E