Show 30 – Coffee and Water




SQL Server Radio show

Summary: <a href="http://traffic.libsyn.com/madeirasqlserverradio/SQLServerRadio_Show030.mp3" target="_blank">Download Episode (mp3)</a> Do you know what FOMO means? It means "Fear of Missing Out", and it's a term used in the startup and venture capital fields. However, it's also relevant for us as DBAs, and we start the show explaining why. Other than that, we talk about: * Why you should be careful when using SQL Server's Row Level Security * Duplicate indexes * The dangers of Indexed Views * An important thing you need to know about Filtered Indexes * Lots of ways to improve your productivity with Management Studio * Allow Snapshot Isolation and Read Committed Snapshot Items mentioned in the show: * <a href="https://gimletmedia.com/show/startup/" target="_blank">Startup podcast</a> * <a href="http://356labs.com/" target="_blank">356labs</a> * <a href="http://www.madeiradata.com/five-ways-to-improve-your-productivity-with-ssms/" target="_blank">Matan Yungman - 5 Ways to Improve Your Productivity with SSMS</a> * <a href="http://dba.stackexchange.com/questions/40738/allow-snapshot-isolation-and-read-committed-snapshot" target="_blank">Forum discussion: ALLOW_SNAPSHOT_ISOLATION and READ_COMMITTED_SNAPSHOT</a> * <a href="https://technet.microsoft.com/en-us/dn912438.aspx" target="_blank">MCM readiness videos</a>