Best Architects Darling Podcasts (2024)

1
Episode 162 - Backups and Recovery, RTO, RPO, and RCO 35:55

10d ago35:55

35:55

Guy and Eitan talk about some interesting news from Microsoft about SQL Server in Azure. And also discuss the topic of Backups and Recovery, RTO, RPO, RCO, and database Integrity Checks. Relevant links: Microsoft Copilot in Azure extends capabilities to Azure SQL Database (Private Preview) - Microsoft Community Hub Regex in SQL DB (microsoft.com) S…

1
Episode 161 - EXCLUSIVE: Announcing the Biggest Innovation for Azure SQL Managed Instances (Codename: Hermes) 41:51

29d ago41:51

41:51

Niko Neugebauer and Vladimir Ivanovic are our esteemed guests for today, and they have a HUGE announcement to make about Azure SQL Managed Instances. Extra! Extra! 🗞 Hear all about it on this exclusive scoop here at the SQL Server Radio podcast! Relevant links: Azure SQL Managed Instance Next-gen GP (microsoft.com) Use Next-gen General Purpose serv…

1
Episode 160 - OPTION RECOMPILE and the magical Turbo button 32:49

2M ago32:49

32:49

Guy tries to convince Eitan that OPTION(RECOMPILE) is the ultimate "Turbo" button in SQL Server, and that it's strongly underappreciated. Relevant links for more info: OPTION(RECOMPILE) (Transact-SQL) - SQL Server | Microsoft Learn Recompile a Stored Procedure - SQL Server | Microsoft Learn Should I use option(recompile)? – SQLServerCentral SQL SER…

1
Episode 159 - Select * Wastes Money 37:55

4M ago37:55

37:55

Guy and Eitan discuss various practices in SQL Server that hurt performance and possibly waste money, negative VarDecimal numbers, renumbering Identity columns, and the new Azure Database Fleet Manager. Relevant links: SQL Server IN Clause With Multiple Literal Values Performance Behaviour | Neeraj Prasad Sharma Could SQL Injection be dangerous eve…

1
Episode 158 - Reverse Engineering Table Relations based on SQL Plans 41:41

4M ago41:41

41:41

Guy and Eitan talk about some great things about SQL Server, and mostly Guy’s experience in digging into execution plans and generating synthetic IO workloads. Relevant links: What’s new in SQL Server and Azure SQL 2023 Year in Review Multi-Tenancy in the Real World | Eitan Blumin (Data Weekender 6.5)…

1
Episode 157 - Let's Talk Some Hardcore SQL Server 39:00

7M ago39:00

39:00

Guy and Eitan go back to their SQL Server roots and go hardcore into execution plan analysis and database corruption. Relevant links: Health Check Scripts/Find_Top_Exec_Plans_to_Optimize.sql SQLServerFast.com Database Corruption Challenge by Steve Steadman A DBA's Guide to the Proper Handling of Corruption Data TLV Summit PASS Data Community Summit…

1
Episode 156 - Back to School with Encryption as a Tool 39:42

8M ago39:42

39:42

Guy and Eitan celebrate resuming the school year with some learning of their own. This time, focusing on encryption types in SQL Server. Relevant links: External REST Endpoint Invocation is now GA! Types of Encryption in SQL Server PWDENCRYPT and PWDCOMPARE Dynamic Data Masking And also, don’t forget to register for the upcoming Data TLV Summit!…

1
Episode 155 - Kevin Chant 33:24

9M ago33:24

33:24

Today we have Kevin Chant as our guest! We talk about Kevin’s favorite topics: Microsoft Fabric, Azure DevOps, SQL Server, and more. Relevant links: https://www.kevinrchant.com/2023/06/13/create-your-own-microsoft-fabric-environment/

1
Episode 154 - Beavers and very loud farts 37:14

10M ago37:14

37:14

Guy and Eitan discuss several interesting topics and recent experiences that you'd want to hear about! Relevant links: Trigram Wildcard String Search in SQL Server The Story of DBeaver, PostgreSQL, and the silly data engineer SQL Server Error Log Management High VLF Counts Got You Down? Here's How to Keep Them Low and Performance High…

