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 Scatte...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...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 11PowerScripting PodcastEpisode 218 - PowerScripting Podcast - PowerShell jokes and SQL talk with the MidnightDBAsSean and Jen McCown, the MidnightDBA duo!2013-03-061h 11
Midnight DBAChange SQL Server Permissions in Powershell: Part 1Here 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:<br><a href = "http://midnightdba.itbookworm.com/VidPages/PowershellScriptDBObjects/PowershellScriptDBObjects.aspx">Scripting DB Objects in Powershell (Advanced Topics)</a><br> <a href = "http://midnightdba.itbookworm.com/VidPages/PowershellCycleErrorLog/PowershellCycleErrorLog.aspx">...2012-05-1724 minMidnight 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: <a href="http://www.midnightdba.com/DBARant/?p=791">http://www.midnightdba.com/DBARant/?p=791</a>2012-02-0918 minMidnight DBAFormat Multiple SSRS Table FieldsOne 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: <a href = "http://www.midnightdba.com/Jen/2010/08/tip-change-multiple-field-formats-in-ssrs">Change Multiple Field Formats in SSRS</a>2011-07-1503 minMidnight DBABest Backup Class Evar: 1 of 6Here'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 <a href="http://MidnightDBA.ITBookworm.com/EventScripts/BackupClass1.zip">can be found here</a>.2011-01-2057 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 minMidnightDBA BlogcastMidnightDBA Blogcast 2.02 - RTFM3652010-12-0500 minMidnightDBA BlogcastMidnightDBA Blogcast 2.01 - What's new in Denali2010-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=32010-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/y6eqy8n2010-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 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 015 - DBAs at Midnight!Sean and I talk user groups and SQL Saturday sessions.2010-03-2400 minMidnightDBA BlogcastMidnightDBA Blogcast 013 - Brief Intro to Indexes and INCLUDEToday we read a December 09 blog, Brief Intro to Indexes and INCLUDE2010-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.com2010-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