Opening the iTunes Store.If iTunes doesn't open, click the iTunes application icon in your Dock or on your Windows desktop.Progress Indicator

iTunes

iTunes is the world's easiest way to organize and add to your digital media collection.

We are unable to find iTunes on your computer. To download and subscribe to Midnight DBA by Sean McCown, get iTunes now.

Already have iTunes? Click I Have iTunes to open it now.

iTunes for Mac + PC

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

Customer Reviews

Incredible resource! Great style...

by JPInvictus

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 dbist

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

by Nitin Salgar

Great sense of humor + no marketing crap

Viewers also subscribed to

SQLServerPedia SQL Server Training (Apple iTunes Video)

SQLServerPedia SQL Server Training (MP3 Audio Only)

SQLServerPedia SQL Server Training (MP3 Audio Only)
Brent Ozar
View In iTunes

SQL Server 2008 Application Compatibility Blog

SQL Server 2008 Application Compatibility Blog
Scalability Experts
View In iTunes

View In iTunes

Free
Category: Software How-To
Language: English

Customer Ratings

7 Ratings