1
Episode 153 - Erik Darling Is Our Guest For Today 39:04

10M ago39:04

39:04

As promised in the previous episode, Guy and Eitan interview an actual human this time! The one and only, the famed Erik Darling is our guest for today! Check out his official website: Erik Darling Data Erik Darling's YouTube Channel We apologize in advance for Guy's occasional audio glitches, as he was having network issues on the day of recording…

1
Episode 152 - We interview ChatGPT 37:01

12M ago37:01

37:01

Guy and Eitan try something new for today's show - we interview ChatGPT as our guest for today, and make it pretend that it's a SQL Server expert! Let's see how it does. Relevant links: Monitor performance by using the Query Store Brent Ozar Unlimited SQLSkills Scary DBA SQL Authority PASS Data Community Summit SQLBits GroupBy Virtual Conference Da…

1
Episode 151 - Tales from the SQL Bits of 2023 31:57

1y ago31:57

31:57

Guy and Eitan share their experience from SQLBits 2023 and some of their favorite sessions. Relevant links: Official SQLBits Website SQLBits Content Library SQLBits YouTube Channel SQL Server Debugging with WinDbg – an Introduction Join #TeamHugo and Help Fight Leukemia Parameter Sensitive Plan optimization Azure Functions overview GitHub CoPilot…

1
Episode 150 - Artificially Intelligent Query Processing 33:42

1y ago33:42

33:42

Guy and Eitan discuss some new and existing capabilities in the SQL Server engine related to Intelligent Query Processing, and whether our job positions as DBAs are at risk due to the imminent takeover by our robot overlords. Relevant links: Intelligent Query Processing Adaptive Joins (Batch) Intelligent Query Processing Feedback family of features…

1
XHM #639 - "Born to be a lion" (2023 March 06) 2:03:10

1y ago2:03:10

2:03:10

For Week 6 of our annual Oscars profile, this pre-recorded episode focuses on the nominees for Best Original Song. We'll hear songs from the films Black Panther: Wakanda Forever, Tell It Like a Woman, Top Gun: Maverick, RRR and Everything Everywhere All at Once. We'll also hear some songs that missed the cut whilst gak celebrates some birthday or o…

1
XHM #638 - "The only percussion comes in the form of ammunation" (2023 February 27) 2:04:17

1y ago2:04:17

2:04:17

Oscar season continues with the 5th and final of the best original score nominees: Volker Bertelmann's music from All Quiet on the Western Front. 1. The Zombies: Butcher's Tale [Western Front 1914] (Odessey and Oracle, 1968) CBS/Date 2. In Mirrors: An Introduction (Only Time Will Tell: Leopard B-sides, 2022) self-released 3. Big Thief: Time Escapin…

1
XHM #637 - "A portrait of the artist as a young man playing with UFOs & dinosaurs" (2023 February 20) 2:03:15

1y ago2:03:15

2:03:15

It's Week 4 of our annual Oscars profile so for your Family Day programming, we'll hear cues from John Williams' nominated score from Steven Spielberg's pseudo-autobiographical film The Fabelmans. We also embrace Carnaval, Mardi Gras and the start to Lent as we acknowledge the recently deceased, one year of Ukraine's invasion and other news. 1. Des…

1
XHM #636 - "These talkies are the path to sin" (2023 February 13) 2:01:23

1y ago2:01:23

2:01:23

Our Oscars profile continue with Justin Hurwitz's nominated original score from Babylon. We also talk about earthquakes, many a live event in Vancouver this week -- including Hotham Sound's Drop Cities 2-day hoedown -- and a weird blend of jazz age remixes and what Babylon is. Thanks to everyone who donated to Fundrive 2023! 1. Altin Gün: Yali Yali…

1
Episode 149 - 8 Common DBA Mistakes in SQL Server 35:45

1y ago35:45

35:45

