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