Show 25 – Oh, I’m on the Prod Server




SQL Server Radio show

Summary: <a href="http://traffic.libsyn.com/madeirasqlserverradio/SQLServerRadio_Show025.mp3" target="_blank">Download Episode (mp3)</a> Two weeks have passed, and another show is here! We start by talking about scary DBA sentences We continue with PASS Summit 2015 and about the sessions we'll deliver at the summit. We then talk about: * T-SQL code patterns * interesting scenarios with small but very active SQL Server tables * jobs that will be replaced by machines * Tempdb Contention and improvements in SQL Server 2016 * The power of SQL for other data solutions like Couchbase and Azure Stream Analytics * And more.. Items mentioned in the show: * <a href="http://www.brentozar.com/archive/2015/05/contest-write-scariest-dba-sentence-10-words-less/" target="_blank">Kendra Little - Contest: Write the Scariest DBA Sentence</a> * <a href="http://www.sqlpass.org/summit/2015/Home.aspx" target="_blank">PASS Summit 2015</a> * <a href="https://www.youtube.com/watch?list=PLoGAcXKPcRvYPypKMZhVM4Vs4Yt1hUoZV&amp;v=YPakjmZpsiA" target="_blank">Matan Yungman - The Data Loading Performance Presentation (from 24 Hours of PASS)</a> * <a href="http://www.sqlservercentral.com/blogs/dwainsql/2015/05/27/high-performance-t-sql-using-code-patterns/" target="_blank">Dwain Camps - High Performance T-SQL using Code Patterns</a> * <a href="http://www.madeiradata.com/can-a-sql-server-table-be-too-small/" target="_blank">Matan Yungman - Can a SQL Server Table be Too Small?</a> * <a href="http://www.npr.org/sections/money/2015/05/21/408234543/will-your-job-be-done-by-a-machine" target="_blank">Will Your Job Be Done By a Machine?</a> * <a href="http://blogs.technet.com/b/machinelearning/archive/2015/06/01/the-azure-stream-analytics-query-language.aspx?utm_content=buffer4a298&amp;utm_medium=social&amp;utm_source=twitter.com&amp;utm_campaign=buffer" target="_blank">The Azure Stream Analytics Query Language</a> * <a href="http://blog.couchbase.com/introducing-n1ql-sql-gene-in-nosql" target="_blank">Couchbase N1QL</a>