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

9:15

Fix AutoShrink in Powershell

Midnight DBA ·

2012/05/24

Here I show you how to turn off AutoShrink on a DB and then how to make sure it's turned off on all your DBs.

en-us

7:31

Get SQL Server Root Dir in Powershell

Midnight DBA ·

2012/05/24

Here we're finding the root install directory for SQL Server.

en-us

13:15

Attach DBs in Powershell

Midnight DBA ·

2012/05/23

This continues the series on detach/attach for DBs. Along the way I show you how to deal with a powershell provider bug, work with the stringCollection object, and use all 4 overloads for the AttachDatabase method.

en-us

9:12

Get IP and DNS in Powershell

Midnight DBA ·

2012/05/22

Getting IP address and DNS info from your servers in a useful format isn't as straightforward as you would think. Here I'm going to show you how to get that info painlessly and in a way you can use for all your automated processes.

en-us

7:28

Calling Detach Methods in Powershell

Midnight DBA ·

2012/05/22

Detaching DBs in Powershell is pretty easy, which is why you should learn how to do it. It takes less typing than the t-sql version. However, there are also methods for discovering which files belong to the DB that was detached and that can be invaluable when you're trying to attach a DB on a big server and you don't know where all the files may be.

en-us

8:26

Change Schema in Powershell

Midnight DBA ·

2012/05/18

Changing object schemas is easy enough in T-SQL when it's a single object, but it get considerably more complicated when you've got several objects to change, or even several thousand. This is where Powershell comes in. Here I show you how to very easily change the schema of as many objects as you like in just a few seconds. And I throw in some regex in there for good measure. Let's have some fun.

en-us

10:47

Change SQL Server Permissions in Powershell: Part 2

Midnight DBA ·

2012/05/17

Continuing from the 1st video, here I show you how to capture useful errors from the method call. I explain how to Trap the errors and loop through InnerException to make sure you get all of them. If you saw the last vid, you can't miss this one.

en-us

24:42

Change SQL Server Permissions in Powershell: Part 1

Midnight DBA ·

2012/05/17

Here I show you how to change permissions in SQL Server using Powershell. There are 2 methods I discuss and I even show you some of the problems you can run into. This is the 1st in a series so be sure to watch the 2nd one too. In This video I also reference a couple other vids. Those are here:<br><a href = "http://midnightdba.itbookworm.com/VidPages/PowershellScriptDBObjects/PowershellScriptDBObjects.aspx">Scripting DB Objects in Powershell (Advanced Topics)</a><br>

en-us

18:09

Read SQL Server Error Logs in Powershell

Midnight DBA ·

2012/05/15

Would you like to work with the SQL Server error logs in Powershell? Well here I'm gonna show you how. Not only do we pull in the current log, but I also show you how to get all of the historical logs for all the instances on the server as well. Good stuff.

en-us

18:11

Cycle Error Log on all Servers using Powershell

Midnight DBA ·

2012/05/14

Here I show you how to use the Carrier Method for using powershell to cycle all your error logs. This is an excellent way to get started using powershell, and I use it even though I know it fairly well.

en-us

01:19:21

Zombie Jesus Weekend

Midnight DBA ·

2012/04/06

Just returning from London and having missed filming last week, we're excited to be back. We talk about weather cams, teaching techs pride in their work, and the new SQL Server 2012 cert exams. And much more.

en-us

01:04:00

The SANs Of Time

Midnight DBA ·

2012/03/23

Today we start by talking about security vs. the appearance of security. And surprise, we talk about Sean hating devs and is mad at his SAN guy. And there's so much more.

en-us

1:20:51

Largest SQL Server Installs

Midnight DBA ·

2012/03/16

Kaylan Yella brings us another excellent session, this time on the largest SQL installs. If you've ever wanted to have some ammo for those people in your office who blame the bad DB performance on some sort of SQL Server threshold instead of their bad coding, then here it is. Kal shows us what the best in the world are doing with SQL Server and trust me, your install is nowhere close to reaching a threshold.

en-us

1:08:24

Fake Projects for Steve

Midnight DBA ·

2012/03/16

We're back and on the tail of Sean's plague. This week we've got some fabulous stuff. Jen does a demo of FileTable in Denali, and Sean has a couple nice rants. We talk about a vendor who wants Sean to just shut up and do what he's told, and a great skit about disk space. We're feeling good this week so come join in the fun.

en-us

1:03:57

MVP Summit 2012

Midnight DBA ·

2012/03/02

Well, we're here at the MVP Summit in Seattle. We stole a conference room at the hotel in the middle of the night to bring this show to you.

en-us

7:41

Dealing with Sql_variant in SSIS

Midnight DBA ·

2012/02/14

Every now and then you come across something you don't want to deal with that you're forced to handle in your SSIS packages. Here I'll discuss techniques for handling the Sql_variant data type in your packages so your data loads properly.

en-us

1:00:29

Yet here we are

Midnight DBA ·

2012/02/10

We've got a fabulous debacle with ShrinkDB as well as a nice powershell to add users to a bunch of servers. There's a lot more too.

en-us

18:21

Change Agent Job Properties in Powershell

Midnight DBA ·

2012/02/09

You may have occasion to change the job step properties on multiple agent jobs and here I show you how. The possibilities are almost endless here and I explore a few of them with you. You can see the full script in the accompanying blog post: <a href="http://www.midnightdba.com/DBARant/?p=791">http://www.midnightdba.com/DBARant/?p=791</a>

en-us

26:58

Data-driven Subscriptions in SSRS

Midnight DBA ·

2012/02/06

Here I get into an elegant method for giving users a report that has a dynamic distribution list. As DBAs we don't want to be in the business of managing DLs, so here we're going to use a data-driven subscription to put DL management back in the users' hands.

en-us

4:26

Deploying SSRS Reports

Midnight DBA ·

2012/02/06

One of the most common questions I get is how to deploy reports in SSRS. Here I show you pretty much everything you need to know to put your reports on the server.

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