x

75% of people globally want unbiased news (Pew Research) but are concerned they're not getting that.

Get balanced coverage with Symby. See how stories are covered across diverse outlets and spot when one side covers a story the other skips.

PODCAST

Midnight DBA

Sean McCown and Jen McCown

Tutorial videos and our live weekly webshow, DBAs@Midnight, from the MidnightDBAs. Here we focus on SQL Server and Powershell, but we cover all things related to DBAs.

technology software how-to

All Episodes

2:38

Troubleshoot Default Schema

Midnight DBA ·

2011/08/11

Here I troubleshoot why a user's default schema isn't being honored.

en-us

3:26

Find File Lock

Midnight DBA ·

2011/08/02

Have you ever been plagued by a file you couldn't delete or move because it was being held open by something else? Well here I'm going to show you how to find out what's holding the file open so you can go deal with it.

en-us

57:21

P.I.O.

Midnight DBA ·

2011/08/01

This was such a fun week. We talked about our new videos and our new reviews on ITBookworm. We also have our T-SQL spotlight, interview question of the week, and so much more.

en-us

5:23

UNION and UNION ALL

Midnight DBA ·

2011/07/29

Here I talk about UNION and UNION ALL, and the different rules about using ORDER BY, GROUP BY, SELECT INTO, and INSERT INTO with a UNION/UNION ALL query.

en-us

11:19

Server Properties

Midnight DBA ·

2011/07/28

Have you ever wanted to be able to view instance-level stats or change certain values without having to use the GUI? Here I'll show you how to do all your boxes with Powershell.

en-us

1:01:15

DBCC FixProblems

Midnight DBA ·

2011/07/22

Lots of news this week beginning with Adam Mechanic's new training company, SSIS improvements in Denali, and some training camps. We also talk about log shipping, and much more.

en-us

12:21

Optimize For Adhoc Workloads

Midnight DBA ·

2011/07/22

There's a lovely sp_configure option that can help you keep the size of your plan cache under control. Let's go have some fun.

en-us

1:07:59

The Reverse Godfather

Midnight DBA ·

2011/07/15

This was a fun episode. We talk about Intel's SSD bug, Denali CTP3 is available, restoring backups over the network, and much much more.

en-us

3:34

Format Multiple SSRS Table Fields

Midnight DBA ·

2011/07/15

One irritating thing about SSRS is that you have to set the text box properties (say, to format numbers as currency) for each individual text box, unlike Excel. Here's a better way (with some restrictions) to update the formatting for multiple text boxes. Companion tutorial to my Tip: <a href = "http://www.midnightdba.com/Jen/2010/08/tip-change-multiple-field-formats-in-ssrs">Change Multiple Field Formats in SSRS</a>

en-us

12:51

Create and Edit a Simple SSRS Report

Midnight DBA ·

2011/07/14

Here we create, populate and format a simple SSRS report. This is a companion to my Petri article <a href = "http://www.petri.co.il/sql-reporting-services-create-edit-reports.htm">How to Create and Edit a Report in SQL Server Reporting Services</a>

en-us

13:01

Insert Into vs. Select Into

Midnight DBA ·

2011/07/14

Knowing how and when to use Insert Into or Select Into can quite often make or break your load process. Here I show you how to tell the difference between them and what their effects are.

en-us

1:02:34

Season 3 Opener

Midnight DBA ·

2011/07/09

We're kicking off another season with a bang. We get to talk to Paul Nielsen, the author of the SQL Server Bible series of books, and we reveal a new award.

en-us

6:41

Windows Crash Dump Analysis

Midnight DBA ·

2011/07/08

If Windows has ever bluescreened on you, then you know how important it can be to find the issue. Windows creates a crash dump file whenever it bluescreens and here I'm going to show you how to use that dump file to figure out what caused the bluescreen.

en-us

1:09:02

Best Backup Class Evar: 5 of 6

Midnight DBA ·

2011/06/16

The 5th in the backup class at NTSSUG.

en-us

45:48

Best Backup Class Evar: 6 of 6

Midnight DBA ·

2011/06/16

The 6th in the backup class at NTSSUG.

en-us

1:08:54

Season 2 Finale

Midnight DBA ·

2011/06/03

Another season comes to a close. We give a nice recap of the entire season, a strange DB problem, and adding NULLs. And there's so much more.

en-us

1:07:39

LOL Cats

Midnight DBA ·

2011/05/27

This was a fun week because we talked about xlocks on tempdb, nested views, and new SQL languages.

en-us

58:09

Rapture Party

Midnight DBA ·

2011/05/20

This week we're preparing for the rapture and we have some exciting news about a brand new Microsoft product. You won't believe what they've been up to.

en-us

30:20

Best Backup Class Evar: 4 of 6

Midnight DBA ·

2011/05/19

The 4th in the backup class at NTSSUG.

en-us

1:12:17

Cherry Cheesecake

Midnight DBA ·

2011/05/09

This week we cover Sean's mainframe story, twitter updates, Allan Hirt's new whitepaper, and Itzik is here again.

en-us

237 results

Similar Podcasts

Lead With AI

Tamara Nall

Linux in the Ham Shack

Black Sparrow Media

Data Engineering Podcast

Tobias Macey

Eye On A.I.

Craig S. Smith

Reflections

Livewire Labs