SQL Server Radio-logo

SQL Server Radio

Technology Podcasts

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.

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.

Location:

United States

Description:

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.

Language:

English


Episodes

Episode 127 - The Red-Gate-took-over-and-now-we-get-free-stuff Summit

4/12/2021
Guy and Eitan discuss lots of interesting recent news, and also about various technical topics in SQL Server. Relevant links: News about PASS and SQL Saturday: What’s next for PASS Summit this fall? Ideas forum The SQL Saturday Foundation Board of Directors The new Azure Data Community webpage from Microsoft PASS Summit 2020 session recordings PASS Pro Educational Series at Red Gate University Data Saturday #1 Recordings Available on YouTubeAround the Clock with Azure SQL and Azure...

Duration:00:43:30

Episode 126 - Leading a Zeitgeist in the SQL Server Community

3/8/2021
Check out the episode where we start movements to change the way everyone writes T-SQL code, and/or deliver data platform meetups! And we also talk about a bunch of other stuff as well. Relevant Links: Join the SQL Server Community Slack and our new channel #SQLServerRadio !Ask Us Anything: Database Performance Tuning and Optimization | Data Platform Meetup IsraelRedgate Software takes over from PASS and commits to the future of the Summit, SQLSaturday and the communityEducational Series...

Duration:00:42:57

Episode 125 - Monitoring SQL Servers for a managed DBA service

2/8/2021
We have a special topic for today, where we talk about our own managed DBA service, and how we ended up choosing SentryOne SQL Sentry as our go-to monitoring platform for SQL Servers. Relevant links with more details: DBSmart - The Managed DBA Service from Madeira Data SolutionsSentryOne SQL Sentryclr_http_request - CLR assembly to send HTTP web requests from within SQL ServerCase study - UPDATE STATISTICS causing TempDB stress and Availability Group fail-oversMadeira Data Solutions is a...

Duration:00:39:30

Episode 124 - The Vanguards of Data

1/11/2021
Guy and Eitan host a very special guest and speak about various SQL Server and Data Platform topics, and recent events. Relevant links: for more details Cassandra - Use cases: when to use and when not to useCommunity call for creating the fastest number series generator | Itzik Ben GanSQL Server Feature Request: Adding Multi-column IN clause support by SQL Servermysqlbinlog — Utility for Processing MySQL Binary Log FilesFAQ about the dissolution of PASS | Andy...

Duration:00:36:06

Episode 123 - Beware of the Parallel Plan

12/14/2020
Guy and Eitan take a break from talking about the PASS virtual summit, and celebrate with some interesting content. Relevant links: Part 1Part 2Part 3Part 4Part 5Part 6Conclusions@TrumpDBA@Bernie_DBA@biden_dbaConcatenating Strings in SQL Server | Guy GlantserMaking a more reliable and flexible sp_MSforeachdb | Aaron BertrandPrintMAX by Ben DillPrintMaxMinified by Eitan BluminAccess Violation Error querying from system functions with parallelismSQL Server Cumulative Update releases are...

Duration:00:55:00

Episode 122 - What you didn't know that you wanted to know about XML

11/8/2020
Our guest for today is Yitzhak Khabinsky, a subject-matter expert on XML in SQL Server (among other impressive titles). We deep dive into the topic of XML, its history, its purpose and limitations within SQL Server, and fascinating capabilities that you never knew about... And also, how does JSON fit in this whole story? Yitzhak Khabinsky | LinkedInAzure Feedback item to update XML API engine in SQL ServerAzure Feedback item to improve JSON capabilities in SQL Server

Duration:00:55:19

Episode 121 - to PASS or not to PASS

10/5/2020
Guy and Eitan discuss PASS Virtual Summit 2020, what we should expect, whether it's worth the price tag or not, and discuss the future of the PASS organization. Relevant links: https://www.pass.org/summit/2020/Imagine All the People | Guy GlantserSELECT TOP (3) Pre-Conference Sessions | Guy GlantserWhy I’m Not Speaking at PASS Summit and You Shouldn’t Either | Joey...

Duration:00:50:34

Episode 120 - Operator Level Statistics

9/7/2020
Guy and Eitan talk about recent and upcoming virtual events, and discuss the newly available runtime statistics at the operator-level in actual execution plans. Relevant links: Data Platform Virtual Summit 2020Development Lifecycle Basics for DBAs - PASS Application Development Virtual GroupData Weekender #TheSQL Oct 17thSQL Workshops (Microsoft repository in GitHub)GroupBy.orgStarting SQL: Measuring A Query (Eric Darling)SSRS with Basic Authentication (open-source sample project)SQL...

Duration:00:43:30

Episode 119 - Overriding Reporting Services Authentication

