Preview Mode Links will not work in preview mode

Sep 20, 2016

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...


Sep 1, 2016

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: