Guy Glantser, Eitan Blumin

SQL Server Radio

Technology EN ↓ 179 episodes

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 platform in general. As the data world changes, we also occasionally talk about other platforms and services like Azure and Amazon cloud services, Elastic Search, Hadoop, MongoDB, Machine Learning, and much more.

Author

Guy Glantser, Eitan Blumin

Episodes

Kenneth Fisher's Crossword Puzzle 04.04.2018 28:21

Today in the show, we solve (well, almost) a SQL Server crossword by Kenneth Fisher...

Nick the Optimizer 20.03.2018 33:51

Today in the show: The Best SQL Server Five-Words Tech Horror MongoDB Aggregation Feature in Azure Cosmos DB Data Discovery and Classification in SSMS Managing Multi-Tenant Applications Which One is Better? IN or BETWEEN?

People Born in the 1900s are Old 18.03.2018 35:22

Today in the show: How to Schedule a Failover Use Inline Functions Instead of Scalar Functions Guy's Productivity Guide Maintenance Plans Security Hole! And More…

SSMS, Continuous Integration and Page Splits 18.03.2018 37:11

Today in the show: SSMS Unuseful Tips Why Database Continuous Integration is Challenging? Monitoring Page Splits

Will Machines Eventually Haunt Us? 18.03.2018 33:07

Today in the show: How to Deploy Schema Changes with Zero Downtime We are All Experts in Identifying Cats How to Troubleshoot Application Timeouts Signs You are not a Senior DBA SQL Saturday Israel Precons Announced

Getting Things Done 11.01.2018 30:58

Be as Lazy as Possible 28.12.2017 34:57

Let Me Index That for You 28.11.2017 32:49

SQL Server 2017 09.11.2017 32:49

In this show, we talk about everything that's new in SQL Server 2017

Help the Optimizer 12.10.2017 28:44

There are many ways to write efficient queries in SQL Server. In this show we talk about a few of those ways, when the key is - "keep it simple". In addition, we talk about use cases for Big Data, Ways for transferring data to a reporting server, an interesting BI project Guy is working on, and more

Virtuaization, Data Science and More 28.09.2017 34:09

In this show, we talk about: How to tell if you have a CPU problem in a virtualized environment SQL Server setup tips Guy's experience from his data science course How we change over time More productivity tips

Client Stories 05.07.2017 22:03

In this show, we share some client stories from recent projects: One nice thing of being a consultant Another consolidation project with a client implemented with views Performance recommendations from a client project Trivial optimization vs. Simple Parameterization Some challenges when working with MySQL

If Clippy Found His Way to SQL Server Radio 21.06.2017 29:50

In this show: * The challenges of consolidation projects * What is the Remote Query Harden error with Availability Groups * PASS Summit precons * Describe your profession in one sentence * What if Clippy came to SSMS? * The right ways to manage open transactions

A Sign Your Wife is Married to a DBA… 24.05.2017 31:20

In this show, we talk about: Our sessions at the GroupBy conference Another difference between the old and new Cardinality Estimators Lightweight Profiling in SQL Server 2016 SP1 Sign Matan's wife is married to a DBA SSDT 2017 A cool SSMS shortcut

SQL Server 2000 Good Old Days 26.01.2017 24:17

Today in the show, we talk about: Another optimization for cases where you have to use cursors How to migrate a database to a lower version Paging in various SQL Server versions And more..

The Elephant in the Room 12.01.2017 25:30

12 Days of Christmas 23.12.2016 49:41

Matan Loves Marriage 14.12.2016 38:39

SQL Server Hydra 02.12.2016 37:35

Watermelon Shake 16.11.2016 40:16

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

Closed as Fixed 03.11.2016 26:59

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

PASS Summit 2016 20.10.2016 31:07

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.

Yes/No Questions 04.10.2016 26:10

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

Don't Stop Me Now 20.09.2016 32:56

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

Paul Has it All 01.09.2016 26:49

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