Show 34 – Do You Have a Backup?




SQL Server Radio show

Summary: <a href="http://traffic.libsyn.com/madeirasqlserverradio/SQLServerRadio_Show034.mp3" target="_blank">Download Episode (mp3)</a> In this (rather old) episode, we talk about: * Analyzing real time data with Azure Event Hub and Stream Analytics * What is Agile * Text manipulation in SQL Server * Reading deleted data out of SQL Server * Identifying problems with the new SQL Server 2014 Cardinality Estimator * What is Trace Flag 4199 * Lock Escalation * And more.. Items mentioned in the show: * <a href="http://blogs.msdn.com/b/psssql/archive/2015/06/16/identifying-sql-server-2014-new-cardinality-estimator-issues-and-service-pack-1-improvement.aspx" target="_blank">Identifying SQL Server 2014 New Cardinality Estimator issues and Service Pack 1 improvement</a> * <a href="https://www.simple-talk.com/cloud/cloud-data/microsoft-azure-stream-analytics/?utm_source=simpletalk&amp;utm_medium=pubemail&amp;utm_content=streamanalytics-20150622&amp;utm_campaign=cloud&amp;utm_term=simpletalkmain" target="_blank">Robert Sheldon - Microsoft Azure Stream Analytics</a> * <a href="http://sqldbawithabeard.com/2015/07/24/setting-up-and-using-azure-vm-sql-automated-backup-and-restore/" target="_blank">Rob Sewell - Setting Up and Using Azure VM SQL Automated Backup (and Restore)</a>