SQL Server Radio-logo

SQL Server Radio

Technology News >

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. The show is intended to add another platform of knowledge sharing to the already strong SQL Server community.

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. The show is intended to add another platform of knowledge sharing to the already strong SQL Server community.
More Information

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. The show is intended to add another platform of knowledge sharing to the already strong SQL Server community.

Language:

English


Episodes

To SSDT or not to SSDT?

12/10/2018
More
Download Episode (mp3) In this show, we are happy to welcome a special guest - Dekel Asaf, R&D manager at OM2. We talked about many things, among them: Always On - or "Mostly On" Why DBAs don't Use SSDT? Database Unit Testing Sliding Window

Duration:00:37:39

Do you Miss Asynchronous Triggers Tonight?

11/8/2018
More
Download Episode (mp3) In this show, we talk about: Advanced Service Broker Sample: Asynchronous Triggers Azure SQL Database Availability Zones Microsoft Learn Magic Johnson Do You Trust Your Availability Group?

Duration:00:45:18

Show 100!

10/11/2018
More
Download Episode (mp3) Can you believe it? It's the 100th show!!! We have been doing it for 5 years, and we are having so much fun! We have been planning this show for a very long time, and we have some very special guests with us...

Duration:00:54:13

The 32-64-Bit Horror Show

8/30/2018
More
Download Episode (mp3) In this show we answered a listener's question about the 32-bit vs. 64-bit nightmare that developers have to go through when trying to access Excel files from SSIS. And we also mentioned a script to roll forward transaction log backups. The next show is the 100 show!!! We are planning a big party! Stay tuned...

Duration:00:19:16

The Wonders of Multi-Tenant Databases

8/16/2018
More
Download Episode (mp3) In this show, we talk about: How to Fix Orphaned DB Users Easily SSMS Auto-Recovery Feature Multi-Tenant Database Challenges Your DR Plan isn’t a Plan And much more...

Duration:00:39:56

Availability Groups, Corruption, Implicit Transactions and More…

7/26/2018
More
Download Episode (mp3) Show Notes: How to Set Up Availability Group with a Domain Account How to Start SQL Server Without Tempdb? Auto-Commit vs. Implicit Transactions What's between Corruption and Blocking? What Machine Learning Can Do?

Duration:00:35:32

Anzeigen 96

7/12/2018
More
Download Episode (mp3) Show 96 is here. Among other stuff, we talked about: SQLGrillen 2018 Simulating IGNORE NULLs Functionality on FIRST_VALUE and LAST_VALUE Functions Database Corruption Story Query Store, Automatic Query Tuning, and how they relate to automatic cars

Duration:00:43:22

SQL Server Programming Best Practices Panel

6/21/2018
More
Download Episode (mp3) it's been very busy lately, and Guy is currently abroad, so we're posting something a little different. For the 100th show of the Hebrew edition, we celebrated with 5 panels about different topics we held on SQLSaturday Israel. One of the panels was about programming best practices in SQL Server, and conveniently, it was in English. We'll be back in two weeks with a regular show. Enjoy!

Duration:00:44:22

Database DevOps with Alex Yates

5/31/2018
More
Download Episode (mp3) It's about time we have a guest in the show! We are excited to welcome Alex Yates (@_AlexYates_). In this show we talk about continuous integration, delivery and deployment for databases, why is it so hard, and what is the secret sauce. Here are some of links we covered in the conversation: Working with Devs… Database DevOps Anti Patterns Alex Yates - Database Development Alex Yates - Critiquing two different approaches to delivering databases: Migrations vs state

Duration:00:50:57

Once a DBA, Always a DBA

5/17/2018
More
Download Episode (mp3) In this show, we talk about: Google Duplex Accessing External Resources from SQL Server SQL Saturday Israel 2018 24 Hours of PASS Optimizing Server-Side Paging How to Change the Fonts in SSMS And more..

Duration:00:37:54

Remembering Robert Davis

5/3/2018
More
Download Episode (mp3) Robert Davis, aka @SQLSoldier, has recently passed away unexpectedly. This was a shock to the entire SQL family, and of course to his wife, Chrissy. Robert was one of the most known and loved professionals in the SQL community. He will be certainly missed. We dedicate this show in honor of Robert. We talk about some of his best blog posts over the years, his contributions, and also about his jokes. Here are some relevant links: SQLSoldier - News From the Front Lines...

Duration:00:21:51

Procrastinators and SQL Challenges

4/19/2018
More
Download Episode (mp3) Today in the Show: Inside the Mind of a Master Procrastinator 24 Hours of PASS The Next GroupBy Conference SQLGrillen 2018 A Flexible New Way to Purchase Azure SQL Database SQL is 44 Years Old and We Still Use It Today SQL Server Advanced Threat Protection Survey SQL Challenges

Duration:00:35:38

Kenneth Fisher’s Crossword Puzzle

4/5/2018
More
Download Episode (mp3) Today in the show, we solve (well, almost) a SQL Server crossword by Kenneth Fisher...

Duration:00:32:17

Nick the Optimizer

3/22/2018
More
Download Episode (mp3) 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?

Duration:00:38:55

Will Machines Eventually Haunt Us?

3/8/2018
More
Download Episode (mp3) 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

Duration:00:16:44

People Born in the 1900s are Old

2/22/2018
More
Download Episode (mp3) 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...

Duration:00:41:45

SSMS, Continuous Integration and Page Splits

2/8/2018
More
Download Episode (mp3) SSMS Unuseful Tips Why Database Continuous Integration is Challenging? Monitoring Page Splits

Duration:00:43:22

Getting Things Done

1/11/2018
More
Download Episode (mp3) Today in the show: Guy is back from Nepal The GTD method for productivity The future of DBA work (Data Engineering and Database Reliability Engineering) Threadpool waits Getting used to learning new things Good old Implicit_Conversion And more..

Duration:00:31:01

Be as Lazy as Possible

12/28/2017
More
Download Episode (mp3) In this show, we talk about: Glenn Berry's Diagnostic Information Queries The options for restricting access using Azure SQL Database firewall Something Cool We Learnt Today The role of the UPDATE lock in SQL Server Building your performance monitoring infrastructure And some big news...

Duration:00:22:00

Let Me Index That for You

11/30/2017
More
Download episode (mp3) Today in the show, we talk about: Types of business analytics Is cardinality estimation the most common cause for performance problems? How to answer the question "what do you do"? Old news about AWS max database size in RDS New project architecture challenges Reporting and comic books Scary bug with mirroring and database snapshot

Duration:00:37:25