Watermelon Shake

Download Episode (mp3)


In this show, we host our good friend and great DBA, Shy Engelberg.

Together with Shy, we talk about:

  • Guy’s new online course – Advanced Query Tuning in SQL Server
  • How to write queries for dynamic search screens
  • Use cases for MongoDB and Machine Learning
  • What is the adaptive query plan feature
  • How Shazam works, and how it’s related to the show
  • Thoughts on HA and DR
  • Thoughts on SQL Server licensing
  • Thoughts on bringing Azure features to the ground
  • And more..

What can you learn in Guy’s course?

  • What is the Plan Cache and why is it needed
  • How to find your problematic queries
  • How to read and analyze execution plans
  • How to measure query performance
  • Query hints and plan guides
  • Parameter Sniffing issues
  • Query tuning case studies

Inside the show, you’ll also find a coupon code for the course.

About Shy

Shy Engelberg is the CTO of Valinor, and a Partner Technology Solutions Professional. He’s also a data and cloud technologies enthusiastic.
He believes that data drives the world, and cloud technologies fuel it. He constantly finds solutions to all sorts of problems and needs, and still learning something new every day.

shy-engelberg

Closed as Fixed

Download Episode (mp3)

In this show of SQL Server Radio:

  • Transactional Replication tips
  • How to self destruct a SQL Server Agent job
  • Storage at speed of memory on Windows Server 2016 and SQL Server 2016
  • Database backup and in Amazon RDS
  • Writing and syncing files to AWS s3
  • Mapping a partition to a filegroup in a partitioned table
  • A cool Twitter account for monitoring fixed SQL Server issues

Items mentioned in the show:

Yes/No Questions

Download Episode (mp3)

We start the show with a game of Yes/No questions.

Afterwards, we talk about:

  • Must we wait to service pack 1 before installing a new SQL Server version?
  • Comparing wait stats between dates
  • Tests when upgrading to SQL Server 2016
  • Paul Randal’s waits and latches library
  • And more..

Items mentioned in the show:

 

Don’t Stop Me Now

Download Episode (mp3)


In a few days delay, 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:

Paul Has it All

Download Episode (mp3)

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.

The Itzik Ben-Gan Trick

Download Episode (mp3)

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: