Midnight DBA

Today we're talking about database hacks, getting rid of problems, Denny Cherry's new book, and more.

The 3rd in the backup class at NTSSUG.

Paul and Kim Tripp from SQLSkills.com came to teach us their award-winning presentation on DB performance.

Prerequisite: The previous show called 'Leaking MVPee'. Once you get past the last episode you'll know what we're talking about here. However, we also get into plan guides, doing your job, and the smartest recruiter on earth.

This week we're all about sa passwords, buying software you don't need, our new ringtones, and troubleshooting code errors.

Here we are on the back of the 2011 MVP Summit, and we're gonna give away some Denali secrets. For those of you who don't know, Denali is the next version of SQL Server, and some of the things we're telling you definitely aren't being talked about at all.

Our botched commercial, the new Infragistics MVP, resume review and much more on this week's episode.

The 2nd in the backup class at NTSSUG.

We talked briefly about Egypt's revolution, and then got onto the techie stuff: Companies We Love poll results, Un-SQL Friday, King 5 Fingers, Sean's NetworkWorld blog on Mentoring, a recommendation for the book Code Complete, ITBookworm.com, SSMS Tools Pack, and oh so much more!

I like this video. This is a simple example of how you can track down queries that are timing out. Be careful though. If your trace table is too large it can take a long time to pull back the results. You can also add other elements to this to increase the accuracy. Perhaps I'll put together a sequel sometime.

Here we are on the back end of SQLSaturday #57 in Houston. We decided to make a party out of it and bring along Wes Brown and Patrick LeBlanc. We discuss backups, GoDaddy, and Joe Celko. It was bigtime fun.

Tonight we talk about a big downtime at Pilgrim's Pride, 24-HOP sessions, a yearly downtime report, ownership chains, cross joins, and much more.

Here's the first of a series of backup/restore classes taught at the NTSSUG. This series is meant to cover everything about backups... or at least as much as we can squeeze into 6 sessions. You'll learn how to put together an enterprise backup solution, tune your backups for maximum performance, and manage them across your company no matter how many servers you have. The file used for this class <a href="http://MidnightDBA.ITBookworm.com/EventScripts/BackupClass1.zip">can be found here</a>.

This is probably our best show to date. Not only do we crown a new MVP, but we have so many HUGE gueses you'll slap your mama. This show is just fun and you'll never know who calls in.

This is our New Year's eve episode and we had plenty of fun. There's some good techie stuff in there too. And at the end, we have a very nice surprise with a sledgehammer.