Guy and Eitan list several common mistakes done by DBAs in SQL Server. Some relevant links: Architecting Database Dev and Test Environments: Best Practices and Anti-Patterns for SQL Server Ola Hallengren's Maintenance Solution HADR My Jobs - Open Source Solution by Madeira Columnstore Indexes: Planning and Implementation TSQL Script to Check for We…

1
XHM #635 - "Be in love with nothing but the bagel" (2023 February 06) 2:02:01

1y ago2:02:01

2:02:01

We press on in the multiverse of Oscar nominees for the 95th Academy Awards with a redux on Son Lux's nominated score to Everything Everywhere All at Once along with a nominated song featuring Mitski & David Byrne. Fundrive 2023 is on! Visit http://citr.ca/donate to help CITR upgrade its transmission tower and FM antenna. 1. Shakespears Sister: Hel…

1
XHM #634 - "Bread vans & miniature donkeys" (2023 January 30) 2:06:01

1y ago2:06:01

2:06:01

The nominees for the 95th Academy Awards were announced last week so it's the start to our annual Oscars profile! We'll kick off with Carter Burwell's nominated score to the film The Banshees of Inisherin as we mix the usual tributes and newish songs, though there'll be a spot of vintage Irish folk to further confuse the fields. CITR Fundrive 2023 …

1
XHM #633 - "Kung fu Cantopop" (2023 January 23) 2:01:02

1y ago2:01:02

2:01:02

The Year of the Rabbit is upon us, so amongst some bunny related songs, we'll have tributes to guitarist Jeff Beck, singer David Crosby and Hong Kong composer Joseph Koo (1931-2023) as we profile some of his action film soundtracks. 1. Cristobal Tapia de Veer: Mr Rabbit It Is (Utopia OST, 2013) Silva Screen/Kudos 2. Phil Western: Rabbits (Laborandu…

1
24 Hours of Radio Art: Hours 11 & 12 - "koillinen, kaakko, lounas & luode" (2023 January 17) 1:59:57

1+ y ago1:59:57

1:59:57

gak is back for another two hours of radio art, though he had plans for eight hours, so prepare for four separate layers of sonic mayhem, mixing spoken word, field recordings, soothing drone and not-so-soothing noise, highlighting the creative minds that inspire us all. there are eulogies for some brilliant souls who left us in 2022: vangelis, geor…

1
XHM #632 - "The crystal owls are totally what they seem" (2023 January 16) 2:04:46

1+ y ago2:04:46

2:04:46

In honour of composer Angelo Badalamenti (1937-2022), we pay tribute to only a modest selection of his wide varied musical career, definitely leaning on the David Lynch collaborations we primarily associate with him. gak also marks 15 years at CITR with a mix of moody melodies. 1. Guy Smiley: The 15 Commercial [w.The Count] (The Count Counts, 1975)…

1
XHM #631 - "Only feels like it's raining forever" (2023 January 09) 1:57:23

1+ y ago1:57:23

1:57:23

As we crawl into 2023 properly, we pay tribute to Seattle composer Norm Chambers (1972-2022), who recorded ambient music under various aliases. We'll focus on his score to the 2017 documentary Graphic Means amongst other bleepy bits, eulogies, quality tunes from 2022 and a taste of the music already out in the new year. 1. Reindeer: 2023 (Reindeer,…

1
Episode 148 - Rob Sewell and SQLBits 2023 40:54

1+ y ago40:54

40:54

Today we have the pleasure of hosting Rob Sewell, and talking about the upcoming SQLBits event of 2023! Relevant links: SQLBits 2023 agenda, speakers, pricing, and registration - events.sqlbits.com/2023 YouTube playlist of all 195 sessions from SQLBits 2022 - available for free! SQLBits helpers form - beard.media/sqlbits-helpers Rob Sewell's blog -…

1
XHM #630 - "Rogue zero" (2023 January 02) 2:13:01

1+ y ago2:13:01

2:13:01

Before closing the book completely on 2022, we'll bid adieu via our annual year-in-review episode. I'm unable to do a best of in a limited amount of time, so we'll touch upon the acts that put out new music over the past 12 months and dive into Nicholas Britell's score to the surprising Star Wars TV prequel series Andor. 1. Nicholas Britell: We Beg…

