Download Episode (mp3)

In a few days delay, show 56 is here, and this time we talk about:

* Itzik Ben-Gan's ways for unpivoting data

* Auditing every change in every table

* The Dunning-Krugher Effect and how it's related to new technologies

* Use Cases for XML and JSON

* Some differences between SQL Server and MongoDB

* Transactional consistency between different databases in an Availability Group

* Agent Profiles in SQL Server replication

* The best "feel good" song in history

Items mentioned in the show:

* Itzik Ben-Gan - Unpivoting Data

* Noa Brodezky - How to Audit Changes for Every Table in SQL Server

* Matan's 24 Hours of PASS session - MongoDB for the SQL Server Professional

* Guy's 24 Hours of PASS session - From XML to JSON