Category Archives: Videos

Changing user passwords

Most of us have sa and have for a long time, so exactly what it takes for an end user to change his own password isn’t typically a concern for us. And since it came up at work yesterday I decided to make a video about it.
So if you’d like to see what it takes for a user to be able to change his own password, you can see the new vid here:
http://midnightdba.itbookworm.com/VidPages/ChangeUsersPword/ChangeUsersPword.aspx

How to Curse in an Interview

Last weekend at SQL Saturday #63 Dallas, I presented a session titled “How to Curse in an Interview”.  It clearly contains some NSFW language, but it was really a good session, and I got a lot of positive feedback.  The recorded session is up on the MidnightDBA Events page

Here is the abstract:

How to curse in an interview

Prof. Development Track –2:45 pm to 3:45 pm

This session will take a hard look at different things that happen in interviews and give you what you need to know to get that next job. This isn’t a recruiter session that’ll tell you to wear a tie and smile. I’m a real Sr. DBA who hires DBAs all the time. I’m going to tell you what we look for in a DBA, and the types of things you should and shouldn’t say. I’ll show you how to pass a tech screening and get past the HR portion as well. Your mama can teach you how to dress. I’m gonnateach you how to get hired. You seriously can’t afford to miss this discussion because it’ll be the most candid anyone will ever be with you about interviews. This will be a fun and very interactive session.

And as long as we’re here, here are a few other things I’ve presented at SQL Saturdays:

New Video: Uninstall a CU in SQL Server 2008 R2

Here I’ll show you how to uninstall a CU from SQL Server 2008 R2, CU5 to be specific, but it doesn’t matter. Here there’s a special circumstance where the original install media location doesn’t exist anymore so you have to specify it during the uninstall.

Join in our live DBAs at Midnight webshow
Fridays at 11pmCST on our Ustream channel!

Watch all past shows at MidnightDBA.com

New Video: Find query timeouts in Profiler

Here’s the scenario: Users are complaining that queries are timing out, but nobody knows what queries or SPs go with what tabs on the front end. It’s up to you to find out where the problem is…

This new video shows you how to get query timeouts from a profiler trace.

Join in our live DBAs at Midnight webshow
Fridays at 11pmCST on our Ustream channel!

Watch all past shows at MidnightDBA.com

Best Backup Class Evar: 1 of 6

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 can be found here.

Title: Best Backup Class Evar: 1 of 6 (Right-click to download video)
Date: 1/20/2011
Length: 57:31
Size: 58,381 KB

Here are the other series-style classes I’ve taught at NTSSUG:

 

Join in our live DBAs at Midnightwebshow
Fridays at 11pmCST on our Ustream channel!

Watch all past shows at MidnightDBA.com

New Video: Hack-Attack a Damaged DB

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: Hack-attack a damaged DB

 

Join in our live DBAs at Midnight webshow
Fridays at 11pmCST on our Ustream channel!

Watch all past shows at MidnightDBA.com