Shows
SQL Server RadioShow 28 – Backups, Scripting and Regular Expressions with Sean McCownA few months ago we hosted Sean McCown for a talk about indexing tips and backup performance. On this show, we have Sean again. Sean reveals tons of backup tips and tricks while talking about his new free product, Minion Backup. Among other topics, we talk about: What are VLF's and why it's not good to have many of them When you SHOULD use shrink Why Sean doesn't like Policy Based Management How to monitor backup progress Regular Expressions in SSMS And as always with our guests, we play Scattergories, and Sean...
2015-08-221h 00SQL Server RadioShow 18 – Sean McCownOn show 18, we host Sean McCown, a.k.a Midnight DBA. We start the show with some tips about working from home without hurting your productivity. We then take a deep dive into two of Sean's favorite topics: Reindexing and backup performance. Sean shares quite a few tips regarding the two topics, and takes us into the bits and bytes of his new free maintenance solution, Minion Reindex. About Sean: Sean McCown is a Microsoft Certified Master in SQL Server 2008. He is also a SQL Server MVP with over 20 yea...
2015-03-1949 min
PowerScripting PodcastEpisode 218 - PowerScripting Podcast - PowerShell jokes and SQL talk with the MidnightDBAsSean and Jen McCown, the MidnightDBA duo!
2013-03-061h 11
PowerScripting PodcastEpisode 218 - PowerScripting Podcast - PowerShell jokes and SQL talk with the MidnightDBAsSean and Jen McCown, the MidnightDBA duo!
2013-03-0600 min
Midnight DBAChange Agent Job Properties in PowershellYou 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
2012-02-0918 min
MidnightDBA BlogcastMidnightDBA Blogcast 2.03.03 - DRILLS! Integer DatatypesThis is Sean's third ever MidnightDBA Drill - download and drill yourself on integer datatypes like never before!
2011-01-0500 minMidnightDBA BlogcastMidnightDBA Blogcast 2.03.04 - DRILLS! Trace FlagsThis is Sean's fourth ever MidnightDBA Drill - download and drill yourself on trace flags like never before!
2011-01-0500 minMidnightDBA BlogcastMidnightDBA Blogcast 2.03.02 - DRILLS! System Database IDsThis is Sean's second ever MidnightDBA Drill - download and drill yourself on System Database IDs like never before!
2011-01-0500 minMidnightDBA BlogcastMidnightDBA Blogcast 2.03.01 - DRILLS! Login Error StateThis is Sean's first ever MidnightDBA Drill - download and drill yourself on login error states like never before!
2011-01-0500 min2010-12-0500 min2010-11-2800 minMidnight DBAOlympic CornholingThis week we talk about sex week on MidnightDBA as well as big production problems, crappy vendors, and more.
2010-10-251h 00MidnightDBA BlogcastMidnightDBA Blogcast 020 - Powershell to alter Database File PropertiesToday I read Sean's March 31st blog on Powershell. Check out the blog post for the Powershell script: http://www.midnightdba.com/DBARant/?p=3
2010-07-1100 minMidnightDBA BlogcastMidnightDBA Blogcast 019 - The Catch-up Clip ShowIt's been a long while since I made a blogcast, so we hit the highlights of my recent blogs.
2010-07-0900 minMidnightDBA BlogcastMidnightDBA Blogcast 018 - SQL Saturday 35 Recap with Sean, and a blog with Evil JenSean and I have a quick talk on SQLSat35, and I read a blog by Evil Jen.
2010-06-0200 minMidnightDBA BlogcastMidnightDBA Blogcast 017 - Guest Blog by Brad McGehee, Common Dev/DBA MistakesBlog reading and upcoming events. Brad McGehee was kind enough to say yes when I asked to read this funny and useful blog, so I finally make good! Link to the Question of the Month: http://tinyurl.com/yad66l Link to this blog: http://tinyurl.com/y6eqy8n
2010-05-1400 minMidnightDBA BlogcastMidnightDBA Blogcast 016 - DBAs at Midnight!I read Sean's blog on his "SSIS architecture: Tips for package design" PDF, and also the finalists from the MidnightDBA SQL Server Musical Contest.
2010-04-1100 minMidnightDBA BlogcastMidnightDBA Blogcast 015 - DBAs at Midnight!Sean and I talk user groups and SQL Saturday sessions.
2010-03-2400 minMidnightDBA BlogcastMidnightDBA Blogcast 014 - SQLPerspectives Guest BlogI read my intro blog and my SQLPerspectives blog (http://sqlperspectives.wordpress.com), reviewing a chapter of MVP Deep Dives.
2010-03-2400 minMidnightDBA BlogcastMidnightDBA Blogcast 013 - Brief Intro to Indexes and INCLUDEToday we read a December 09 blog, Brief Intro to Indexes and INCLUDE
2010-03-0700 minMidnightDBA BlogcastMidnightDBA Blogcast 011 - Code Sins: Coding LonelyHere's the latest Code Sin: Coding Lonely.
2010-02-2800 minMidnightDBA BlogcastMidnightDBA Blogcast 012 - 3 RantsI read three blogs from Sean's DBARant.Blogspot.com
2010-02-2800 minMidnightDBA BlogcastMidnightDBA Blogcast 009 - Sleepless in the Server Room (or, I Love You, I QUIT!)I start my new job tomorrow, so let's read Sleepless in the Server Room (or, I Love You, I QUIT!).
2010-02-2100 minMidnightDBA BlogcastMidnightDBA Blogcast 010 - Just call it an internal DoS attackHere's the latest from Sean's Database Underground blog on Infoworld.com, "Just call it an internal DoS attack". (http://infoworld.com/d/data-management/just-call-it-internal-dos-attack-834)
2010-02-2100 minMidnightDBA BlogcastMidnightDBA Blogcast 007 - Experts are Sharp, and Best DR PlanHere are two of Sean's DBA Rants (see http://DBARant.Blogspot.com), Experts are Sharp, and The Best DR Plan in Existence.
2010-01-3100 minMidnightDBA BlogcastMidnightDBA Blogcast 008 - SQLPass: What I Learned at Summer CampI'm feeling nostalgic for the good ole days of November 2009, so here's my 11/6/09 hit "SQL Pass Summit Postgame - What I learned at summer camp".
2010-01-3100 minMidnightDBA BlogcastMidnightDBA Blogcast 006 - FlatlineToday I read a short blog from Sean titled "Flatline", prefaced by a couple of notes on the January NTSSUG meeting, and SQL Saturday Dallas.
2010-01-2400 minMidnightDBA BlogcastMidnightDBA Blogcast 005 - SSIS Rename Package, and Being SomebodyToday we make some announcements, and read three quick blogs from the girly MidnightDBA (just to clarify, that's Jen) about the SSIS package rename dialog box, and "When do you become 'Somebody'?"
2010-01-1700 minMidnightDBA BlogcastMidnightDBA Blogcast 004 - ORMs: Panacea or Polio Braces?In our first guest-blogged blogcast, I read excerpts from Jeremiah Peschka's latest greatest work. His blog can be found at http://www.facility9.com Thanks @peschkaj!
2010-01-1100 minMidnightDBA BlogcastMidnightDBA Blogcast 003 - The Server-Side TraceToday we read my SQLServerPedia article, "The Server-Side Trace: What, Why, and How". Check out http://www.SQLServerPedia.com, especially the blogroll!
2010-01-1000 minMidnightDBA BlogcastMidnightDBA Blogcast 002 - The Database ReligionJen reads Sean's DBARant blog from August 2005, titled "The Database Religion". This is gonna be good, I can tell.
2010-01-0400 minMidnightDBA BlogcastMidnightDBA Blogcast 001 - Rebuilding IndexesIn our premiere blogcast, Jen reads her first tech blog entry from August 2009: "Case Study: Rebuilding Indexes".
2010-01-0300 min