SQL Server Radio
1,348 FOLLOWERS
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..
SQL Server Radio
2w ago
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)
SQL Server Regular Expressions Library Sample - Microsoft Community Hub
STRING_SPLIT (Transact-SQL) - SQL Server | Microsoft Learn
Do You Have a Proper Backup Strategy? (madeiradata.com)
CHECKDB From Every Angle: Consistency Checking Options for a VL ..read more
SQL Server Radio
3M ago
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 even when perfectly safe? | Eitan Blumin
The Anatomy of Vardecimals | Mark S. Rasmussen
Utility Scripts/ReNumber_Identity_Column.sql
Introducing Azure Database Fleet Manager
Also, Happy New Year ..read more
SQL Server Radio
5M ago
SQL Server Radio is going on a short break this month.
Please tune in next month for when we'll be coming back!
In the meantime, check out some of our favorite past episodes:
Episode 108 - "I Really Want to Do It" Flags
Episode 115 - How can UPDATE STATISTICS cause HADR disconnections?
Episode 122 - What you didn't know that you wanted to know about XML
Episode 125 - Monitoring SQL Servers for a managed DBA service
Episode 144 - Getting Locked Outside Without Your Keys ..read more
SQL Server Radio
7M ago
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
  ..read more
SQL Server Radio
8M ago
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 ..read more
SQL Server Radio
9M ago
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/
  ..read more
SQL Server Radio
10M ago
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 ..read more
SQL Server Radio
11M ago
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 ..read more
SQL Server Radio
1y ago
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
Data Platform Summit ..read more