We were busy little bees over the Labor Day holiday (or, for our European readers, "houliday"). All of these are great, of course, but I'm going to steer you DIRECTLY to Sean's new video on Recovering SQL Passwords…do not pass anywhere or collect anything, just watch it!
-
Recover SQL Passwords – Did you know that SQL Server stores username/password combos in cleartext in memory? And did you know that you can also use a debugger to sniff the memory to retrieve those passwords? Here I show you how to attach to an instance of SQL Server with a debugger and get a password you need to retrieve. Thanks again to Sentrigo for bringing this to all of our attention. 12 minutes
-
T-SQL: CASE Statement – Here’s an intro to case statements, in the form of a conversation with Sean. I cover simple case and searched case, and the special use of null. BTW, I really like this video, and I don’t say that very often. 12 minutes.
-
Grouping Basics: Level Zero – Here’s a ground level intro to grouping, with a lovely 80s arcade theme. See the next blog post for the written companion to this video. 10 minutes.
-
Dirty Tricks: List from CMD – Here’s one of my dirty tricks: getting a list of folders or files from a command prompt, and formatting it for use in code using Word. This is the extended remix version of a Midnight Snack. 7 minutes.
-
Troubleshooting Simple Flatfile Load Errors – In this video I put together a small SSIS flatfile-to-SQL package, and troubleshoot a couple of errors. 11 minutes.
- Who Should Manage Backups – SORRY GUYS!!! This was about a 45min video and a glitch with the computer lost the first part of it so you only get the last 19mins. We thought about recording it again, but we honestly don't remember what we said so I made the command decision to just post it as-is. 19 min.
-Jen McCown, http://www.MidnightDBA.com