Welcome to the MidnightDBA Website!

Welcome to MidnightDBA.com! Here is the place we put our free technology tutorials. We cover various aspects of SQL Server and PowerShell, and whatever else strikes our fancy. You’ll also find recordings of our classes – we speak at user groups and conferences internationally – and of our live weekly IT webshow, DBAs@Midnight. As long as you’re here, check out our blogs, and our other sites: we review books and products on ITBookworm.com, and we offer our career workshop for sale at DBARoadmap.com

Our Latest Videos

Change FillFactor

Filmed: 10/19/2014

Length: 00:04:21 minutes

Learn how to change the FillFactor both at the database and at the table levels.

Click here to watch the video!
Click here to download the video!

Include and Exclude

Filmed: 10/19/2014

Length: 00:03:16 minutes

There are different ways to include and exclude both databases and tables. Here I'll show you exactly how to efficiently manage the objects you want to process.

Click here to watch the video!
Click here to download the video!

Print Statements

Filmed: 10/19/2014

Length: 00:03:27 minutes

You don't have to alter the procedure in order to print reindex statements so you can run indexes manually. This is an excellent feature that we use all the time to help troubleshoot specific index issues.

Click here to watch the video!
Click here to download the video!

Regex Exclude

Filmed: 10/19/2014

Length: 00:03:56 minutes

We have advanced exclusions in Minion Reindex. You can do anything you want with our powerful regex exclusion feature. Come see how it works.

Click here to watch the video!
Click here to download the video!

Reorder Objects

Filmed: 10/19/2014

Length: 00:04:58 minutes

You can process databases and tables in any order you like. Let me show you how much power and flexibility you have with Minion Reindex.

Click here to watch the video!
Click here to download the video!

Settings Tables

Filmed: 10/19/2014

Length: 00:17:25 minutes

You can control almost anything with the settings tables in Minion Reindex. Here I'll show you how you can completely customize your settings without creating any extra jobs.

Click here to watch the video!
Click here to download the video!