Midnight DBA
By Sean McCown
To listen to an audio podcast, mouse over the title and click Play. Open iTunes to download and subscribe to podcasts.
Podcast Description
I teach everything from SSIS to Windows and networking, to Powershell tricks. Everything is centered around the DBA.
| Name | Description | Released | Price | ||
|---|---|---|---|---|---|
| 1 | ExplicitVideoThey kept felons | 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! | 2/22/11 | Free | View In iTunes |
| 2 | ExplicitVideoFind query timeouts in Profiler | 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 . | 2/22/11 | Free | View In iTunes |
| 3 | ExplicitVideoYou got munkey lips | 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. | 2/22/11 | Free | View In iTunes |
| 4 | ExplicitVideoSean gets 69 | 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. | 2/22/11 | Free | View In iTunes |
| 5 | ExplicitVideoBest 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 . | 1/23/11 | Free | View In iTunes |
| 6 | ExplicitVideoHottub of Bellydancers | 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. | 1/23/11 | Free | View In iTunes |
| 7 | ExplicitVideoSledgehammer of Justice | 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. | 1/12/11 | Free | View In iTunes |
| 8 | ExplicitVideoHack-attak 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: | 1/12/11 | Free | View In iTunes |
| 9 | ExplicitVideoSum 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. | 1/3/11 | Free | View In iTunes |
| 10 | ExplicitVideoUseless Superpowers | 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. | 1/3/11 | Free | View In iTunes |
| 11 | ExplicitVideoSmell my Guitar | 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. | 1/3/11 | Free | View In iTunes |
| 12 | ExplicitVideoReplace 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. | 12/29/10 | Free | View In iTunes |
| 13 | ExplicitVideoStallin SQL like a Mofo | 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. | 12/20/10 | Free | View In iTunes |
| 14 | ExplicitVideoSexual Harassment | This week we have Eric Humphrey in the studio and while we get different grooves on, the main topic is sexual harassment. | 12/13/10 | Free | View In iTunes |
| 15 | ExplicitVideoBathrobe Bonanza | This is our post-Thanksgiving episode. Today we talk about why Bing sucks, jr. DBAs, and the cloud. | 12/13/10 | Free | View In iTunes |
| 16 | ExplicitVideoAdam Machanic has soft hands | 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. | 12/13/10 | Free | View In iTunes |
| 17 | ExplicitVideoMerkin Glue | 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. | 11/24/10 | Free | View In iTunes |
| 18 | ExplicitVideoDenny 'Five Fingers' Cherry | 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. | 11/18/10 | Free | View In iTunes |
| 19 | ExplicitVideoNo Management DBs | I suppose this is officially our Halloween episode. Come along as we discuss whatever it is we talked about here. | 11/18/10 | Free | View In iTunes |
| 20 | ExplicitVideoGrant Fritchey is our Hero | 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. | 11/18/10 | Free | View In iTunes |
| 21 | ExplicitVideoSteve Jones in the House!! | 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. | 11/18/10 | Free | View In iTunes |
| 22 | ExplicitVideoThe Mark Souza Sandwich | 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. | 11/18/10 | Free | View In iTunes |
| 23 | ExplicitVideoSean's Man-crush | This week we talk about Freddie bringing our site down, we unveil a new award, and we had a near cornhole of the week. And Jen gets Sean a really cool present. | 11/14/10 | Free | View In iTunes |
| 24 | ExplicitVideoYour Face or Mine? | I suppose this is officially our Halloween episode. Come along as we discuss whatever it is we talked about here. | 11/14/10 | Free | View In iTunes |
| 25 | ExplicitVideoThe Unnamed Episode | This week was pure fun as we talked about building clusters, Sean's Scripting Guys article, and whether or not you should rally people to vote for you in a contest. We also talked about many other things including the hit Showtime show Dexter. | 11/14/10 | Free | View In iTunes |
| 26 | ExplicitVideoWhat kind of pistol? | Sorry, I don't remember what we talked about here cause I'm uploading so late. You'll just have to come see. | 11/14/10 | Free | View In iTunes |
| 27 | ExplicitVideoPolishing Dung | This week we're talking about all kinds of things, the main one being people getting started as speakers and community leaders. There's lots of other stuff I honestly can't remember right now. | 11/14/10 | Free | View In iTunes |
| 28 | ExplicitVideoOlympic Cornholing | This week we talk about sex week on MidnightDBA as well as big production problems, crappy vendors, and more. | 11/14/10 | Free | View In iTunes |
| 29 | ExplicitVideoAristocratic Corn | Our first show of season 2. We catch everyone up on what's been going on since we left and throw in some SSIS discussion and an excellent book recommendation for clustering. | 11/14/10 | Free | View In iTunes |
| 30 | ExplicitVideoMonitor Backups with Powershell | I know you guys are just begging for an easy way to monitor your backups and alert when one hasn't been backed up recently. Here's a great way to do it in powershell, and it's easy as pie. | 11/14/10 | Free | View In iTunes |
| 31 | ExplicitVideoAudit Service Accounts with Powershell | How would you like to be able to audit your service accounts with powershell so you can tell how many boxes are running on the same account? Well now you can, and it's very easy. Come let me show you how to write a script that you can use to audit all of the SQL service accounts in your environment. | 11/14/10 | Free | View In iTunes |
| 32 | ExplicitVideoQuick, get the Bedazzler! | This was a fun episode. We introduce our new Freddie and talk about all kinds of things like Star Trek translators and Microsoft makes cornhole of the week. | 11/14/10 | Free | View In iTunes |
| 33 | ExplicitVideoUser Processes: 2 of 2 | Part 2 of User Processes. | 5/17/10 | Free | View In iTunes |
| 34 | ExplicitVideoUser Processes: 1 of 2 | We're both SO P****D OFF!! We did over an hours worth of show and only 30mins got recorded. However, in this 30mins we talked about users dictating processes, speaking the user's language, vendor support and more. | 5/17/10 | Free | View In iTunes |
| 35 | VideoWhen to Leave your Job: 2 of 5 | Part 2 of When to Leave your Job. | 5/17/10 | Free | View In iTunes |
| 36 | VideoWhen to Leave your Job: 5 of 5 | Part 5 of When to Leave your Job. | 5/17/10 | Free | View In iTunes |
| 37 | VideoWhen to Leave your Job: 1 of 5 | This week we're talking about how to have a conversation with your DBA if he's not performing like he should. | 5/17/10 | Free | View In iTunes |
| 38 | VideoWhen to Leave your Job: 3 of 5 | Part 3 of When to Leave your Job. | 5/17/10 | Free | View In iTunes |
| 39 | VideoWhen to Leave your Job: 4 of 5 | Part 4 of When to Leave your Job. | 5/17/10 | Free | View In iTunes |
| 40 | VideoT-SQL Codig Sins: SQL Saturday #41 - Atlanta | Come see Jen teach T-SQL Code Sins at SQL Saturday #41 in Atlanta. You see these huge mistakes in many shops so come take advantage of Jen's vast experience coding in real environments and avoid some of the mistakes she's seen. | 4/30/10 | Free | View In iTunes |
| 41 | VideoBeginning T-SQL: SQL Saturday #41 - Atlanta | Come see Jen teach beginning T-SQL at SQL Saturday #41 in Atlanta. Her clear explanations of things shorten your time to understand this complicated topic. | 4/30/10 | Free | View In iTunes |
| 42 | VideoFiring DBAs: Part 2 | Part 2 of Firing DBAs. | 4/29/10 | Free | View In iTunes |
| 43 | VideoFiring DBAs: Part 4 | Part 4 of Firing DBAs. | 4/29/10 | Free | View In iTunes |
| 44 | VideoFiring DBAs: Part 3 | Part 3 of Firing DBAs. | 4/29/10 | Free | View In iTunes |
| 45 | VideoFiring DBAs: Part 1 | This week we have a nice talk about how to handle a DBA who isn't performing like he should (No, not like that!!). We also talk about bad GPSs and other stuff. | 4/29/10 | Free | View In iTunes |
| 46 | VideoAdopting New Features: 4 of 4 | Part 4 of Adopting New Features. | 4/20/10 | Free | View In iTunes |
| 47 | VideoAdopting New Features: 1 of 4 | While playing with our SQLChickens, we're trying to top the plagiarism video from last week in Redmond. So after messing around a little bit, our main topic this week is when to adopt new features and whether it's more hassle to support them in conjunction with old code or not. | 4/20/10 | Free | View In iTunes |
| 48 | VideoAdopting New Features: 2 of 4 | Part 2 of Adopting New Features. | 4/20/10 | Free | View In iTunes |
| 49 | VideoAdopting New Features: 3 of 4 | Part 3 of Adopting New Features. | 4/20/10 | Free | View In iTunes |
| 50 | VideoPlagiarism: 4 of 4 | Part 4 of Plagiarism. | 4/6/10 | Free | View In iTunes |
| 51 | VideoPlagiarism: 3 of 4 | Part 3 of Plagiarism. | 4/6/10 | Free | View In iTunes |
| 52 | VideoPlagiarism: 2 of 4 | Part 2 of Plagiarism. | 4/6/10 | Free | View In iTunes |
| 53 | VideoPlagiarism: 1 of 4 | This is a fun one we did in Redmond while waiting for the SQL Server R2 TweetUp event at MS. We're here with Denny Cherry and Jorge Segarra to discuss the plagiarist John Dunleavy who has insisted on stealing material from real writers and authors and passing it off as his own. Come support us in our fight against smarmy little thieves like this. | 4/6/10 | Free | View In iTunes |
| 54 | VideoNo Religion at Work: 3 of 4 | Part 3 of No Religion at Work. | 4/3/10 | Free | View In iTunes |
| 55 | VideoNo Religion at Work: 4 of 4 | Part 4 of No Religion at Work. | 4/3/10 | Free | View In iTunes |
| 56 | VideoManage DB Files in Powershell | I'm excited to be able to film this one because it has the potential to save you so much time and effort. I'm showing you how to manage your DB files with powershell so you can change autogrowth, or whatever property you like. This is an extremely effective way to ensure that the DB files on all your servers are setup the way you want. | 4/3/10 | Free | View In iTunes |
| 57 | VideoNo Religion at Work: 2 of 4 | Part 2 of No Religion at Work. | 4/3/10 | Free | View In iTunes |
| 58 | VideoNo Religion at Work: 1 of 4 | This is a nice film with a few good laughs and we also get in our first on-film fight. However, come with us to discuss religion at work and how you should handle someone who insists on trying to discuss it. | 4/3/10 | Free | View In iTunes |
| 59 | VideoStuff Auction: 1 of 3 | This is another fun one for us. Frankly, I really had a good time doing this one. The main topics are sharking someone's stuff and your 1st priorities when you start a new job. | 2/20/10 | Free | View In iTunes |
| 60 | VideoStuff Auction: 3 of 3 | Part 3 of Stuff Auction. | 2/20/10 | Free | View In iTunes |
| 61 | VideoStuff Auction: 2 of 3 | Part 2 of Stuff Auction. | 2/20/10 | Free | View In iTunes |
| 62 | VideoBreaking up with your Boss: 3 of 4 | In part 3: Why I got nervous the day I quit. I mention The Gift of Fear by Gavin DeBecker Sean tells a big secret about his past We learn THE wording to use when leaving a job. We discuss various responses to "Why are you leaving?" Sean's Blue Cross story | 2/4/10 | Free | View In iTunes |
| 63 | VideoBreaking up with your Boss: 2 of 4 | In part 2: Forms, puns, my new job... 5:30 We get on How To Break Up With Your Boss Feeling bad for your boss, the company, the project: Feelings fade quickly! 13:20 So how do you break up, then? | 2/4/10 | Free | View In iTunes |
| 64 | VideoBreaking up with your Boss: 4 of 4 | In part 4: Conclusion of Blue Cross story. Exit interviews. Celebrity status. Different ways of leaving a job - the nice breakup, and THE BAD ONE (Jen's story). Things you can do to mitigate a bad breakup Sean's Arcserve story | 2/4/10 | Free | View In iTunes |
| 65 | VideoBreaking up with your Boss: 1 of 4 | This is another one that I just love. We ramble on a bit I think, but overall I think we give some good info on a topic that's often times overlooked. | 2/4/10 | Free | View In iTunes |
| 66 | VideoBeginning Execution Plans | Here's a level zero introduction to tuning queries. I go over execution plans, sp_help, and clustered primary key indexes. | 2/2/10 | Free | View In iTunes |
| 67 | VideoResumes: 2 of 3 | Part 2 of Resumes. | 1/31/10 | Free | View In iTunes |
| 68 | VideoResumes: 1 of 3 | This is a fun vid. Here we talk about resumes. How long should they be? What should you put in them? Should you have it professionally done? We also give away a webcam in this series. In all, I think this is the best one we've done in a while. | 1/31/10 | Free | View In iTunes |
| 69 | VideoResumes: 3 of 3 | Part 3 of Resumes. | 1/31/10 | Free | View In iTunes |
| 70 | VideoCompanies don't Care | We're back with another DBAs@Midnight. This week we're talking about how companies don't really care enough about their employees to keep them. We also discuss SQL Saturday 35 here in Dallas, and some other stuff. | 1/27/10 | Free | View In iTunes |
| 71 | VideoBI'll Ramos Talks Tools: 1 of 2 | If you don't know Bill, he's on the tools team, so he's the one you talk to when there's something you don't like in SSMS. | 11/15/09 | Free | View In iTunes |
| 72 | VideoBI'll Ramos Talks Tools: 2 of 2 | Part 2 with BI'll Ramos. | 11/15/09 | Free | View In iTunes |
| 73 | VideoThe Early Bird Gets Brian Knight: 1 of 2 | What can I say, Brian is just the bomb. He has more SSIS knowledge under his fingernails than the rest of us do all over. | 11/14/09 | Free | View In iTunes |
| 74 | VideoThe Early Bird Gets Brian Knight: 2 of 2 | Brian's cute, and brilliant, and he's here for another round. | 11/14/09 | Free | View In iTunes |
| 75 | VideoPaul and KI'm Tripp: 1 of 2 | The Tripps are here and one of them is the apple of our eye. Can you guess which one? I think these 2 are the best interview ever. They're constantly laughing, and why not... they get to travel the world together and teach losers like us how to spell DBCC and index. These guys are some of our best friends in the industry and after all this time, I stI'll learn so much from them. So let's give it up for KI'm and her man-servant Paul! | 11/10/09 | Free | View In iTunes |
| 76 | VideoPaul and KI'm Tripp: 2 of 2 | The Tripps are here and one of them is the apple of our eye. Can you guess which one? I think these 2 are the best interview ever. They're constantly laughing, and why not... they get to travel the world together and teach losers like us how to spell DBCC and index. These guys are some of our best friends in the industry and after all this time, I stI'll learn so much from them. So let's give it up for KI'm and her man-servant Paul! | 11/10/09 | Free | View In iTunes |
| 77 | VideoGet Jiggy with Allen White: 1 of 2 | We're here at PASS 2009 in Seattle and we caught up with my friend Allen White. We talked about SQL, and Oracle, and even some of the mistakes we've made while on the job. It was a great time had by all. | 11/10/09 | Free | View In iTunes |
| 78 | VideoGet Jiggy with Allen White: 2 of 2 | Finishing up with Allen White... good times. | 11/10/09 | Free | View In iTunes |
| 79 | VideoPASS Summit 09 Interview: Itzik Ben-Gan, 2 of 2 | Part 2 of Itzik. | 11/8/09 | Free | View In iTunes |
| 80 | VideoPASS Summit 09 Interview: Itzik Ben-Gan, 1of2 | We found Itzik at PASS 2009 and decided to keep him. This is a very informative interview on a number of topics. | 11/8/09 | Free | View In iTunes |
| 81 | VideoDBAs@Midnight: Managing Tasks 2 of 2 | Here's the exciting conclusion to the 1st one. | 9/25/09 | Free | View In iTunes |
| 82 | VideoDBAs@Midnight: Managing Tasks 1 of 2 | This one was rather fun because it was another one of those nights when were were both rather punchy. HOwever, amidst all the messing around and backtracking we did manage to talk about something. We talked about managing tasks, moving schema, and give a brief intro to project Madison. I'm sure there's some other stuff in there too but I can't remember everything. Oh yeah, we even touch on SQL upgrade too. | 9/25/09 | Free | View In iTunes |
| 83 | VideoDBAs@Midnight: No Moving Schema | OK guys, here we're talking about no moving schema. If you don't know what that is, then watch this and see not only what it is, but what problems it can cause. We also discuss SQL Saturday a bit. | 9/17/09 | Free | View In iTunes |
| 84 | VideoFix SSIS Pkg Import Errors | This is a live troubleshooting video. I had an error importing an SSIS pkg so I turned on the camera and worked the issue live for you. A couple of the symptoms are not being able to copy tasks inside Visual Studio and getting an error about not being able to serialize the runtime object. This is one of those cases where at least being exposed to the types of things that can go wrong wI'll help you come up with a solution even when you've never seen a specific error. | 9/13/09 | Free | View In iTunes |
| 85 | VideoAdd User to Windows Group with Powershell | I love this video because it's so unusual to find something like it in the DBA community. We're quite often called on to do things outside of our direct job descriptions and this is something I have to do a lot. So I'm showing you how to add a user to a Windows group so you don't have to TS into a lot of boxes to add someone. | 9/13/09 | Free | View In iTunes |
| 86 | VideoGet a Specific Method in Powershell | Sometimes the list of properties and methods is too big to sift through when you do a get-member on an object. Here I'll show you how to cut down the list to a more manageable size so you can find exactly what you're looking for. | 9/12/09 | Free | View In iTunes |
| 87 | VideoChange DB Compatibility Level in Powershell | Here I show you 2 easy ways to change the DB compatibility level in powershell. Otherwise you have to use a T-SQL cursor and that's not only much harder, it's just no fun. Trust me... use powershell for stuff like this and you'll be much happier. | 9/12/09 | Free | View In iTunes |
| 88 | VideoBuild .Net Objects in Powershell | I just love the topic of this video. Here we show you how to create .NET code with powershell. While we create an .aspx page, you can build any type of .Net object dynamically. Use this process freely because it's just cool and easy and useful and full of awesome! | 9/7/09 | Free | View In iTunes |
| 89 | VideoGood Interview StI'll Don't Get the Job: Part 1 | Hey guys... here we kick off a discussion about some reasons why you may stI'll not get the job even though you had an excellent interview. | 9/7/09 | Free | View In iTunes |
| 90 | VideoKeeping your Sanity when out of Work: Part 1 | Here we're discussing some ways of keeping your sanity and your confidence when you're out of a job so you can ensure you get that next gig that comes along. | 9/7/09 | Free | View In iTunes |
| 91 | VideoGood Interview StI'll Don't Get the Job: Part 2 | OK, we're just continuing our discussion of having an excellent interview. | 9/7/09 | Free | View In iTunes |
| 92 | VideoKeeping your Sanity when out of Work: Part 2 | We're continuing the discussion of keeping your sanity while out of work. | 9/7/09 | Free | View In iTunes |
| 93 | VideoTSQL: Grouping Basics | Here's a ground level intro to grouping, with a lovely 80s arcade theme. This is a reshoot of the original Grouping Basics video (now retired). | 9/6/09 | Free | View In iTunes |
| 94 | VideoSetup Server-Side Trace | server side traces, the benefits, and how to set up, edit, run, and stop a server side trace. | 9/2/09 | Free | View In iTunes |
| 95 | VideoSource Control in SSMS | Here I show you how to setup source control in SSMS and who should and shouldn't use it. | 9/2/09 | Free | View In iTunes |
| 96 | VideoWrite Good Dynamic SQL | Here I show you a couple methods for getting around really hard to read dynamic SQL. | 8/19/09 | Free | View In iTunes |
| 97 | VideoGrouping Sets | Here Jen and I go over grouping sets the only way we can. I hope you guys enjoy us late at night. | 8/19/09 | Free | View In iTunes |
| 98 | VideoT-SQL: Over() and Partition By | Show how to use OVER and PARTITION BY to get groups of data with aggregation. | 8/18/09 | Free | View In iTunes |
| 99 | VideoTroubleshoot SSIS: "Script component cannot build user component" | Here we show you how to tshoot a specific error in SSIS. | 8/9/09 | Free | View In iTunes |
| 100 | VideoT-SQL: Find Last Day of Month | Follow Jen as she steps you through 3 progressively elegant solutions for finding the last day of the month. | 8/9/09 | Free | View In iTunes |
| 101 | VideoDeploy Packages | Jen and I sit up very late one night and discuss how do deploy SSIS packages. If you don�t know anything at all about deploying packages or just want to learn a couple tricks, then you�ll love this. Plus we�re tired enough to goof around a bit. | 8/9/09 | Free | View In iTunes |
| 102 | VideoCool New SSMS Features for DBAs | I give MS a hard time sometimes so I like to give them props when I find something really worth it. And here I discuss 3 new features in Katmai that are mainly for DBAs. They're really cool so pay attention and enjoy. | 7/22/09 | Free | View In iTunes |
| 103 | VideoBackup with Init | In this video I discuss the init option for the backup command. You'll come away knowing how to use it and what it's for. | 6/19/09 | Free | View In iTunes |
| 104 | VideoBCP With Hyperbac | Here I show you how to automatically compress BCP operations with Hyperbac. It's just a cool bonus you get when you do you database backups with this utility. | 6/17/09 | Free | View In iTunes |
| 105 | VideoBCP in errors | Learn how to diagnose BCP import problems. | 4/15/09 | Free | View In iTunes |
| 106 | VideoBCP in | Learn how to BCP data into a table. | 4/13/09 | Free | View In iTunes |
| 107 | VideoKatmai Server Group Management | Learn how to use the new group server mgmt functionality in the Katmai SSMS. | 3/31/09 | Free | View In iTunes |
| 108 | VideoBasic Backup | Learn how to perform basic backups with SQL syntax. | 3/18/09 | Free | View In iTunes |
| 109 | VideoCompression Basics | I'm going over the basics of how to implement data compression here. I'm not really touching on where and why you�d want to do it, but how to once you�ve made the decision. | 3/9/09 | Free | View In iTunes |
| 110 | VideoInterpreting Disk Queues | Disk queues are a mystery for the majority of DBAs. They may know that they need to look at them, but they have no idea what they mean. Here I'll show you how to know what you'relooking at to see when your disk queues are too high. This tutorial doesn't go into how to fix the problem really, it's more just how to diagnose it. | 2/1/09 | Free | View In iTunes |
| 111 | VideoScripting DB Objects in Powershell (Advanced Topics) | Here I get past the basics of using the Script() method and take you to how to recreate some of the scripts you can create in SSMS by instantiating a scriptingOptions object and passing it to the method. | 12/1/08 | Free | View In iTunes |
| 112 | VideoScripting DB Objects in PowerShell | Continuing with PowerShell I thought I�d show you something really cool you can do that would make a difference in your shop right away. So here I'm showing you how to script your tables, etc in PowerShell so you can automate them and add them to your processes. This is an excellent example of how cool and useful this scripting language is. I hope it makes you as excited about PowerShell as it does me. | 11/23/08 | Free | View In iTunes |
| 113 | VideoRunas Magic | This is a really good video on how to use the RunAs utility in windows. There are several scenarios when a DBA/Dev may need to logon to a program with separate credentials and this takes you a good way to getting there. The process is simple, but it comes with some caveats. I don�t even come close to discussing the whole topic here but like I said, it's an excellent start that takes you past the basics of the right-click. | 11/17/08 | Free | View In iTunes |
| 114 | VideoCompression Basics | I'm going over the basics of how to implement data compression here. I'm not really touching on where and why you�d want to do it, but how to once you�ve made the decision. | 11/15/08 | Free | View In iTunes |
| 115 | VideoPowershell Profiles | Here I finally address how to connect to SQL Server from powershell proper by adding the SQL Server snapins. Then I show you how to add them to your profile so you don�t have to add them manually every time you start powershell. | 11/4/08 | Free | View In iTunes |
| 116 | VideoHTML Styles: Part 1 | Here I continue with the HTML basics video by showing you a better way to do styles. I hinted about this in the basics video so I decided to go ahead and do it. I'll show you the ultimate way to do styles in the next one. All methods have their uses and we�ll get into that sometime too. For now though, just enjoy learning header styles. | 10/28/08 | Free | View In iTunes |
| 117 | VideoBasic HTML for DBAs | After my last video I got some emails saying that not all DBAs already know HTML. So I decided to teach some basic HTML that DBAs can use in their daily jobs. So if you'rea DBA and you�ve always wanted to tackle HTML, don't worry... it's easier than it sounds. | 10/21/08 | Free | View In iTunes |
| 118 | VideoBuilding a Powershell BCP Routine | Here I show you how to build a script that wI'll BCP an entire group of tables and even log the progress. You can make the routine as simple or as rich as you like. These are the building blocks of such a process and wI'll take you far in your endeavors. There are several techniques taught in this video so pay attention to the details and you�ll come away with a richer knowledge of powershell. | 10/14/08 | Free | View In iTunes |
| 119 | VideoWhen did SQL Server Start? | Find out 2 ways to tell when SQL Server started. | 10/7/08 | Free | View In iTunes |
| 120 | VideoSending HTML SQL Emails | I'm actually excited to be able to bring you this video because this is a topic that comes up quite often in DBA circles. The topic is how do you format a nice HTML email that you send through SQL. Being able to return a query as the body of an email comes in handy all over the place. I really hope you guys get as much out of this as I do. | 10/4/08 | Free | View In iTunes |
| 121 | ExplicitVideoOptimize For Adhoc Workloads | There's a lovely sp_configure option that can help you keep the size of your plan cache under control. Let's go have some fun. | Free | View In iTunes | |
| 122 | ExplicitVideoSeason 3 Opener | We're kicking off another season with a bang. We get to talk to Paul Nielsen, the author of the SQL Server Bible series of books, and we reveal a new award. | Free | View In iTunes | |
| 123 | ExplicitVideoLOL Cats | This was a fun week because we talked about xlocks on tempdb, nested views, and new SQL languages. | Free | View In iTunes | |
| 124 | ExplicitVideoCherry Cheesecake | This week we cover Sean's mainframe story, twitter updates, Alan Hirt's new whitepaper, and Itzik is here again. | Free | View In iTunes | |
| 125 | ExplicitVideoServer Properties | Have you ever wanted to be able to view instance-level stats or change certain values without having to use the GUI? Here I'll show you how to do all your boxes with Powershell. | Free | View In iTunes | |
| 126 | ExplicitVideoFind File Lock | Have you ever been plagued by a file you couldn't delete or move because it was being held open by something else? Well here I'm going to show you how to find out what's holding the file open so you can go deal with it. | Free | View In iTunes | |
| 127 | ExplicitVideoP.I.O. | This was such a fun week. We talked about our new videos and our new reviews on ITBookworm. We also have our T-SQL spotlight, interview question of the week, and so much more. | Free | View In iTunes | |
| 128 | ExplicitVideoFormat Multiple SSRS Table Fields | One irritating thing about SSRS is that you have to set the text box properties (say, to format numbers as currency) for each individual text box, unlike Excel. Here’s a better way (with some restrictions) to update the formatting for multiple text boxes. Companion tutorial to my Tip: | Free | View In iTunes | |
| 129 | ExplicitVideoCreate and Edit a Simple SSRS Report | Here we create, populate and format a simple SSRS report. This is a companion to my Petri article | Free | View In iTunes | |
| 130 | ExplicitVideoSeason 2 Finale | Another season comes to a close. We give a nice recap of the entire season, a strange DB problem, and adding NULLs. And there's so much more. | Free | View In iTunes | |
| 131 | ExplicitVideoInsert Into vs. Select Into | Knowing how and when to use Insert Into or Select Into can quite often make or break your load process. Here I show you how to tell the difference between them and what their effects are. | Free | View In iTunes | |
| 132 | ExplicitVideoUNION and UNION ALL | Here I talk about UNION and UNION ALL, and the different rules about using ORDER BY, GROUP BY, SELECT INTO, and INSERT INTO with a UNION/UNION ALL query. | Free | View In iTunes | |
| 133 | ExplicitVideoRapture Party | This week we're preparing for the rapture and we have some exciting news about a brand new Microsoft product. You won't believe what they've been up to. | Free | View In iTunes | |
| 134 | ExplicitVideoDBCC FixProblems | Lots of news this week beginning with Adam Mechanic's new training company, SSIS improvements in Denali, and some training camps. We also talk about log shipping, and much more. | Free | View In iTunes | |
| 135 | ExplicitVideoWindows Crash Dump Analysis | If Windows has ever bluescreened on you, then you know how important it can be to find the issue. Windows creates a crash dump file whenever it bluescreens and here I'm going to show you how to use that dump file to figure out what caused the bluescreen. | Free | View In iTunes | |
| 136 | ExplicitVideoThe Reverse Godfather | This was a fun episode. We talk about Intel's SSD bug, Denali CTP3 is available, restoring backups over the network, and much much more. | Free | View In iTunes | |
| 137 | ExplicitVideoAllan! Allan! Allan! Allan! Allan! | Allan Hirt actually cam into our studio and played the base for us. And while he was here we thought we'd ask him a few clustering questions. | Free | View In iTunes | |
| 138 | ExplicitVideoInstalled Anally | Wow, what a good show this week. We talked about setting max server memory, how to get ready for cert exams, massive feature packs, and much more. | Free | View In iTunes | |
| 139 | ExplicitVideoDon Gill | Don is our special friend, but more importantly he's the head of the BOL team. This is such an interesting interview you'll just die. | Free | View In iTunes | |
| 140 | ExplicitVideoI would yank for Melissa | This week we're all about sa passwords, buying software you don't need, our new ringtones, and troubleshooting code errors. | Free | View In iTunes | |
| 141 | ExplicitVideoFalling Asleep on Tyra Banks | Tonight we talked about the magic tables, a cool clustering problem,orphaned windows accounts, cross join madness, and more. | Free | View In iTunes | |
| 142 | ExplicitVideoThe Peeping Jedi | This was a fun night. We talked about Yoda's naughty shower habits, did a lot of bitching about SAN guys, company loyalty, and much more. | Free | View In iTunes | |
| 143 | ExplicitVideoPimp-A-Thon | This week we talk about the Denali release date, Sean's big new shiny SQLSaturday session on interviewing, and much more. There's even a new resume review. | Free | View In iTunes | |
| 144 | ExplicitVideoThe Blanket Bonus | 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. | Free | View In iTunes | |
| 145 | ExplicitVideoItzik knows all | Jen got to visit with Itzik Ben Golly and get some answers to some coding questions, and I presented 2 awards. There was also a good discussion on deadlocks and much more. | Free | View In iTunes | |
| 146 | ExplicitVideoDatabase Performance | Paul and Kim Tripp from SQLSkills.com came to teach us their award-winning presentation on DB performance. | Free | View In iTunes | |
| 147 | ExplicitVideoGet Away from Me | Today we're talking about database hacks, getting rid of problems, Denny Cherry's new book, and more. | Free | View In iTunes | |
| 148 | ExplicitVideoUninstall 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. | Free | View In iTunes | |
| 149 | ExplicitVideoLeaking MVPee | 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. | Free | View In iTunes | |
| 150 | ExplicitVideoSimple Mode prevents STDs | Our botched commercial, the new Infragistics MVP, resume review and much more on this week's episode. | Free | View In iTunes | |
| 151 | ExplicitVideoI would yank for Melissa | This week we're all about sa passwords, buying software you don't need, our new ringtones, and troubleshooting code errors. | Free | View In iTunes | |
| 152 | ExplicitVideoSimple Mode prevents STDs | Our botched commercial, the new Infragistics MVP, resume review and much more on this week's episode. | Free | View In iTunes |
| Total: 152 Episodes |
Customer Reviews
Incredible resource! Great style...
These podcasts are GREAT! He has a tremendous selection of how to videos, solid content, and it's completely free. I like his speaking style...he's really casual and direct.
Top Notch
By far the best SQL Server Podcast on iTunes! Great tutorials and pertinent content, not a sales pitch or constant blabber about anything irrelevant.
I like @midnightdba
Great sense of humor + no marketing crap
Viewers also subscribed to

- SQL Server 2008 Application Compatibility Blog
- Scalability Experts
- View In iTunes

- TechNet SQL Server 2005 Event Content
- Alan Le Marquand
- View In iTunes



