 Name |
Desc |
Length |
Date |
Series |
Author |
| | | | | |
| BCP out | Learn how to BCP data out of a table. | 17:04 | 04/11/2008 | | Sean McCown |
| BCP in | Learn how to BCP data into a table. | 5:15 | 04/14/2008 | | Sean McCown |
| BCP in errors | Learn how to diagnose BCP import problems. | 17:48 | 04/16/2008 | | Sean McCown |
| BCP 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. | 9:57 | 06/18/2008 | | Sean McCown |
| Basic Backup | Learn how to perform basic backups with SQL syntax. | 4:05 | 03/19/2008 | | Sean McCown |
| Remote Backups | Learn how to do a backup across the LAN. | 3:36 | 03/20/2008 | | Sean McCown |
| RESTORE with move | This one covers restore with move syntax to restore DBs while moving the files to a different location. | 12:07 | 03/20/2008 | | Sean McCown |
| Simple Backup Procedures | This is a tutorial not only on how to turn your backup commands into SPs, but also the basics of stored procedures are discussed. | 19:35 | 04/23/2009 | | Sean McCown |
| Backup 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:39 | 05/20/2008 | | Sean McCown |
| Windows Performance Monitoring: Part 1 | This is a nice video that discusses the basics of performance monitoring in windows. This is actually a live class that I taught to a group of developer/admins and just decided to record it. We got cut off there at the end for time, but the next version is coming soon. There’s a lot of stuff on perfmon counters, Task Manager, command line tools for monitoring and killing tasks, loading and unloading perfmon counters, etc. There’s lots of good stuff in here. | 1:17:05 | 05/20/2008 | Windows Performance Monitoring | Sean McCown |
| Windows Performance Monitoring: Part 2 | This is the continuation of the live presentation I did a couple weeks ago. This one covers disk counters, memory architecture, and counters. | 1:04:00 | 06/03/2008 | Windows Performance Monitoring | Sean McCown |
| Introduction to Schemas | This is an excellent video that explains what schemas are and why you should care. | 7:45 | 06/18/2008 | | Sean McCown |
| Schemas as Documentation | This is the 2nd video in the schema series. Here I give you a really good reason to adopt schemas in your architectures. Hope you enjoy. | 9:04 | 02/08/2009 | | Sean McCown |
| Schemas: Ownership Chaining and Schema Ownership | Continuing with schemas, here I talk about ownership chaining and how schema ownership effects them. I start with the basics of chaining and then get into the meat of the topic right after that. | 22:48 | 02/09/2009 | | Sean McCown |
| PowerShell Basics | Here I start the first in an exciting new series of vids on PowerShell both in Windows and SQL. I go over how to download PowerShell and some of the command basics. It’s just an intro so I’ll get into specific tasks in later vids. | 20:24 | 07/23/2008 | | Sean McCown |
| Scripting 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. | 21:44 | 07/24/2008 | | Sean McCown |
| Scripting 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. | 19:55 | 08/23/2008 | | Sean McCown |
| Working with PSDrive in PowerShell | Here I go over what PSDrive is and how to work with it. I also go into aliases again as well as how to find help in powershell. We’re still covering important basics here because I can write scripts for you all day long, but you’ll never go far unless you can understand them yourself. | 13:33 | 08/07/2008 | | Sean McCown |
| Powershell with –NoExit | Here I show you how to get around the problem of your Powershell window closing down when you call it from either the run window or from other programs. If you get errors or want to see something that was printed on the screen it’s quite often impossible unless you startup PowerShell or dos first. This way you can call your scripts in a way that allows you to see the results no matter what. It’s a very simple technique, but very useful. | 5:13 | 08/25/2008 | | Sean McCown |
| Change SQL Server Job Owner | This is a really cool method for changing SQL job owners or any job property I would imagine. It really simplifies it from using SQL syntax. So learn this method and it’ll be your friend for years to come. | 18:28 | 09/11/2008 | | Sean McCown |
| Grant DB Permissions | This is a beautiful bit of script that allows you to set DB permissions for a user. This is particularly useful for adding a user to multiple DBs on the server. And the code to accomplish this is much shorter than its T-SQL counterpart. If you need a bit more explanation about how this is put together then look at the video for granting schema permissions with Powershell. | 9:28 | 09/17/2008 | | Sean McCown |
| Grant Schema Permissions in Powershell | This is another excellent video that shows the power of powershell in SQL administration. I love this video because it’s a very common scenario and keeps you from writing a SQL cursor. This is one of my favorites. | 17:51 | 09/20/2008 | | Sean McCown |
| Building a Powershell BCP Routine | Here I show you how to build a script that will 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 will 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. | 31:21 | 09/30/2008 | | Sean McCown |
| Powershell 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. | 8:15 | 04/23/2009 | | Sean McCown |
| Beginning Powershell for DBAs 1 | This is an excellent video that explains what schemas are and why you should care. | 1:27:38 | 02/24/2009 | Beginning Powershell for DBAs | Sean McCown |
| Beginning Powershell for DBAs 2 | This is the 2nd video in the schema series. Here I give you a really good reason to adopt schemas in your architectures. Hope you enjoy. | 38:33 | 02/24/2009 | Beginning Powershell for DBAs | Sean McCown |
| Trace Flag 1807 | This one covers restore with move syntax to restore DBs while moving the files to a different location. | 8:28 | 05/02/2008 | | Sean McCown |
| When did SQL start? | Find out 2 ways to tell when SQL Server started. | 7:21 | 05/02/2008 | | Sean McCown |
| sp_HelpIndex Shortcut | There's a nifty keyboard shortcut to help you with things like sp_helpindex. It works with many SPs so have fun. | 6:18 | 05/02/2008 | | Sean McCown |
| Moving DB Files | Moving database files is easy, but misunderstood. Here I'll show you how to move user DB files using 2 methods. | 17:34 | 05/09/2008 | | Sean McCown |
| Interpreting 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’re looking 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. | 9:43 | 06/02/2008 | | Sean McCown |
| Running Websites with AD Accounts | This is an excellent tutorial on how to run a website under a specific AD account so you can use windows authentication in the database. This is a common request and now I’m showing you how to do it start to finish. | 12:59 | 06/02/2008 | | Sean McCown |
| Find Log Space Used | Find out how to query the log space usage for all DBs on the server with a single statement. This is a quick way to get the % of log space used and even program against the results. | 2:04 | 06/02/2008 | | Sean McCown |
| Using ServerProperty | Here I show you the benefit of using ServerProperty() instead of @@Version to find the version of SQL Server you’re on. | 8:32 | 08/07/2008 | | Sean McCown |
| RunAs 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. | 23:58 | 09/04/2008 | | Sean McCown |
| Select Into with Identity() | This video shows you how to use the Identity() function to create an identity column on the fly during a select into statement. You don’t have to settle for Alter Table anymore. | 5:27 | 04/23/2009 | | Sean McCown |
| Troubleshoot DB Connection with Telnet | Here I show you how to trouble a DB connection issue to eliminate the firewall as a suspect. Using telnet you can tell pretty clearly whether or not the access is being blocked by the firewall or not. One thing I didn’t mention in the video is that this works for all DBs and not just SQL Server. And again, you have to verify that the server is actively accepting connections. But this is a really good way to determine whether the firewall is blocking access or not. | 5:40 | 02/25/2009 | | Sean McCown |
| Building Subreports | I got a user question through email and rather write-out how to do this, I just shot him a quick video. So the quality isn't that good, and I used the camera this time, but hey, you either wanna know how to create a subreport or you don't. Hope you like it. | 14:24 | 02/03/2009 | | Sean McCown |
| SSIS Data Cleansing | Fix data errors with derived cols and conditional split transformations. | 33:58 | 04/19/2008 | | Sean McCown |
| SSIS text file errors | Dealing with SSIS txt file errors. You will learn how to properly redirect outputs to maximize your scrubbing efforts. | 7:47 | 04/19/2008 | | Sean McCown |
| SSIS Using Variables in Script Tasks | Here I talk about how to setup the script task to work with variables, and how to access them through code once the script can see them. | 7:11 | 05/21/2008 | | Sean McCown |
| SSIS Variable Scope | Learn how SSIS scopes variables. It’s not a complicated topic, but worth covering. | 4:36 | 05/21/2008 | | Sean McCown |
| MultiFlatFile Connection Manager | Here I talk about how to use the multiflatfile connection manager in SSIS to loop through flatfiles. | 6:12 | 05/20/2008 | | Sean McCown |
| Derived Columns | Here I show you how to work with derived columns in SSIS and use it to not only marry columns, but also troubleshoot data flows. This is a nice intro to this versatile transform. | 13:06 | 05/22/2008 | | Sean McCown |
| Connection strings in Package Config Files | Here I show you how to put your data source connection string inside a package configuration XML file. This was inspired by a forum post by a user so I decided to make a video for him. | 7:45 | 06/24/2008 | | Sean McCown |
| Forcing Package Failures | This one was by user request to show how you can compare the counts of 2 tables and use it to force the package to fail if the counts don’t match. This comes in handy when comparing the counts of the source and destination tables after your load. The scenario is specific but can be modified to anything you like. | 13:20 | 06/27/2008 | | Sean McCown |
| Execute SQL Task with Parameters | This video discusses how to pass parameters to queries and SPs inside the Execute SQL Task. It doesn’t teach the basics of the task. It assumes you already know how to use it. This video is only concerned with passing parameters. | 7:56 | 05/20/2008 | | Sean McCown |
| Row Count Transform | Here I discuss how to use the row count transform in SSIS and give you some good advice for naming and working with the variable associated with it. | 11:05 | 05/22/2008 | | Sean McCown |
| Introduction to ForEach Loops | Here I show you the basics of how to work with ForEach loops. Good stuff. | 11:07 | 06/23/2008 | | Sean McCown |
| Creating Files with ForEach Loop | Here I take the intro one step further and show you how to create multiple txt files based off of a looping variable in the ForEach loop container. This is a very common task and I see this question quite a bit in the forums, so I documented it. | 8:29 | 06/25/2008 | | Sean McCown |
| Introduction to Sequence Containers | This video takes a look at the basics of using the Sequence Container in SSIS. There’s not a lot to it, but it’s a good intro if you don’t know what it is. | 6:29 | 06/25/2008 | | Sean McCown |
| Commenting Tribal Knowledge in SSIS Packages | There is a lot of tribal knowledge that accumulates in any organization. Here I discuss some ways to document your SSIS packages so you can start to record some of this information. Your packages will be more supportable, easier to update, and you’ll take hours or sometimes days off of a re-design or support effort. You won’t be sorry you started doing this. | 29:24 | 09/21/2008 | | Sean McCown |
| SSIS Basics | This is a live presentation I gave recently. Here is a bare bones bottom of the barrel discussion on SSIS. This is for complete beginners. I’m explaining in this session, the simplest of basics on SSIS and BIDS. I give a couple of basics demos. This is the beginning of what I’ll build on in the next couple sessions as we get deeper into the specifics of this cool product. So if you know absolutely nothing about SSIS then this is the place for you. | 1:06:23 | 04/23/2009 | | Sean McCown |
| SSIS Basics 2: Flatfile Olympics | Here we’re just going to jump into SSIS and do some real practical work. We’re going to learn all about taking things to/from multiple files. This is not to be missed because there are some really good concepts here that will carry over to many other tasks in SSIS. I specifically chose these operations because they teach such a wide variety of skills. So come learn how to get a gold medal in flatfiles. | 1:02:15 | 11/04/2008 | | Sean McCown |
| Basic 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’re a DBA and you’ve always wanted to tackle HTML, don’t worry… it’s easier than it sounds. | 35:35 | 10/09/2008 | | Sean McCown |
| HTML 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. | 16:19 | 04/23/2009 | | Sean McCown |
| Red-Gate's Data Generator | A walkthrough of Red-Gate's new data generator tool. | 11:09 | 04/16/2008 | | Sean McCown |
| Write Good Dynamic SQL | Here I show you a couple methods for getting around really hard to read dynamic SQL. | 14:44 | 08/20/2008 | | Sean McCown |
| Commenting Tribal Knowledge in SPs | There is a lot of tribal knowledge that accumulates in any organization. Here I discuss some ways to document your SPs so you can start to record some of this information. Your SPs will be more supportable, easier to update, and you’ll take hours or sometimes days off of a re-design or support effort. You won’t be sorry you started doing this. | 27:03 | 09/21/2008 | | Sean McCown |
| Sending 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. | 39:42 | 09/23/2008 | | Sean McCown |
| Katmai Server Group Management | Learn how to use the new group server mgmt functionality in the Katmai SSMS. | 5:44 | 04/01/2008 | | Sean McCown |
| SSIS Scripting Languages | This covers how to change the scripting language in SSIS for Katmai. | 5:29 | 04/01/2008 | | Sean McCown |
| Katmai’s Search Feature | Here I explore Katmai’s new search feature. | 2:08 | 06/25/2008 | | Sean McCown |
| Cool 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. | 10:07 | 07/23/2008 | | Sean McCown |
| SSMS Fast Load | Here I show you how to get SSMS to get SSMS to load a lot faster so you don’t have to wait. | 5:19 | 09/08/2008 | | Sean McCown |
| Compression 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. | 12:23 | 09/10/2008 | | Sean McCown |
| Relational Division | Here we discuss relational division, the counterpart to relational multiplication (cross joins). We’ll hit a couple of examples, using subqueries to implement two different kinds of set division. | 19:41 | 04/09/2009 | | Jennifer McCown |
| Relational Multiplication | Here’s a quick talk on relational multiplication that gets us to take a closer look at what our joins are really doing. | 10:51 | 04/13/2009 | | Jennifer McCown |
| Beginning Powershell for DBAs 4 | Here I continue with the 4th class in the series at the NTSSUG user group. | 58:56 | 04/27/2009 | Beginning Powershell for DBAs | Sean McCown |
| Beginning Powershell for DBAs 3 | Here’s class 3 of 6 for the NTSSUG user group. | 44:06 | 04/27/2009 | Beginning Powershell for DBAs | Sean McCown |
| Uninstalling SP1 in SQL2K8 | SP1 is the first one that you can uninstall in SQL Server, so here I thought I’d take a look at the uninstall process and how well it works. | 3:37 | 04/28/2009 | | Sean McCown |
| Replace Text in File | Here I show you how to replace a given string in a file and either write it back to the same file, or write the entire thing to a new file keeping your original in tact. | 4:56 | 04/28/2009 | | Sean McCown |
| Backup File Extensions | Here I talk about how you can use the file extensions to your advantage, but also have a little fun with it too. | 6:28 | 08/10/2009 | | Sean McCown |
| Find DB Files with Powershell | Here I need to find the .MDF for a database so I can attach it, but I have no idea where the .MDF is. | 2:10 | 08/19/2009 | | Sean McCown |
| Pass Params to Scripts (Powershell) | Wanna know how to pass parameters to scripts, and when to use each method? | 7:46 | 08/10/2009 | | Sean McCown |
| Index Scripting Problems | This is just a fun vid. Again, we're sitting here late at night feeling a little punchy so we're a little goofier than usual. | | 08/21/2009 | | Sean McCown |
| Deploy 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. | 30:21 | 08/09/2009 | | Sean McCown and Jennifer McCown |
| Using TFS in SSMS | Here I show you how to set SSMS up to work with Team Foundation Server | | 08/20/2009 | | Sean McCown |
| Troubleshoot Missing DB File | Come with me on a quick trip to see how to troubleshoot a missing database file. | 3:16 | 08/09/2009 | | Sean McCown |
| Troubleshoot SSIS: "Script component cannot build user component" | | 2:57 | 08/10/2009 | | Sean McCown and Jennifer McCown |
| T-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. | 4:16 | 08/09/2009 | | Jennifer McCown |
| Grouping Sets | Here Jen and I go over grouping sets the only way we can. I hope you guys enjoy us late at night. | 17:32 | 08/20/2009 | | Sean McCown and Jennifer McCown |
| T-SQL: Over() and Partition By | Show how to use OVER and PARTITION BY to get groups of data with aggregation. | 4:16 | 08/19/2009 | | Jennifer McCown |
| Insert Non-duplicate Rows | Here we work our way through a coding scenario—inserting rows—that should illustrate the process of solving a problem from the simplest case to your intended result. | 11:53 | 09/03/2009 | | Jennifer McCown |
| Setup Server-Side Trace | server side traces, the benefits, and how to set up, edit, run, and stop a server side trace. | 13:45 | 09/03/2009 | | Jennifer McCown |
| Intro to ASP.NET | Intro to ASP.NET This is a decent intro to ASP.NET. Personally I don't think it's the best one you'll ever see, but it's ok. You'll see a pretty good intro to getting started writing pages in .NET and you'll get up and running on a couple easy data-driven pages. | 31:21 | 09/03/2009 | | Sean McCown |
| How to Study | We're very proud to bring you our first DBAs@Midnight video. Here we talk about how to study SQL books and be effective at learning what you want. We have a great deal of fun here and hopefully give you some good tips on how to stay on track with your studies. | 31:19 | 09/03/2009 | | Sean McCown and Jennifer McCown |
| Source Control in SSMS | Here I show you how to setup source control in SSMS and who should and shouldn't use it. | 14:26 | 09/03/2009 | | Sean McCown |
| BucksSearchVid | | | 04/23/2009 | | Sean McCown |
| Deadlocks Tutorial with Eric | | | 07/30/2009 | | Sean McCown |
| Dirty Tricks: Text Manipulation | Dirty tricks are the little tricks we use that aren't official, may not be "proper", but are insanely useful. Today we look at script building using MS Word. | 6:51 | 09/06/2009 | | Jennifer McCown |
| Dirty Tricks 2: Get List From Command Line | 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. | 6:41 | 09/07/2009 | | Jennifer McCown |
| 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? | 11:56 | 09/07/2009 | | Sean McCown |
| 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:23 | 09/07/2009 | | Jennifer McCown |
| TSQL: 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). | 10:01 | 09/07/2009 | | Sean McCown and Jennifer McCown |
| 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. | 11:44 | 09/07/2009 | | Jennifer McCown |
| 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. | 18:56 | 09/07/2009 | | Sean McCown and Jennifer McCown |
| Keeping 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. | 16:50 | 09/08/2009 | DBAsAtMidnightKeepSanityWhenOutOfWork | Sean McCown and Jennifer McCown |
| Keeping your Sanity when out of Work: Part 2 | We're continuing the discussion of keeping your sanity while out of work. | 15:13 | 09/08/2009 | DBAsAtMidnightKeepSanityWhenOutOfWork | Sean McCown and Jennifer McCown |
| Good Interview Still Don't Get the Job: Part 1 | Hey guys... here we kick off a discussion about some reasons why you may still not get the job even though you had an excellent interview. | 13:23 | 09/08/2009 | DBAsAtMidnightGoodInterviewStillDontGetTheJob | Sean McCown and Jennifer McCown |
| Good Interview Still Don't Get the Job: Part 2 | OK, we're just continuing our discussion of having an excellent interview. | 14:04 | 09/08/2009 | DBAsAtMidnightGoodInterviewStillDontGetTheJob | Sean McCown and Jennifer McCown |
| Build .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! | 14:04 | 09/08/2009 | | Sean McCown |
| Change 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. | 6:02 | 09/13/2009 | | Sean McCown |
| Get 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. | 3:37 | 09/13/2009 | | Sean McCown |
| Add 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. | 13:11 | 09/14/2009 | | Sean McCown |
| Fix 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 will help you come up with a solution even when you've never seen a specific error. | 4:56 | 09/14/2009 | | Sean McCown |
| 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. | 23:17 | 09/18/2009 | | Sean McCown and Jennifer McCown |
| 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. | 16:25 | 09/26/2009 | DBAsAtMidnightManagingTasks | Sean McCown and Jennifer McCown |
| Midnight: Managing Tasks 2 of 2 | Here's the exciting conclusion to the 1st one. | 23:29 | 09/26/2009 | DBAsAtMidnightManagingTasks | Sean McCown and Jennifer McCown |
| Working from Home: Part 1 | ALERT!!!! We had a lot of fun making this video but we covered some topics we're passionate about so in a couple patches the language gets a little rough. There's a normal amount of cursing but I do manage to slip up and drop an F-bomb once. So if you're offended easily then perhaps you should skip this one. I try not to do that, but sometimes it happens. Anyway, this one is a great time where we talk about the use of DBs in various customer service companies and how nobody uses them to their fullest. As well we also talk about office dress codes, hot chicks, and other stuff. Our daughter makes an appearance as well. So yeah, big fun. | 17:20 | 09/30/2009 | DBAsAtMidnightWorkingFromHome | Sean McCown and Jennifer McCown |
| Working from Home: Part 2 | Part 2 of "Working from Home" | 17:44 | 09/30/2009 | DBAsAtMidnightWorkingFromHome | Sean McCown and Jennifer McCown |
| Working from Home: Part 3 | Part 3 of "Working from Home" | 19:11 | 09/30/2009 | DBAsAtMidnightWorkingFromHome | Sean McCown and Jennifer McCown |
| PASS 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. | 15:23 | 11/09/2009 | DBAsAtMidnightItzik | Sean McCown and Jennifer McCown |
| PASS Summit 09 Interview: Itzik Ben-Gan, 2 of 2 | Part 2 of Itzik. | 20:23 | 11/09/2009 | DBAsAtMidnightItzik | Sean McCown and Jennifer McCown |
| Get 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. | 17:11 | 11/10/2009 | DBAsAtMidnightAllenWhite | Sean McCown and Jennifer McCown |
| Get Jiggy with Allen White: 2 of 2 | Finishing up with Allen White... good times. | 15:58 | 11/10/2009 | DBAsAtMidnightAllenWhite | Sean McCown and Jennifer McCown |
| Paul and Kim 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 still learn so much from them. So let's give it up for Kim and her man-servant Paul! | 19:29 | 11/11/2009 | DBAsAtMidnightTripps | Sean McCown and Jennifer McCown |
| Paul and Kim 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 still learn so much from them. So let's give it up for Kim and her man-servant Paul! | 17:20 | 11/11/2009 | DBAsAtMidnightTripps | Sean McCown and Jennifer McCown |
| The 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. | 16:39 | 11/15/2009 | DBAsAtMidnightBrianKnight | Sean McCown and Jennifer McCown |
| The Early Bird Gets Brian Knight: 2 of 2 | Brian's cute, and brilliant, and he's here for another round. | 19:34 | 11/15/2009 | DBAsAtMidnightBrianKnight | Sean McCown and Jennifer McCown |
| Bill 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. | 15:20 | 11/16/2009 | DBAsAtMidnightBillRamos | Sean McCown and Jennifer McCown |
| Bill Ramos Talks Tools: 2 of 2 | Part 2 with Bill Ramos. | 15:12 | 11/16/2009 | DBAsAtMidnightBillRamos | Sean McCown and Jennifer McCown |
| Grant is quite Fritchey: 1 of 3 | We found Grant wearing a dress so of course we had to put him in our sandwich. | 14:55 | 11/22/2009 | DBAsAtMidnightGrant | Sean McCown and Jennifer McCown |
| Grant is quite Fritchey: 2 of 3 | Here's the 2nd part of our talk with Grant. | 15:48 | 11/22/2009 | DBAsAtMidnightGrant | Sean McCown and Jennifer McCown |
| Grant is quite Fritchey: 3 of 3 | Here's the 3rd part of our talk with Grant. | 19:33 | 11/22/2009 | DBAsAtMidnightGrant | Sean McCown and Jennifer McCown |
| Buck, Paul, Joe, and Louis: 1 of 7 | RATED R for language content. Whenever you get Sean and Joe in the same room the language goes out the window. It's very entertaining though. There's a story behind this video. We had a scheduling mishap with Joe the day before, and when we were setting up for Paul he told us that Joe was in the speaker room with Louis. So he called and got them down there and we just turned it into a group interview. | 14:55 | 11/22/2009 | DBAsAtMidnightGroupInterview | Sean McCown and Jennifer McCown |
| Buck, Paul, Joe, and Louis: 2 of 7 | Here's part 2 of the big group interview. | 18:02 | 11/22/2009 | DBAsAtMidnightGroupInterview | Sean McCown and Jennifer McCown |
| Buck, Paul, Joe, and Louis: 3 of 7 | Here's part 3 of the big group interview. | 18:24 | 11/22/2009 | DBAsAtMidnightGroupInterview | Sean McCown and Jennifer McCown |
| Buck, Paul, Joe, and Louis: 4 of 7 | Here's part 4 of the big group interview. | 15:00 | 11/22/2009 | DBAsAtMidnightGroupInterview | Sean McCown and Jennifer McCown |
| Buck, Paul, Joe, and Louis: 5 of 7 | Here's part 5 of the big group interview. | 13:26 | 11/22/2009 | DBAsAtMidnightGroupInterview | Sean McCown and Jennifer McCown |
| Buck, Paul, Joe, and Louis: 6 of 7 | Here's part 6 of the big group interview. | 16:36 | 11/22/2009 | DBAsAtMidnightGroupInterview | Sean McCown and Jennifer McCown |
| Buck, Paul, Joe, and Louis: 7 of 7 | Here's part 7 of the big group interview. | 15:32 | 11/22/2009 | DBAsAtMidnightGroupInterview | Sean McCown and Jennifer McCown |
| OR is bad, IF is good | Here I tell you about a common mistake - using OR instead of IF – and show you that IF is better. | 3:34 | 12/01/2009 | | Jennifer McCown |
| Optimize Query by Intervals | In this vid, I walk you through tuning a query full of date manipulation (which is performance death). I show you how to free the functions, free the optimizer, and happify your code...plus we talk a little date math. See the accompanying blog at http://midnightdba.itbookworm.com/midnightdba/blog/post/Optimized-Query-by-Hour2c-Day2c-Week2c-or-Month.aspx | 14:35 | 12/01/2009 | | Jennifer McCown |
| Designing Efficient Functions | Here I get on my cert soapbox again. I was going through a practice cert exam and came across an answer to a question that could use a major improvement. I made the improvement and here I show you what and why. | 11:40 | 12/28/2009 | | Sean McCown |
| Certs, Tshooting, and Backups | This is our first filming since PASS and it's a little late at night. We still manage to talk about cert exams, troubleshooting, and why companies don't take backups. See the full show notes and links here. | 30:22 | 12/29/2009 | | Sean McCown and Jennifer McCown |
| Clustering 101 | SPEAKER: Kaylan Yella. We were fortunate enough to get someone of his skill to teach us about clustering. The basics take a lot of time so we didn't get to any demos during the usergroup session, but Kal was nice enough to film the demos on his own afterwards and they're posted right after this one. So start here and learn the basics, then go to the other vids and learn how to put it all together. Thanks Kal. | 1:29:30 | 11/19/2009 | NTSSUGClustering101 | Sean McCown |
| Check if File Exists | Inspired by a user question I decided to make a quick vid on how to use a script task to check that a file exists. No frills in this one, just a quick walkthrough of the code. | 3:04 | 01/10/2010 | | Sean McCown |
| Correlate Lock Timeouts with Statements | I’ve been getting lock timeouts on one of my systems, so I captured the timeouts in a profiler trace. Here, we walk through developing a query to correlate the lock timeouts to the code holding those locks. | 8:24 | 01/10/2010 | | Jennifer McCown |
| Ground Zero SSIS: Class 1 | This is the 1st class I'm teaching at the NTSSUG for ground zero SSIS. I hope to have 6 in all, but it may get stretched out further. | 1:01:53 | 01/21/2010 | SSISGroundZero | Sean McCown |
| Clustering: Part 2 | Here we have the 2nd class by Kal. This time he was cool enough to take time out of his busy schedule and record this and the next one at home for us. This is demo-rich and he shows you how to actually install SQL on a cluster. | 1:27:19 | 11/19/2009 | NTSSUGClustering101 | Kalyan Yella |
| Clustering: Part 3 | Here we have the 3rd class by Kal. This time he was cool enough to take time out of his busy schedule and record this at home. We really appreciate all of this extra work he's put into our group. | 32:32 | 11/19/2009 | NTSSUGClustering101 | Kalyan Yella |
| Companies 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. | 31:35 | 01/28/2010 | | Sean McCown and Jennifer McCown |
| Clean Package Design | This is a nice little primer on designing clean packages that are easier to support. Get rid of the sea of arrows that afflict your processes. | 16:37 | 01/27/2010 | | Sean McCown |
| HTML: Table Basics | Continuing with basic HTML, I talk about table basics here. I'm not kidding; this is basic. So if you already know anything about HTML tables at all, then you're more advanced than then lesson. This is strictly for those who are at level 0. | 7:39 | 01/26/2010 | | Sean McCown |
| Resumes: 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. | 15:00 | 02/01/2010 | DBAsAtMidnightResumes | Sean McCown and Jennifer McCown |
| Resumes: 2 of 3 | Part 2 of Resumes. | 15:00 | 02/01/2010 | DBAsAtMidnightResumes | Sean McCown and Jennifer McCown |
| Resumes: 3 of 3 | Part 3 of Resumes. | 13:08 | 02/01/2010 | DBAsAtMidnightResumes | Sean McCown and Jennifer McCown |
| Beginning Execution Plans | Here's a level zero introduction to tuning queries. I go over execution plans, sp_help, and clustered primary key indexes. | 11:03 | 02/03/2010 | | Jennifer McCown |
| Breaking 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. In part 1:
- Worst secret handshake EVAR
- When Good IPs go Bad: Sean rants
- Another rant
| 15:01 | 02/05/2010 | DBAsAtMidnightBreakUpWithBoss | Sean McCown and Jennifer McCown |
| Breaking 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?
| 15:18 | 02/05/2010 | DBAsAtMidnightBreakUpWithBoss | Sean McCown and Jennifer McCown |
| Breaking 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
| 15:15 | 02/05/2010 | DBAsAtMidnightBreakUpWithBoss | Sean McCown and Jennifer McCown |
| Breaking 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
| 22:01 | 02/05/2010 | DBAsAtMidnightBreakUpWithBoss | Sean McCown and Jennifer McCown |
| Stuff Auction: 1 of 3 | This is another fun one for us. Frankly, I really had a good time doing this one. We start with a quick recap of our week (MVP summit, vacation, Jen's new job). The main topic in part 1 is sharking someone's stuff. We cover the best ways to scope out the soon-to-be-available stuff. And there are some things that it's NEVER okay to do. | 15:00 | 02/21/2010 | DBAsAtMidnightStuffAuction | Sean McCown and Jennifer McCown |
| Stuff Auction: 2 of 3 | Part 2 of Stuff Auction. Things to focus on at a new job. Jen's answer, Sean's answer... | 20:00 | 02/21/2010 | DBAsAtMidnightStuffAuction | Sean McCown and Jennifer McCown |
| Stuff Auction: 3 of 3 | Part 3 of Stuff Auction. Priorities and important questions on the first day of your job, a quick recap, we wander for a bit after 15:00, and then Sean actually [redacted] [redacted] Denali [redacted] Dan Jones. | 15:15 | 02/21/2010 | DBAsAtMidnightStuffAuction | Sean McCown and Jennifer McCown |
| Start Agent Jobs in Powershell | Starting SQL Agent jobs in powershell is easy, but there's a trick to it that's not obvious. Here I'll show you how to start jobs both locally and remotely. | 11:25 | 02/23/2010 | PowershellStartJobs | Sean McCown |
| Start Agent Jobs in Powershell: Part 2 | Starting SQL Agent jobs in powershell part 2. | 22:34 | 02/24/2010 | PowershellStartJobs | Sean McCown |
| T-SQL: The Almost Question | We need a query to get rows that fulfill *almost all* of a set of requirements. How do we work that out? Watch this video, and I'll tell you. Related blog: http://midnightdba.itbookworm.com/midnightdba/blog/ Download the code: http://midnightdba.itbookworm.com/midnightdba/PublicDownload/Almost.txt | 14:58 | 03/02/2010 | | Jennifer McCown |
| Evangelizing SQL Part: 1 of 3 | This is a fun vid where we talk about evangelizing SQL in your company, getting devs to take part in code reviews, and much more. Good times. | 15:01 | 03/09/2010 | DBAsAtMidnightEvangelizeSQL | Sean McCown and Jennifer McCown |
| Evangelizing SQL Part: 2 of 3 | Part 2 of Evangelizing SQL | 20:06 | 03/09/2010 | DBAsAtMidnightEvangelizeSQL | Sean McCown and Jennifer McCown |
| Evangelizing SQL Part: 3 of 3 | Part 3 of Evangelizing SQL | 17:27 | 03/09/2010 | DBAsAtMidnightEvangelizeSQL | Sean McCown and Jennifer McCown |
| Ground Zero SSIS: Class 2 | In this 2nd class we discuss how to decide whether you should architect your table loads in single or multiple packages. We also start on file loads. | 59:10 | 03/18/2010 | SSISGroundZero | Sean McCown |
| Data Mining 101 | SPEAKER: Andrew Minkin. Drew stopped by to teach all of us mortals about data mining. There's so much more to cover in this topic so maybe we'll be able to talk him into coming back. | 50:30 | 03/18/2010 | | Andrew Minkin |
| How to Spin a Firing: 1 of 3 | This was kind of a fun vid for me even though I was really tired and I think it shows. Here we talk about how to spin it in an interview when you've been fired for cause from your last gig. | 15:01 | 03/28/2010 | DBAsAtMidnightSpinningAFiring | Sean McCown and Jennifer McCown |
| How to Spin a Firing: 2 of 3 | Part 2 of How to Spin a Firing. | 15:01 | 03/28/2010 | DBAsAtMidnightSpinningAFiring | Sean McCown and Jennifer McCown |
| How to Spin a Firing: 3 of 3 | Part 3 of How to Spin a Firing. | 16:49 | 03/28/2010 | DBAsAtMidnightSpinningAFiring | Sean McCown and Jennifer McCown |
| Manage 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. | 13:51 | 04/04/2010 | | Sean McCown |
| No 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. | 15:00 | 04/04/2010 | DBAsAtMidnightNoReligionAtWork | Sean McCown and Jennifer McCown |
| No Religion at Work: 2 of 4 | Part 2 of No Religion at Work. | 15:00 | 04/04/2010 | DBAsAtMidnightNoReligionAtWork | Sean McCown and Jennifer McCown |
| No Religion at Work: 3 of 4 | Part 3 of No Religion at Work. | 15:00 | 04/04/2010 | DBAsAtMidnightNoReligionAtWork | Sean McCown and Jennifer McCown |
| No Religion at Work: 4 of 4 | Part 4 of No Religion at Work. | 10:37 | 04/04/2010 | DBAsAtMidnightNoReligionAtWork | Sean McCown and Jennifer McCown |
| Plagiarism: 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. | 15:00 | 04/07/2010 | DBAsAtMidnightPlagiarism | Sean McCown and Jennifer McCown |
| Plagiarism: 2 of 4 | Part 2 of Plagiarism. | 15:05 | 04/07/2010 | DBAsAtMidnightPlagiarism | Sean McCown and Jennifer McCown |
| Plagiarism: 3 of 4 | Part 3 of Plagiarism. | 15:05 | 04/07/2010 | DBAsAtMidnightPlagiarism | Sean McCown and Jennifer McCown |
| Plagiarism: 4 of 4 | Part 4 of Plagiarism. | 07:41 | 04/07/2010 | DBAsAtMidnightPlagiarism | Sean McCown and Jennifer McCown |
| Adopting 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. | 15:01 | 04/18/2010 | DBAsAtMidnightAdoptNewFeatures | Sean McCown and Jennifer McCown |
| Adopting New Features: 2 of 4 | Part 2 of Adopting New Features. | 15:06 | 04/18/2010 | DBAsAtMidnightAdoptNewFeatures | Sean McCown and Jennifer McCown |
| Adopting New Features: 3 of 4 | Part 3 of Adopting New Features. | 15:06 | 04/18/2010 | DBAsAtMidnightAdoptNewFeatures | Sean McCown and Jennifer McCown |
| Adopting New Features: 4 of 4 | Part 4 of Adopting New Features. | 10:14 | 04/18/2010 | DBAsAtMidnightAdoptNewFeatures | Sean McCown and Jennifer McCown |
| Ground Zero SSIS: Class 3 | Here in another live presentation to NTSSUG we discuss where to hold your query inside your packages, as well as get into flatfile error handling. | 1:10:24 | 04/15/2010 | SSISGroundZero | Sean McCown |
| T-SQL Code Sins | SPEAKER: Jen McCown. Do you know how to set yourself for good coding practices? Well Jen does. Come see the advice she gives on how to set yourself up for success. | 50:53 | 04/15/2010 | | Jennifer McCown |
| Firing 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. | 15:02 | 04/25/2010 | DBAsAtMidnightFiringDBAs | Jennifer McCown |
| Firing DBAs: Part 2 | Part 2 of Firing DBAs. | 15:04 | 04/25/2010 | DBAsAtMidnightFiringDBAs | Jennifer McCown |
| Firing DBAs: Part 3 | Part 3 of Firing DBAs. | 15:04 | 04/25/2010 | DBAsAtMidnightFiringDBAs | Jennifer McCown |
| Firing DBAs: Part 4 | Part 4 of Firing DBAs. | 15:04 | 04/25/2010 | DBAsAtMidnightFiringDBAs | Jennifer McCown |
| Beginning 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. | 59:20 | 04/24/2010 | | Jennifer McCown |
| T-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. | 50:49 | 04/24/2010 | | Jennifer McCown |
| When 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. | 15:00 | 05/01/2010 | DBAsAtMidnightWhenToLeaveJob | Sean McCown and Jennifer McCown |
| When to Leave your Job: 2 of 5 | Part 2 of When to Leave your Job. | 15:03 | 05/01/2010 | DBAsAtMidnightWhenToLeaveJob | Sean McCown and Jennifer McCown |
| When to Leave your Job: 3 of 5 | Part 3 of When to Leave your Job. | 15:08 | 05/01/2010 | DBAsAtMidnightWhenToLeaveJob | Sean McCown and Jennifer McCown |
| When to Leave your Job: 4 of 5 | Part 4 of When to Leave your Job. | 15:06 | 05/01/2010 | DBAsAtMidnightWhenToLeaveJob | Sean McCown and Jennifer McCown |
| When to Leave your Job: 5 of 5 | Part 5 of When to Leave your Job. | 12:45 | 05/01/2010 | DBAsAtMidnightWhenToLeaveJob | Sean McCown and Jennifer McCown |
| Recompiling and Parameter sniffing: 1 of 5 | We talk about so many things here it's hard to nail it all down in a summary. Let's see though, we talk about companies blocking social sites like twitter, using persisted tables as temp tables, recompiling and parameter sniffing, and much more. | 15:00 | 05/10/2010 | DBAsAtMidnightRecompilingAndParameterSniffing | Sean McCown and Jennifer McCown |
| Recompiling and Parameter sniffing: 2 of 5 | Part 2 of Recompiling and Parameter sniffing. | 15:05 | 05/10/2010 | DBAsAtMidnightRecompilingAndParameterSniffing | Sean McCown and Jennifer McCown |
| Recompiling and Parameter sniffing: 3 of 5 | Part 3 of Recompiling and Parameter sniffing. | 15:05 | 05/10/2010 | DBAsAtMidnightRecompilingAndParameterSniffing | Sean McCown and Jennifer McCown |
| Recompiling and Parameter sniffing: 4 of 5 | Part 4 of Recompiling and Parameter sniffing. | 15:05 | 05/10/2010 | DBAsAtMidnightRecompilingAndParameterSniffing | Sean McCown and Jennifer McCown |
| Recompiling and Parameter sniffing: 5 of 5 | Part 5 of Recompiling and Parameter sniffing. | 18:03 | 05/10/2010 | DBAsAtMidnightRecompilingAndParameterSniffing | Sean McCown and Jennifer McCown |
| User Processes: 1 of 2 | We're both SO PISSED 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. | 16:00 | 05/17/2010 | DBAsAtMidnightUserProcesses | Sean McCown and Jennifer McCown |
| User Processes: 2 of 2 | Part 2 of User Processes. | 20:19 | 05/17/2010 | DBAsAtMidnightUserProcesses | Sean McCown and Jennifer McCown |
| Bobble-Head Buck: 1 of 5 | This is kind of a fun video. We talk about Buck's bobble head along with DNS and DR, and the joy of logon triggers. | 14:59 | 05/24/2010 | DBAsAtMidnightBobbleHeadBuck | Sean McCown and Jennifer McCown |
| Bobble-Head Buck: 2 of 5 | Part 2 of Bobble-Head Buck. | 15:06 | 05/24/2010 | DBAsAtMidnightBobbleHeadBuck | Sean McCown and Jennifer McCown |
| Bobble-Head Buck: 4 of 5 | Part 4 of Bobble-Head Buck. | 15:10 | 05/24/2010 | DBAsAtMidnightBobbleHeadBuck | Sean McCown and Jennifer McCown |
| Bobble-Head Buck: 5 of 5 | Part 5 of Bobble-Head Buck. | 9:50 | 05/24/2010 | DBAsAtMidnightBobbleHeadBuck | Sean McCown and Jennifer McCown |
| Bobble-Head Buck: 3 of 5 | Part 3 of Bobble-Head Buck. | 9:50 | 05/24/2010 | DBAsAtMidnightBobbleHeadBuck | Sean McCown and Jennifer McCown |
| SQLSaturday 35: 1 of 3 | Come see our first LIVE taping ever. We have a good time, give away some great prizes and even manage to get a little techie. | 15:00 | 05/31/2010 | DBAsAtMidnightSQLSaturday35 | Sean McCown and Jennifer McCown |
| SQLSaturday 35: 2 of 3 | Part 2 of SQLSaturday 35. | 15:07 | 05/31/2010 | DBAsAtMidnightSQLSaturday35 | Sean McCown and Jennifer McCown |
| SQLSaturday 35: 3 of 3 | Part 3 of SQLSaturday 35. | 11:13 | 05/31/2010 | DBAsAtMidnightSQLSaturday35 | Sean McCown and Jennifer McCown |
| Get Table Stats with Powershell | Let's get stats for every table in the DB and put them in a file so we can send them to a customer or view them ourselves. It's also easy enough to put in a table to query. | 18:17 | 06/02/2010 | | Sean McCown |
| Buck's Taint: 1 of 5 | We start out this episode with a great discussion on taints. Does it actually ite into IT? You'll have to come and find out. We also announce the new Petri IT Knowledgebase SQL site and discuss server-side traces. There's much more too. | 15:00 | 06/07/2010 | DBAsAtMidnightBucksTaint | Sean McCown and Jennifer McCown |
| Buck's Taint: 2 of 5 | Part 2 of Buck's Taint. | 15:00 | 06/07/2010 | DBAsAtMidnightBucksTaint | Sean McCown and Jennifer McCown |
| Buck's Taint: 3 of 5 | Part 3 of Buck's Taint. | 15:05 | 06/07/2010 | DBAsAtMidnightBucksTaint | Sean McCown and Jennifer McCown |
| Buck's Taint: 4 of 5 | Part 4 of Buck's Taint. | 15:07 | 06/07/2010 | DBAsAtMidnightBucksTaint | Sean McCown and Jennifer McCown |
| Buck's Taint: 5 of 5 | Part 5 of Buck's Taint. | 9:29 | 06/07/2010 | DBAsAtMidnightBucksTaint | Sean McCown and Jennifer McCown |
| The Latin DB: 1 of 5 | We start this episode with the special guest we've been talking about. Then we talk about the Latin DB, and all kinds of things. | 14:59 | 06/14/2010 | | Sean McCown and Jennifer McCown |
| The Latin DB: 2 of 5 | Part 2 of The Latin DB. | 14:59 | 06/14/2010 | | Sean McCown and Jennifer McCown |
| The Latin DB: 3 of 5 | Part 3 of The Latin DB. | 14:59 | 06/14/2010 | | Sean McCown and Jennifer McCown |
| The Latin DB: 4 of 5 | Part 4 of The Latin DB. | 15:00 | 06/14/2010 | | Sean McCown and Jennifer McCown |
| The Latin DB: 5 of 5 | Part 5 of The Latin DB. | 16:21 | 06/14/2010 | | Sean McCown and Jennifer McCown |
| DBAsAtMidnightLive | Placeholder for the live feed so we can get suggested vids on the page. | 18:03 | 06/18/2010 | | Sean McCown and Jennifer McCown |
| UFOs: 1 of 4 | You'll get our abridged review of TechED 2010, enterprises that insist on buying expensive apps, and of course our discussion of UFOs. This is only the beginning because there are plenty more topics this week. | 16:21 | 06/21/2010 | | Sean McCown and Jennifer McCown |
| UFOs: 2 of 4 | Part 2 of UFOs. | 15:05 | 06/21/2010 | | Sean McCown and Jennifer McCown |
| UFOs: 3 of 4 | Part 3 of UFOs. | 15:05 | 06/21/2010 | | Sean McCown and Jennifer McCown |
| UFOs: 4 of 4 | Part 4 of UFOs. | 11:22 | 06/21/2010 | | Sean McCown and Jennifer McCown |
| Fire the Samurai: 1 of 4 | This week we talk about the death of Database Underground, Jen stealing at work, and much more. | 00:17:03 | 06/28/2010 | DBAsAtMidnightFireTheSamurai | Sean McCown and Jennifer McCown |
| Fire the Samurai: 2 of 4 | Part 2 of Fire the Samurai. | 00:17:03 | 06/28/2010 | DBAsAtMidnightFireTheSamurai | Sean McCown and Jennifer McCown |
| Fire the Samurai: 3 of 4 | Part 3 of Fire the Samurai. | 00:17:03 | 06/28/2010 | DBAsAtMidnightFireTheSamurai | Sean McCown and Jennifer McCown |
| Fire the Samurai: 4 of 4 | Part 4 of Fire the Samurai. | 00:17:03 | 06/28/2010 | DBAsAtMidnightFireTheSamurai | Sean McCown and Jennifer McCown |
| Sean's Rub-n-Tug: 1 of 5 | We talk about a few things here, one of which is parameter sniffing. I know we've covered this before, but it keeps coming up somehow. | 00:17:03 | 07/05/2010 | DBAsAtMidnightSeansRubNTub | Sean McCown and Jennifer McCown |
| Sean's Rub-n-Tug: 2 of 5 | Part 2 of Sean's Rub-n-Tug | 00:17:03 | 07/05/2010 | DBAsAtMidnightSeansRubNTub | Sean McCown and Jennifer McCown |
| Sean's Rub-n-Tug: 3 of 5 | Part 3 of Sean's Rub-n-Tug | 00:17:03 | 07/05/2010 | DBAsAtMidnightSeansRubNTub | Sean McCown and Jennifer McCown |
| Sean's Rub-n-Tug: 4 of 5 | Part 4 of Sean's Rub-n-Tug | 00:17:03 | 07/05/2010 | DBAsAtMidnightSeansRubNTub | Sean McCown and Jennifer McCown |
| Sean's Rub-n-Tug: 5 of 5 | Part 5 of Sean's Rub-n-Tug | 00:17:03 | 07/05/2010 | DBAsAtMidnightSeansRubNTub | Sean McCown and Jennifer McCown |
| Sean is Petri's Dish: 1 of 4 | Here we talk about an extremely bad cluster install done by one of my DBAs. | 00:15:00 | 07/12/2010 | | Sean McCown and Jennifer McCown |
| Sean is Petri's Dish: 2 of 4 | Part 2 of Sean is Petri's Dish. | 00:15:05 | 07/12/2010 | | Sean McCown and Jennifer McCown |
| Sean is Petri's Dish: 3 of 4 | Part 3 of Sean is Petri's Dish. | 00:15:05 | 07/12/2010 | | Sean McCown and Jennifer McCown |
| Sean is Petri's Dish: 4 of 4 | Part 4 of Sean is Petri's Dish. | 00:19:55 | 07/12/2010 | | Sean McCown and Jennifer McCown |
| Loading Files without SSIS | Loading Files without SSIS. | 00:17:03 | 05/22/2010 | | Paul Hunter |
| Developing Dynamic SSIS | Dynamic SSIS. | 00:17:03 | 05/22/2010 | | Devin Knight |
| Intro to SSIS | Intro to SSIS. | 00:17:03 | 05/22/2010 | | Tim Mitchell |
| Monitoring SAN Space | Monitoring SAN Space. | 00:17:03 | 05/22/2010 | | Sri Sridharan |
| Season 1 Finale | The finale of our 1st season. Some good discussion here. | 00:17:03 | 09/07/2010 | | Sean McCown and Jennifer McCown |
| Aristocratic 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. | 00:17:03 | 09/13/2010 | | Sean McCown and Jennifer McCown |
| Quick, 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. | 1:14:23 | 09/20/2010 | | Sean McCown and Jennifer McCown |
| Audit 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. | 00:17:03 | 09/29/2010 | | Sean McCown |
| Monitor 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. | 34:37 | 09/30/2010 | | Sean McCown |
| Sean'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. | 1:05:37 | 09/27/2010 | | Sean McCown and Jennifer McCown |
| Polishing 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. | 1:10:22 | 10/04/2010 | | Sean McCown and Jennifer McCown |
| The 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. | 1:10:46 | 10/11/2010 | | Sean McCown and Jennifer McCown |
| Hot Tubbin With Bob | What a fun episode this was. We talked about sexual harrassment and many other things. Come have a few laughs and maybe even learn some SQL along the way. | 1:10:22 | 10/18/2010 | | Sean McCown and Jennifer McCown |
| Olympic Cornholing | This week we talk about sex week on MidnightDBA as well as big production problems, crappy vendors, and more. | 1:00:57 | 10/25/2010 | | Sean McCown and Jennifer McCown |
| What 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. | 54:54 | 11/01/2010 | | Sean McCown and Jennifer McCown |
| Your Face or Mine? | I suppose this is officially our Halloween episode. Come along as we discuss whatever it is we talked about here. | 1:05:29 | 11/08/2010 | | Sean McCown and Jennifer McCown |
| No Management DBs | I suppose this is officially our Halloween episode. Come along as we discuss whatever it is we talked about here. | 1:14:43 | 11/15/2010 | | Sean McCown and Jennifer McCown |
| Steve 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. | 1:08:00 | 11/17/2010 | | Sean McCown and Jennifer McCown |
| The 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. | 48:10 | 11/17/2010 | | Sean McCown and Jennifer McCown |
| Denny '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. | 28:31 | 11/17/2010 | | Sean McCown and Jennifer McCown |
| Grant 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. | 55:18 | 11/17/2010 | | Sean McCown and Jennifer McCown |
| Merkin 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. | 1:04:58 | 11/22/2010 | | Sean McCown and Jennifer McCown |
| Bathrobe Bonanza | This is our post-Thanksgiving episode. Today we talk about why Bing sucks, jr. DBAs, and the cloud. | 51:04 | 11/29/2010 | | Sean McCown and Jennifer McCown |
| Sexual Harassment | This week we have Eric Humphrey in the studio and while we get different grooves on, the main topic is sexual harassment. | 1:13:16 | 11/29/2010 | | Sean McCown and Jennifer McCown |
| Adam 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. | 47:45 | 12/13/2010 | | Sean McCown and Jennifer McCown |
| Stallin 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. | 1:08:10 | 12/20/2010 | | Sean McCown and Jennifer McCown |
| 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. | 14:15 | 12/29/2010 | | Sean McCown |
| Smell 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:08:10 | 12/27/2010 | | Sean McCown and Jennifer McCown |
| Useless 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:03:02 | 01/03/2011 | | Sean McCown and Jennifer McCown |
| 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. | 08:54 | 01/04/2011 | | Sean McCown |
| Hack-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: Hack-attack a damaged DB | 15:37 | 01/05/2011 | | Sean McCown |
| Sledgehammer 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:03:02 | 01/10/2011 | | Sean McCown and Jennifer McCown |
| Hottub 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. | 57:27 | 01/17/2011 | | Sean McCown and Jennifer McCown |
| Waits and Queues | Thomas LaRock from Confio came to give us this really good talk on waits and queues. And as an added bonus, the entire PASS board was here to listen. OK, we forgot to start the recorder but you only miss like 15mins of the presentation. The good news is all the demos are there. | 33:27 | 01/20/2011 | | Thomas LaRock |
| 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. | 57:31 | 01/20/2011 | NTSSUGClustering101 | Sean McCown |
| Now with temp tables | This week Sean tells a fun story about being sarcastic at work. We also go into the topic of DR plans and talk about making assumptions, and lots more. | 1:07:11 | 01/17/2011 | | Sean McCown and Jennifer McCown |
| Sean gets 69 | Tonight we talk about a big downtime at Pilgrim's Pride, 24-HOP sessions, a yearly downtime report, ownership chains, cross joins, and much more. | 1:02:27 | 01/31/2011 | | Sean McCown and Jennifer McCown |
| You 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. | 1:02:27 | 02/07/2011 | | Sean McCown and Jennifer McCown |
| Slapping the dog | We've got an excellent show tonight. We have an excellent discussion on an update statement gone horribly wrong and how to prevent it. We also reveal the GoDaddy corporate structure as well as their spending priorities. And we do a nice skit on the support tech who can't seem to hang up the phone. | 1:09:53 | 02/14/2011 | | Sean McCown and Jennifer McCown |
| Find query timeouts in Profiler | I like this video. This is a simple example of how you can track down queries that are timing out. Be careful though. If your trace table is too large it can take a long time to pull back the results. You can also add other elements to this to increase the accuracy. Perhaps I'll put together a sequel sometime. | 8:26 | 02/15/2011 | | Sean McCown |
| They 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! | 1:05:56 | 02/21/2011 | | Sean McCown and Jennifer McCown |
| I 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. | 1:02:11 | 03/07/2011 | | Sean McCown and Jennifer McCown |
| Simple Mode prevents STDs | Our botched commercial, the new Infragistics MVP, resume review and much more on this week's episode. | 1:05:31 | 02/28/2011 | | Sean McCown and Jennifer McCown |
| Database Performance | Paul and Kim Tripp from SQLSkills.com came to teach us their award-winning presentation on DB performance. | 1:46:57 | 03/17/2011 | | Paul and Kim Tripp |
| Falling Asleep on Tyra Banks | Tonight we talked about the magic tables, a cool clustering problem,orphaned windows accounts, cross join madness, and more. | 56:56 | 03/28/2011 | | Sean McCown and Jennifer McCown |
| Don 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. | 1:43:13 | 03/28/2011 | | Sean McCown and Jennifer McCown |
| The 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. | 1:05:46 | 03/14/2011 | | Sean McCown and Jennifer McCown |
| Get Away from Me | Today we're talking about database hacks, getting rid of problems, Denny Cherry's new book, and more. | 1:01:04 | 03/21/2011 | | Sean McCown and Jennifer McCown |
| 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. | 4:14 | 03/28/2011 | | Sean McCown |
| Leaking 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. | 55:37 | 03/04/2011 | | Sean McCown and Jennifer McCown |
| Pimp-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. | 1:02:53 | 04/04/2011 | | Sean McCown and Jennifer McCown |
| The 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. | 1:04:47 | 04/11/2011 | | Sean McCown and Jennifer McCown |
| Itzik 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. | 1:00:52 | 04/18/2011 | | Sean McCown and Jennifer McCown |
| Installed 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. | 1:00:52 | 04/25/2011 | | Sean McCown and Jennifer McCown |
| Allan! 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. | 59:44 | 05/02/2011 | | Sean McCown and Jennifer McCown |
| Cherry Cheesecake | This week we cover Sean's mainframe story, twitter updates, Alan Hirt's new whitepaper, and Itzik is here again. | 1:12:17 | 05/09/2011 | | Sean McCown and Jennifer McCown |
| Rapture 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. | 58:09 | 05/20/2011 | | Sean McCown and Jennifer McCown |
| LOL Cats | This was a fun week because we talked about xlocks on tempdb, nested views, and new SQL languages. | 1:07:39 | 05/27/2011 | | Sean McCown and Jennifer McCown |
| Season 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. | 1:08:54 | 06/03/2011 | | Sean McCown and Jennifer McCown |
| Windows 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. | 6:41 | 07/08/2011 | | Sean McCown |
| Insert 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. | 13:01 | 07/14/2011 | | Sean McCown |
| Create and Edit a Simple SSRS Report | Here we create, populate and format a simple SSRS report. This is a companion to my Petri article How to Create and Edit a Report in SQL Server Reporting Services | 12:51 | 07/14/2011 | | Jennifer McCown |
| Format 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: Change Multiple Field Formats in SSRS | 3:34 | 07/15/2011 | | Jennifer McCown |
| Optimize 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. | 12:21 | 07/22/2011 | | Sean McCown |
| Server 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. | 11:19 | 07/28/2011 | | Sean McCown |
| UNION 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. | 5:23 | 07/29/2011 | | Jennifer McCown |
| The 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. | 1:07:59 | 07/15/2011 | | Sean McCown and Jennifer McCown |
| DBCC 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. | 1:01:15 | 07/22/2011 | | Sean McCown and Jennifer McCown |
| P.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. | 57:21 | 08/01/2011 | | Sean McCown and Jennifer McCown |
| Season 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. | 1:02:34 | 07/09/2011 | | Sean McCown and Jennifer McCown |
| Find 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. | 3:26 | 08/02/2011 | | Sean McCown |
| Change Users Password | Users don't need special permissions to change their own passwords, but there is a minor trick to it. Here I'll show you 3 ways that ordinary users can changed their own passwords without any elevated privileges. | 4:02 | 08/29/2011 | | Sean McCown |
| Best Backup Class Evar: 2 of 6 | The 2nd in the backup class at NTSSUG. | 11:19 | 02/25/2011 | NTSSUGClustering101 | Sean McCown |
| Best Backup Class Evar: 3 of 6 | The 3rd in the backup class at NTSSUG. | 23:03 | 03/17/2011 | NTSSUGClustering101 | Sean McCown |
| Best Backup Class Evar: 4 of 6 | The 4th in the backup class at NTSSUG. | 30:20 | 05/19/2011 | NTSSUGClustering101 | Sean McCown |
| Best Backup Class Evar: 5 of 6 | The 5th in the backup class at NTSSUG. | 1:09:02 | 06/16/2011 | NTSSUGClustering101 | Sean McCown |
| Best Backup Class Evar: 6 of 6 | The 6th in the backup class at NTSSUG. | 45:48 | 06/16/2011 | NTSSUGClustering101 | Sean McCown |
| Troubleshoot Default Schema | Here I troubleshoot why a user's default schema isn't being honored. | 2:38 | 08/11/2011 | | Sean McCown |
| Slightly Used Interview | Leave it to us to bring you all the big scoops. We kick things off with a great story of a training company trying to sue conference speakers, and then bring you a big announcement from one of the great SQL authors of our time on his new HA book. And before you ask, yes there's more. We unveil a new award and have a great interview. This show isn't to be missed. | 1:03:48 | 10/21/2011 | | Sean McCown and Jennifer McCown |
| It's Being Mailed | This was such a fun week. We talked about a ridiculous sa password breech, answered a great question from viewer email, a silly query problem, and much more. We had a good time. | 1:02:56 | 12/02/2011 | | Sean McCown and Jennifer McCown |
| STOP!!! | This is a special election episode. We have 2 guests campaigning tonight. We have one trying to go up into space, and on trying to get on the PASS board. And we also talk about critical stop madness and an excellent discussion on resumes. | 56:59 | 12/09/2011 | | Sean McCown and Jennifer McCown |
| Bring in the Nerds | A fabulous show this week. We have Denny Cherry, and we use him to talk about the new SOPA bill debates going on in congress right now. We're also big fans of his security book. Come join the fun, but remember, when Denny's in the house language goes out the window. | 1:0048 | 12/16/2011 | | Sean McCown and Jennifer McCown |
| Xmas Special | This is a xmas blowout like no other. We have our Itzik tree and we do an elf interview as well as some very naughty gifts to exchange. This is probably one of our more vulgar episodes, so be prepared for some bad language. It's all good clean fun though so come have a xmas ball with us. | 1:00:49 | 12/23/2011 | | Sean McCown and Jennifer McCown |
| Campfire Stories | Welcome to our Halloween episode. We start off with some scary stories and then get into a number of great topics. We talk about a new MCM, we trade rants, and finally we ask the question: How long do you deal with not getting a decent raise? | 1:01:27 | 10/28/2011 | | Sean McCown and Jennifer McCown |
| Sexy Hat Night | Tonight we talk about the best way to make sure you get training, cross-pollination in IT, and SLAs. There's more that shouldn't be missed so don't miss a word of our cutting wit. | 1:00:27 | 11/04/2011 | | Sean McCown and Jennifer McCown |
| Stop Looking at Me | This was a fun episode where we talk about IT guys spooning for questions, connection troubleshooting with telnet, and how much we hate SQL Workshops. | 58:24 | 11/11/2011 | | Sean McCown and Jennifer McCown |
| We LOVE Mark | PASS Special: We make sure we talk to Mark Souza every year at PASS. If you don't know who Mark is, he's in charge of several groups at MS including SQL MVP and SQLCAT. He even founded both of those programs. So yeah, he's not only a big deal, but he worships us and does whatever we say. | 41:53 | 10/13/2011 | | Sean McCown and Jennifer McCown |
| Itzik Rules | PASS Special: What can I say... every time we talk to Itzik, he shows us why he's one of the best. He's so composed, and such an experienced teacher, that we both just sit there in awe. Itzik really is the man and we got him for you again. | 38:42 | 10/13/2011 | | Sean McCown and Jennifer McCown |
| DBAs of Our Lives | It's New Year's Eve and we're having some fun. We've got a big puppet show, a good rant, and a couple awards. | 57:22 | 12/30/2011 | | Sean McCown and Jennifer McCown |
| Querying Dev Metadata | Sometimes you need to get info on objects you've created. Here you can see how you can query for this info, and even learn a cool trick for greatly simplifying the process. | 6:33 | 12/31/2011 | | Jennifer McCown |
| SOPA Sucks | We have a wonderful show this week. Jen actually has a rant, we talk about SOPA and how bad it sucks, and we recount a nice yelling match. There's also lots more including .Net guys, and a great discussion on 5-9's. | 1:08:06 | 11/18/2011 | | Sean McCown and Jennifer McCown |
| Best Habit for Coders | There's a step you can make in your code to improve it many times over. It's an easy step to take, but it can make all the difference. You shouldn't overlook this step so come learn how to make all your code tons better. | 5:02 | 01/01/2012 | | Jennifer McCown |
| Forced Reboot | This week brings a fabulous interview skit, a nice rant, and a discussion on MVP awards. We also talk about another bad vendor call and much more. This is our first show of the year so we're kicking it off strong. | 1:06:19 | 01/06/2012 | | Sean McCown and Jennifer McCown |
| Jen's Milkshake | Tonight we have all kinds of good stuff. We start by paying off a lost bet, and then we talk about snapshots, form emails, and a guy who was told to stop teaching his co-workers and just do his job. | 1:04:00 | 01/13/2012 | | Sean McCown and Jennifer McCown |
| Sean's Pretty Hands | Tonight we have a very big announcement and we catch poor Itzik by surprise with it. We also have a quick ceremony and afterwards we discuss cluster disks, and we have a big discussion about sa rights and the people allowed to have them. | 52:26 | 01/27/2012 | | Sean McCown and Jennifer McCown |
| Goodbye Chef | This week we say goodbye to one of our favorite characters. We also have a great demo on data-driven subscriptions in SSRS and talk about security and lots of other stuff. Another great show in the can. | 1:06:10 | 02/03/2012 | | Sean McCown and Jennifer McCown |
| Data-driven Subscriptions in SSRS | Here I get into an elegant method for giving users a report that has a dynamic distribution list. As DBAs we don't want to be in the business of managing DLs, so here we're going to use a data-driven subscription to put DL management back in the users' hands. | 26:58 | 02/06/2012 | | Sean McCown |
| Deploying SSRS Reports | One of the most common questions I get is how to deploy reports in SSRS. Here I show you pretty much everything you need to know to put your reports on the server. | 4:26 | 02/06/2012 | | Sean McCown |
| Change Agent Job Properties in Powershell | You may have occasion to change the job step properties on multiple agent jobs and here I show you how. The possibilities are almost endless here and I explore a few of them with you. You can see the full script in the accompanying blog post: http://www.midnightdba.com/DBARant/?p=791 | 18:21 | 02/09/2012 | | Sean McCown |
| Yet here we are | We've got a fabulous debacle with ShrinkDB as well as a nice powershell to add users to a bunch of servers. There's a lot more too. | 1:00:29 | 02/10/2012 | | Sean McCown and Jennifer McCown |
| Dealing with Sql_variant in SSIS | Every now and then you come across something you don't want to deal with that you're forced to handle in your SSIS packages. Here I'll discuss techniques for handling the Sql_variant data type in your packages so your data loads properly. | 7:41 | 02/14/2012 | | Sean McCown |
| NCC-1701-DBA: 1 of 6 | This is the first of a series to teach you how to think like and become an enterprise DBA. The skills and the mindset are different when you're managing hundreds of servers. | 1::04:08 | 01/19/2012 | | Sean McCown |
| Fake Projects for Steve | We're back and on the tail of Sean's plague. This week we've got some fabulous stuff. Jen does a demo of FileTable in Denali, and Sean has a couple nice rants. We talk about a vendor who wants Sean to just shut up and do what he's told, and a great skit about disk space. We're feeling good this week so come join in the fun. | 1:08:24 | 03/16/2012 | | Sean McCown and Jennifer McCown |
| MVP Summit 2012 | Well, we're here at the MVP Summit in Seattle. We stole a conference room at the hotel in the middle of the night to bring this show to you. | 1:03:57 | 03/02/2012 | | Sean McCown and Jennifer McCown |
| Largest SQL Server Installs | Kaylan Yella brings us another excellent session, this time on the largest SQL installs. If you've ever wanted to have some ammo for those people in your office who blame the bad DB performance on some sort of SQL Server threshold instead of their bad coding, then here it is. Kal shows us what the best in the world are doing with SQL Server and trust me, your install is nowhere close to reaching a threshold. | 1:20:51 | 03/16/2012 | | Paul and Kim Tripp |
| Cycle Error Log on all Servers using Powershell | Here I show you how to use the Carrier Method for using powershell to cycle all your error logs. This is an excellent way to get started using powershell, and I use it even though I know it fairly well. | 18:11 | 05/14/2012 | | Sean McCown |
| Read SQL Server Error Logs in Powershell | Would you like to work with the SQL Server error logs in Powershell? Well here I'm gonna show you how. Not only do we pull in the current log, but I also show you how to get all of the historical logs for all the instances on the server as well. Good stuff. | 18:09 | 05/15/2012 | | Sean McCown |
| Change SQL Server Permissions in Powershell: Part 1 | Here I show you how to change permissions in SQL Server using Powershell. There are 2 methods I discuss and I even show you some of the problems you can run into. This is the 1st in a series so be sure to watch the 2nd one too. In This video I also reference a couple other vids. Those are here:
Scripting DB Objects in Powershell (Advanced Topics)
Cycle Error Log on all Servers using Powershell | 24:42 | 05/17/2012 | ChangeSQLPermsInPS | Sean McCown |
| Change SQL Server Permissions in Powershell: Part 2 | Continuing from the 1st video, here I show you how to capture useful errors from the method call. I explain how to Trap the errors and loop through InnerException to make sure you get all of them. If you saw the last vid, you can't miss this one. | 10:47 | 05/17/2012 | ChangeSQLPermsInPS | Sean McCown |
| Change Schema in Powershell | Changing object schemas is easy enough in T-SQL when it's a single object, but it get considerably more complicated when you've got several objects to change, or even several thousand. This is where Powershell comes in. Here I show you how to very easily change the schema of as many objects as you like in just a few seconds. And I throw in some regex in there for good measure. Let's have some fun. | 8:26 | 05/18/2012 | | Sean McCown |
