Show 28 – Backups, Scripting and Regular Expressions with Sean McCown




SQL Server Radio show

Summary: <a href="http://traffic.libsyn.com/madeirasqlserverradio/SQLServerRadio_Show028.mp3" target="_blank">Download Episode (mp3)</a>   A few months ago we hosted Sean McCown for a <a href="http://www.sqlserverradio.com/sean-mccown/" target="_blank">talk about indexing tips and backup performance</a>. On this show, we have Sean again. Sean reveals tons of backup tips and tricks while talking about his new free product, <a href="http://minionware.net/backup/" target="_blank">Minion Backup</a>. 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 tells a VERY interesting story about cluster configuration. Items mentioned in the show: * <a href="http://minionware.net/backup/" target="_blank">Minion Backup</a> * <a href="http://www.sqlpass.org/summit/2015/Sessions/Details.aspx?sid=8461" target="_blank">Sean's PASS Summit session - Monster Text Manipulation: Regular Expressions for the DBA</a> * <a href="http://www.sqlpass.org/summit/2015/Sessions/Details.aspx?sid=8669" target="_blank">Sean's PASS Summit precon - The Enterprise Scripting Workshop</a>   About Sean: Sean McCown is a Microsoft Certified Master in SQL Server 2008. He is also a SQL Server MVP with over 20 years experience in databases. Sean is also founder and co-owner of the renowned website MidnightDBA.com where he records free SQL Server training videos and co-hosts the popular webshow, DBAs@Midnight. <a href="http://www.sqlserverradio.com/wp-content/uploads/2015/03/SeanHead.png"></a>