1
XHM #629 - "Eight lights to hold you" (2022 December 22 & 26) 2:02:52

1+ y ago2:02:52

2:02:52

We're in the midst of Hanukkah so since we got our counter-Christmas episode taken care of last week, this one focuses on the Jewish festival of lights though there are some songs about default holidays and December in the mix. Our soundtrack profile is not tied to Hanukkah per se but a very dear soundtrack to me: 1971's Fiddler on the Roof, the fi…

1
XHM #628 - "The Christmas is coming from inside the house" (2022 December 12) 2:03:32

1+ y ago2:03:32

2:03:32

As the holiday season feels like it's becoming normal, for our 15th annual counter carol episode, we'll go abnormal as we profile the 1974 Canuxploitation film Black Christmas and all sorts of darker Yuletide material. We've lost some key cultural folks tied to Christmas and music, so embrace the mix. We're doing this early so you don't feel utterl…

1
Episode 147 - Congratulations! It's an RTM! 34:42

1+ y ago34:42

34:42

Guy and Eitan finally celebrate the generally available release of SQL Server 2022! And also discuss other announcements from PASS Data Community Summit, and also various interesting news and features of Azure SQL announced in November 2022. Relevant links: SQL Server 2022 is now generally available Consumption-based PAYG billing model for SQL Serv…

1
XHM #627 - "This is the excuse that we're making" (2022 December 05) 2:04:43

1+ y ago2:04:43

2:04:43

This episode attempts to fill the empty dancefloor with a profile on the Belgian production duo Soulwax and their soundtrack to the 2016 film Belgica. 1. Charlotte Adigéry & Bolis Pupul: Bel Deewee (Topical Dancer, 2022) Deewee/Because Music 2. Du Tonc: Rise [Mighty Mouse's Discolife dub] (La.Ga.Sta Late Summer Compilation: Volume 5, 2015) Lagasta …

1
XHM #626 - "From badges to badgers, we got it all" (2022 November 28) 2:02:42

1+ y ago2:02:42

2:02:42

Finally breaking free of all the horror, we pivot to parody performer Weird Al Yankovic. Not only do we listen to selections from his new "autobiography" Weird, we go back to 1989's UHF. We also prepare you for the 2022 Shindig Finale in Vancouver as CITR's battle of the bands wraps up this Friday. 1. Diedrich Bader: You Don't Know Anything (Weird:…

1
XHM #625 - "Print me a pilot, architect me an atmosphere" (2022 November 21) 2:03:26

1+ y ago2:03:26

2:03:26

We're overdue on a listen to Ryuichi Sakamoto so we'll mostly focus on his score to the Netflix anime series Exception amongst other experimental/classical music from 2022. 1. Dixia Sirong: Qatarsea [XLR8R edit] (Di Er EP, 2016) Inner Balance 2. Loscil: Still (The Sails Pt. 1, 2022) Frond 3. Okay Kaya: In Regards to Your Tweet (SAP, 2022) Jagjaguwa…

1
XHM #624 - "Typewriters count as technology" (2022 November 14) 2:02:01

1+ y ago2:02:01

2:02:01

This mostly moody episode focuses on Blanck Mass' score to the 2021 film Ted K, detailing the life of the feared Unabomber. We also pay tribute to Nik Turner of Hawkwind, queer country pioneer Patrick Haggerty, singer Gal Costa, rapper Takeoff from Migos and composer Norm Chambers. 1. Hawkwind: Master of the Universe (In Search of Space, 1971) Unit…

1
Episode 146 - New DMVs and Application Reliability 33:32

1+ y ago33:32

33:32

Guy and Eitan play a game of word associations to spout a bunch of stuff about SQL Server features - mostly reviewing new system objects that replaced old DBCC commands, useful scripts in our toolbox, and talking about Application Reliability Errors. Relevant links: Buffer Pool Extension SQL Server editions comparison dashboard by domains, features…

Podcasts Worth a Listen

Architects Darling Podcasts

Podcasts Worth a Listen

Quick Reference Guide