Don't Stop Me Now
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