8/10/2020
Guy and Eitan talk about Virtual Summits and free online courses, how to override SSRS authentication, and learn how to pronounce Eitan's name. Also, we're terribly sorry in advance for the windy interferences! Links: PASS Virtual SummitModernizing Your Data Platform by Guy GlantserAzure SQL Bootcamp with Bob Ward & Anna HoffmanFree Courses by Kendra LittleHow to start with Azure Data Explorer - A new online courseOverriding SSRS Authentication | Eitan BluminReportViewerWrapper | Stefan...

Duration:01:14:17

Episode 118 - Going reverse in a one way street

7/13/2020
Guy and Eitan talk about several workarounds that boil down to using a solution for something other than its intended purpose. Relevant links: Moving A Database to New Storage With No Downtime | Bob PusateriPlanning a Migration from Azure SQL DB to Azure Managed Instance | Eitan BluminThe Internals of the External SqlPackage Tool - Inside a bacpac File | Ronen Ariely (Data Platform Meetup Israel)Editing a .bacpac file | Microsoft Tech CommunityBlog post about Azure SQL Analytics | Eitan...

Duration:01:10:17

Episode 117 - May the Free Events be ever in your favor

6/8/2020
Today we talk about all the exciting free events that we were involved with during May, with even more to come, and also some other interesting news! Check them out: The Performance Tuning Magic Show by Guy Glantser (PASS Application Development)Accelerated Database Recovery by Guy Glantser (PASS Global Hebrew Virtual Chapter)SQL Server Setup Best Practices by Guy Glantser (GroupBy.org)Data Weekender EuropeDevelopment Lifecycle Basics for DBAs by Eitan BluminSSDT Template with tSQLt and...

Duration:00:44:31

Episode 116 - FREEApril and a promising May

5/11/2020
Today's show notes are quite a handful! Red Gate report about the State of Database DevOpsEitan's session about Development Lifecycle Basics for DBAsData Community Weekender EuropeData Platform Discovery DayGroupByDataPlatformGeeks Virtual SymposiumPASS Recordings ListingRed-Gate StreamedSentryOne WebinarsT-SQL Tuesday LIVEData Platform Meetup IsraelPASS Global Hebrew Virtual Chapter Free Webinars in HebrewMadeira ToolboxBlog postsSQL Server Management Studio 18.5How to migrate SQL data to...

Duration:00:37:24

Episode 115 - How can UPDATE STATISTICS cause HADR disconnections?

4/13/2020
Eitan does his worst Donald Trump impression, and talks SQL Server stuff with Guy Glantser: Ola Hallengren's maintenance solutionSQL Server Index Maintenance – You’re Doing It Wrong | Sean GallardyBecause Your Index Maintenance Script Is Measuring The Wrong Thing | Erik DarlingEitan's File Size Maintenance SolutionMCSA, MCSD, MCSE certifications retire; with continued investment to role-based certificationsAzure SQL Managed Instance Performance Considerations | Tim RadneyAzure Windows VM...

Duration:00:44:27

Episode 114 - Lots of catching up to do

3/9/2020
Guy Glantser is co-hosting with Eitan Blumin for the first time, and we have a lot of topics to cover and catching up to do.

Duration:00:43:31

SQL Server Radio Important Announcement

2/16/2020
After a very long break, today we come to you with a very special show, with a very special announcement to make. You do not want to miss this one!

Duration:00:21:27

Things You Shouldn't Do with SQL Server

11/7/2019
Guy is back from New Zealand. We talk a little bit about his trip, about things that people shouldn't be doing with SQL Server, and more.

Duration:00:27:00

What You Should Do Before You Actually Start Working

10/12/2019
Guy is in New Zealand, so Eitan Blumin comes to fill in. We talk about:

Duration:00:41:08

The Best Song of the 90s

9/5/2019
Download Episode (mp3) In this show: MySQL, Vertica, Azure Data Explorer and Matan 24 Hours of PASS: Summit Preview 2019 PASS Summit 2019: Session Schedule The Data Bias in Song Contests How SQL Server Compares Strings with Trailing Spaces Using Azure Data Explorer and Fastly to Improve Taboola Customer Experiences Kusto in Taboola – Azure Data Explorer

Duration:00:35:15

The Best Song of the 90s

9/5/2019
In this show: 24 Hours of PASS: Summit Preview 2019PASS Summit 2019: Session ScheduleHow SQL Server Compares Strings with Trailing SpacesUsing Azure Data Explorer and Fastly to Improve Taboola Customer ExperiencesKusto in Taboola – Azure Data Explorer

Duration:00:35:15

Big Mistakes with Brent Ozar (Rebroadcast)

8/16/2019
We had a technical issue with this month’s recording, so instead we’re going back to one of our favorite shows – Big Mistakes with Brent Ozar. Enjoy, and we’ll be back with new stuff in a few weeks. Among other mistakes, we talk about:

Duration:00:39:49