Show 34 – Do You Have a Backup?

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)