Midnight DBA

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.

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.

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.

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.

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.

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.

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

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.

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

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!

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).

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).

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

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

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