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

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

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

SQL Server 2017

11/9/2017
More
Download Episode (mp3) In this show, we talk about everything that's new in SQL Server 2017

Duration:00:32:45

[Replay] Show 11 – T-SQL

10/26/2017
More
Download Episode (mp3) Guy is currently having fun in Thailand, so we don't have a new show this week. Instead, we republish one of our earlier episodes, where we talk about our favorite language - T-SQL. We'll be back with a new show in two weeks. Did you know that SQL was initially called "Sequel" (Structured English Query Language)? On this show, we go back to basics and talk about our favorite language - Transact-SQL (T-SQL). We cover a lot of topics in the fields of development,...

Duration:00:38:37

Help the Optimizer

10/12/2017
More
Download Episode (mp3) There are many ways for writing 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

Duration:00:23:53

Virtuaization, Data Science and More

9/28/2017
More
Download Episode (mp3) 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

Duration:00:42:22