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

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:

• Paul Randal's Waits and Latches Library
• SQL Table Zip
• Phil Factor - Unmasking the Dynamic Data Masking
• Gianluca Sartori - Unmasking the Dynamic Data Masking (easier)

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

Itzik Ben-Gan has many T-SQL tricks.

In this show, we talk about a few of them:

• How to get Batch Mode Processing with regular tables
• How to share Identity between different tables
• How to use Cross Apply for Unpivot

In addition, we talk about what SOS_Scheduler_Yield means and answer the question - is it always the DBA's fault?

If you would like your question to be featured on the show, just head over to SQLServerRadio.com, drop us a line, and we'll talk about it in one of the upcoming shows.

Items mentioned in the show:

• Itzik Ben-Gan - What You Need to Know About Batch Mode Window Aggregate Operator in SQL Server 2016

Guy is back from a one month trip in the United States, and we're back with another show of SQL Server Radio.

In this show, we talk about a few of our upcoming speaking gigs (PASS Summit and SQL Server Days in Belgium), about File-Snapshot backups in SQL Server 2016, about triggers in DB2, SQL Server 2016 CU1, about where to spend your thinking time, and more.

Tomaž Kaštrun (blog | twitter) about what Data Science is, what does a Data Scientist do, what insights is he looking for, what tools does he use, what is R, and what R integration in SQL Server 2016 means.

Tomaž Kaštrun is BI developer and Analyst with more than 15 years of experience working with MS SQL Server and and 15 years of experiences on statistics and predictive analytics. He is a frequent SQL Server community speaker, blogger, delivering sessions on local user group meetings, PASS or Microsoft related events (PASS, 24HOP, SQLSaturday) and publishing articles related to SQL Server. He is working for Spar ICS GmbH / Spar Slovenija d.o.o. and is vivid coffee drinker.

What's new in SQL Server 2016?

In this show, we celebrate the official release of SQL Server 2016 and talk about the new features of the version.

We can't really believe it, but it's the 50th show of SQL Server Radio! Time does fly when having fun!

To celebrate the 50th show, we have a countdown of the top 50 SQL Server features of all time..with a small twist..