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
Category Archives: Videos
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.
- Title: Uninstall a CU in SQL Server 2008 R2 (right click here to download the WMV file)
- Date: 3/28/2011
- Length: 4:14
- Size: 7,122 KB
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.
- Title: Find query timeouts in Profiler (right click here to download the WMV file)
- Date: 2/15/2011
- Length: 8:26
- Size: 15,941 KB
Join in our live DBAs at Midnight webshow
Fridays at 11pmCST on our Ustream channel!Watch all past shows at MidnightDBA.com
Special DBAs@Midnight – GoDaddy Smackdown
We recorded and fasttracked a special edition of DBAs@Midnight – normally live on Friday nights at 11pm CST – JUST for GoDaddy. And here it is:
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:
- Ground Zero SSIS: Part 1, Part 2, Part 3
- Beginning Powershell for DBAs 1: Part 1, Part 2, Part 3, Part 4
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
- Title: Hack-Attack a Damaged DB (right-click to download video)
- Date: 1/5/2011
- Length: 15:37
- Size: 17,108 KB
Join in our live DBAs at Midnight webshow
Fridays at 11pmCST on our Ustream channel!Watch all past shows at MidnightDBA.com
New Video: Sum DB Sizes with Powershell
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.
Title: Sum DB Sizes with Powershell (right-click to download video)
Author: Sean McCown
Date: 1/4/2011
Length: 08:54
Size: 6,901 KB
New Video: Replace sp_MSForEachDB with Powershell
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.
- Title: Replace sp_MSForEachDB with Powershell (right-click to download video)
- Author: Sean McCown
- Date: 12/29/2010
- Length: 14:15
- Size: 19,475 KB