Download Episode (mp3)

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:

* Identifying SQL Server 2014 New Cardinality Estimator issues and Service Pack 1 improvement

* Robert Sheldon - Microsoft Azure Stream Analytics

* Rob Sewell - Setting Up and Using Azure VM SQL Automated Backup (and Restore)