Summary: <a href="http://traffic.libsyn.com/madeirasqlserverradio/SQLServerRadio_Show044.mp3" target="_blank">Download Episode (mp3)</a> Did you know SSMS can make sounds? We start the show with some interesting things you might do with this option. In addition, we talk about: * SQL Server on Linux * Hadoop fundamentals * SQL Server 2016 eBook * Changes to auto update statistics in SQL Server 2016 * New SQL Server 2016 database level configurations * Distributed Availability Groups - what is it and use cases * How AWS storage works * Composite indexes * Plan Cache issues Items mentioned in the show: * <a href="http://www.madeiradata.com/hadoop_fundamentals/" target="_blank">Guy Glantser - Hadoop Fundamentals</a> * <a href="http://www.dcac.co/how-to-make-ssms-beep-when-a-query-is-done" target="_blank">Denny Cherry - How to make SSMS beep when a query is done?</a> * <a href="https://blogs.msdn.microsoft.com/microsoft_press/2016/02/02/free-ebook-introducing-microsoft-sql-server-2016-mission-critical-applications-deeper-insights-hyperscale-cloud-preview-2/" target="_blank">Introducing Microsoft SQL Server 2016: Mission-Critical Applications, Deeper Insights, Hyperscale Cloud, Preview 2</a> * <a href="https://www.brentozar.com/archive/2016/03/changes-to-auto-update-stats-thresholds-in-sql-server-2016/" target="_blank">Erik Darling - Changes to auto update stats thresholds in SQL Server 2016</a> * <a href="https://www.brentozar.com/archive/2016/03/sql-server-2016-death-trace-flag/" target="_blank">Brent Ozar - SQL Server 2016: The Death of the Trace Flag</a> * <a href="https://msdn.microsoft.com/en-US/library/mt651673.aspx" target="_blank">Distributed Availability Groups</a>
