SQL Server Radio

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:

Direct download: SQLServerRadio_Show056.mp3
Category:general -- posted at: 3:20am EST

Today in the show, we:

  • Check whether Set Nocount On is still needed
  • Extract data easily
  • Deep dive into Always Encrypter
  • Unmask Dynamic Data Masking
  • Check why we don't get emails about deadlocks
  • Check why a monitoring software couldn't monitor

Items mentioned in the show:

As always, if you have any questions, comments or interesting stories, drop us a line and we'll talk about them.

Direct download: SQLServerRadio_Show055.mp3
Category:general -- posted at: 4:04am EST

1