The Elephant in the Room

Download Episode (mp3)

In this show, we talk about:

We also have a new promo for the show! Let us know what you think about it in the comments!

Matan Loves Marriage

Download Episode (mp3)

In this show, we talk a lot about interesting projects we’ve been a part of lately, in addition to other interesting items:

  • Guy on installing a 3-node SQL Server 2016 Availability Groups cluster with no domain
  • Matan on migrating a system to In-Memory OLTP
  • Why Matan doesn’t hate the MERGE statement anymore
  • SQL Server 2016 SP1
  • Thoughts and clarifications about DBCC CheckDB

SQL Server Hydra

Download episode (mp3)

In this show, we host our friend Shy Engelberg again and talk about:

  • New features in SQL Server Hydra
  • The future of Linked Servers
  • External Data Sources
  • Scripts from the SQL Server Tiger team
  • How the guys at Facebook verify their backups can be restored
  • Recommended approaches for HA and DR

Also, during the show Guy takes some of his recommendations regarding temp tables and table variables back

Items mentioned in the show:

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: