Midnight DBA

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.

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

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.

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.

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.

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.

Find out 2 ways to tell when SQL Server started.

Learn how to diagnose BCP import problems.

Learn how to BCP data into a table.

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

Learn how to perform basic backups with SQL syntax.