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

35:35

Basic HTML for DBAs

Midnight DBA ·

2008/10/09

After my last video I got some emails saying that not all DBAs already know HTML. So I decided to teach some basic HTML that DBAs can use in their daily jobs. So if you're a DBA and you've always wanted to tackle HTML, don't worry... it's easier than it sounds.

en-us

31:21

Building a Powershell BCP Routine

Midnight DBA ·

2008/09/30

Here I show you how to build a script that will BCP an entire group of tables and even log the progress. You can make the routine as simple or as rich as you like. These are the building blocks of such a process and will take you far in your endeavors. There are several techniques taught in this video so pay attention to the details and you'll come away with a richer knowledge of powershell.

en-us

12:23

Compression Basics

Midnight DBA ·

2008/09/10

I'm going over the basics of how to implement data compression here. I'm not really touching on where and why you'd want to do it, but how to once you've made the decision.

en-us

12:23

Compression Basics

Midnight DBA ·

2008/09/10

I'm going over the basics of how to implement data compression here. I'm not really touching on where and why you'd want to do it, but how to once you've made the decision.

en-us

23:58

RunAs Magic

Midnight DBA ·

2008/09/04

This is a really good video on how to use the RunAs utility in windows. There are several scenarios when a DBA/Dev may need to logon to a program with separate credentials and this takes you a good way to getting there. The process is simple, but it comes with some caveats. I don't even come close to discussing the whole topic here but like I said, it's an excellent start that takes you past the basics of the right-click.

en-us

19:55

Scripting DB Objects in Powershell (Advanced Topics)

Midnight DBA ·

2008/08/23

Here I get past the basics of using the Script() method and take you to how to recreate some of the scripts you can create in SSMS by instantiating a scriptingOptions object and passing it to the method.

en-us

14:44

Write Good Dynamic SQL

Midnight DBA ·

2008/08/20

Here I show you a couple methods for getting around really hard to read dynamic SQL.

en-us

21:44

Scripting DB Objects in PowerShell

Midnight DBA ·

2008/07/24

Continuing with PowerShell I thought I'd show you something really cool you can do that would make a difference in your shop right away. So here I'm showing you how to script your tables, etc in PowerShell so you can automate them and add them to your processes. This is an excellent example of how cool and useful this scripting language is. I hope it makes you as excited about PowerShell as it does me.

en-us

10:07

Cool New SSMS Features for DBAs

Midnight DBA ·

2008/07/23

I give MS a hard time sometimes so I like to give them props when I find something really worth it. And here I discuss 3 new features in Katmai that are mainly for DBAs. They're really cool so pay attention and enjoy.

en-us

9:57

BCP With Hyperbac

Midnight DBA ·

2008/06/18

Here I show you how to automatically compress BCP operations with Hyperbac. It's just a cool bonus you get when you do you database backups with this utility.

en-us

9:43

Interpreting Disk Queues

Midnight DBA ·

2008/06/02

Disk queues are a mystery for the majority of DBAs. They may know that they need to look at them, but they have no idea what they mean. Here I'll show you how to know what you're looking at to see when your disk queues are too high. This tutorial doesn't go into how to fix the problem really, it's more just how to diagnose it.

en-us

6:39

Backup with Init

Midnight DBA ·

2008/05/20

In this video I discuss the init option for the backup command. You'll come away knowing how to use it and what it's for.

en-us

7:21

When did SQL Server Start?

Midnight DBA ·

2008/05/02

Find out 2 ways to tell when SQL Server started.

en-us

17:48

BCP in errors

Midnight DBA ·

2008/04/16

Learn how to diagnose BCP import problems.

en-us

5:15

BCP in

Midnight DBA ·

2008/04/14

Learn how to BCP data into a table.

en-us

5:44

Katmai Server Group Management

Midnight DBA ·

2008/04/01

Learn how to use the new group server mgmt functionality in the Katmai SSMS.

en-us

4:05

Basic Backup

Midnight DBA ·

2008/03/19

Learn how to perform basic backups with SQL syntax.

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