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

23:17

DBAs@Midnight: No Moving Schema

Midnight DBA ·

2009/09/18

OK guys, here we're talking about no moving schema. If you don't know what that is, then watch this and see not only what it is, but what problems it can cause. We also discuss SQL Saturday a bit.

en-us

13:11

Add User to Windows Group with Powershell

Midnight DBA ·

2009/09/14

I love this video because it's so unusual to find something like it in the DBA community. We're quite often called on to do things outside of our direct job descriptions and this is something I have to do a lot. So I'm showing you how to add a user to a Windows group so you don't have to TS into a lot of boxes to add someone.

en-us

4:56

Fix SSIS Pkg Import Errors

Midnight DBA ·

2009/09/14

This is a live troubleshooting video. I had an error importing an SSIS pkg so I turned on the camera and worked the issue live for you. A couple of the symptoms are not being able to copy tasks inside Visual Studio and getting an error about not being able to serialize the runtime object. This is one of those cases where at least being exposed to the types of things that can go wrong will help you come up with a solution even when you've never seen a specific error.

en-us

6:02

Change DB Compatibility Level in Powershell

Midnight DBA ·

2009/09/13

Here I show you 2 easy ways to change the DB compatibility level in powershell. Otherwise you have to use a T-SQL cursor and that's not only much harder, it's just no fun. Trust me... use powershell for stuff like this and you'll be much happier.

en-us

3:37

Get a Specific Method in Powershell

Midnight DBA ·

2009/09/13

Sometimes the list of properties and methods is too big to sift through when you do a get-member on an object. Here I'll show you how to cut down the list to a more manageable size so you can find exactly what you're looking for.

en-us

13:23

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

Midnight DBA ·

2009/09/08

Hey guys... here we kick off a discussion about some reasons why you may still not get the job even though you had an excellent interview.

en-us

14:04

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

Midnight DBA ·

2009/09/08

OK, we're just continuing our discussion of having an excellent interview.

en-us

14:04

Build .Net Objects in Powershell

Midnight DBA ·

2009/09/08

I just love the topic of this video. Here we show you how to create .NET code with powershell. While we create an .aspx page, you can build any type of .Net object dynamically. Use this process freely because it's just cool and easy and useful and full of awesome!

en-us

16:50

Keeping your Sanity when out of Work: Part 1

Midnight DBA ·

2009/09/08

Here we're discussing some ways of keeping your sanity and your confidence when you're out of a job so you can ensure you get that next gig that comes along.

en-us

15:13

Keeping your Sanity when out of Work: Part 2

Midnight DBA ·

2009/09/08

We're continuing the discussion of keeping your sanity while out of work.

en-us

10:01

TSQL: Grouping Basics

Midnight DBA ·

2009/09/07

Here's a ground level intro to grouping, with a lovely 80s arcade theme. This is a reshoot of the original Grouping Basics video (now retired).

en-us

14:26

Source Control in SSMS

Midnight DBA ·

2009/09/03

Here I show you how to setup source control in SSMS and who should and shouldn't use it.

en-us

13:45

Setup Server-Side Trace

Midnight DBA ·

2009/09/03

server side traces, the benefits, and how to set up, edit, run, and stop a server side trace.

en-us

17:32

Grouping Sets

Midnight DBA ·

2009/08/20

Here Jen and I go over grouping sets the only way we can. I hope you guys enjoy us late at night.

en-us

4:16

T-SQL: Over() and Partition By

Midnight DBA ·

2009/08/19

Show how to use OVER and PARTITION BY to get groups of data with aggregation.

en-us

2:57

Troubleshoot SSIS: "Script component cannot build...

Midnight DBA ·

2009/08/10

en-us

4:16

T-SQL: Find Last Day of Month

Midnight DBA ·

2009/08/10

Follow Jen as she steps you through 3 progressively elegant solutions for finding the last day of the month.

en-us

30:21

Deploy Packages

Midnight DBA ·

2009/08/10

Jen and I sit up very late one night and discuss how do deploy SSIS packages. If you don't know anything at all about deploying packages or just want to learn a couple tricks, then you'll love this. Plus we're tired enough to goof around a bit.

en-us

8:15

Powershell Profiles

Midnight DBA ·

2009/04/23

Here I finally address how to connect to SQL Server from powershell proper by adding the SQL Server snapins. Then I show you how to add them to your profile so you don't have to add them manually every time you start PowerShell.

en-us

16:19

HTML Styles: Part 1

Midnight DBA ·

2009/04/23

Here I continue with the HTML basics video by showing you a better way to do styles. I hinted about this in the basics video so I decided to go ahead and do it. I'll show you the ultimate way to do styles in the next one. All methods have their uses and we'll get into that sometime too. For now though, just enjoy learning header styles.

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