SQL Server Radio

SQL Server Radio

By Guy Glantser, Eitan BluminNewsTechnologyTech News
Download on the App Store

SQL Server Radio episodes

  • 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
    39 min
  • 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:
    * dbatools
    * DBA Googling on Twitter
    38 min
  • 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.
    41 min
  • Watermelon Shake

    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

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

    41 min
  • Closed as Fixed

    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
    27 min
  • PASS Summit 2016

    PASS Summit is next week, and in this show, we cover the sessions, the parties, the networking opportunities and the other goodies of the summit.

    32 min
  • Yes/No Questions

    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..
    27 min
  • 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:
    * 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
    33 min

About SQL Server Radio

From the publisher's feed

SQL Server Radio is a Podcast for SQL Server DBAs, database developers, architects, system administrators, and anyone else who is interested in the Microsoft SQL Server platform and the Microsoft data…

More shows like SQL Server Radio

Stuff You Should Know by iHeartPodcasts

Stuff You Should Know

78,393 Listeners

The Daily by The New York Times

The Daily

111,868 Listeners

The Stack Overflow Podcast by The Stack Overflow Podcast

The Stack Overflow Podcast

62 Listeners