Midnight DBA

What do you do if you have a set of data and log files you can't attach because the log is damaged? Here I show you a way to attach it, fix it, and get going again. Paul Randall also discussed this in his blog here: <a href="http://www.sqlskills.com/BLOGS/PAUL/post/Disaster-recovery-101-hack-attach-a-damaged-database.aspx" target = "_blank">Hack-attack a damaged DB</a>

Quite often it can be useful to not only get a list of DB sizes, but also sum it up in the last line. This can be useful for estimating backup file sizes, server sizing and more. Here I'll show you a couple ways to sum up DB sizes so take your pick.

I think we had a lot of fun this week. We talked about useless superpowers, rules for presenting to techies, and stuff we got for x-mas... and more.

A user request came in to write something in powershell that would replace sp_MSForEachDB. I took it a step further and showed you how to make it even more flexible for an enterprise environment.

This week we talk about great smells you'd never find in a shampoo, and follow that with a really good discussion on the 24HOP women's edition and compare that to maybe a black or Indian edition, and we unveil a new award.

There's just no substitute for a good story and tonight Sean tells one about an interview he just had. We also talk about cluster problems, heaps, and mentos and coke.

We love talking to Adam. He's such a cool dude and it just so happens that he really knows his stuff too. I had a hard time compiling this vid because something corrupted it toward the end, but I can still give you 47mins of it.

This is our post-Thanksgiving episode. Today we talk about why Bing sucks, jr. DBAs, and the cloud.

This week we have Eric Humphrey in the studio and while we get different grooves on, the main topic is sexual harassment.

This is our show at the end of PASS 2010 and we have Nic Cain in our hotel room. Come have a look while things degenerate into our usual childish antics.

We hooked up with Steve Jones of SQLServerCentral.com in an empty ballroom we hijacked the night before PASS. He's so laid back we decided to stay a cuddle for a while after filming.

If you don't know Mark Souza, you should. He's one of the coolest guys we know and one of the smartest guys other than myself you'll ever meet. Mark is the head and the founder of the SQL CAT team at MS. Come see what we were able to get out of him.

Denny is one of our best friends at PASS. We were all so tired that we cut the talk short and meant to get back to it but we never did. Before we left though we did manage to talk about some of the new features announced by MS at the keynote.

What can we say about Grant that isn't already in the police report? He's just an interesting guy. Come see us discuss query tuning and Kenpo with Grant.

I suppose this is officially our Halloween episode. Come along as we discuss whatever it is we talked about here.