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

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

We Don’t Have a Name for This Show

9/14/2017
More
Download Episode (Mp3) Replicating Tables in Azure SQL Datawarehouse Persisting Statistics Sampling Rate, and Other Statistics Issues Adding Tables with Default Values Online The Microsoft Data Science Program Followup on a Previous Item Global Temp Tables in Azure SQL Database Loading a Trillion Rows into SQL Server

Duration:00:36:38

Tough SQL Server Questions

8/31/2017
More
Download Episode (Mp3) What do you do when you lost the admin password of Azure SQL DB? Tough SQL Server Interview Questions Should You Learn Data Science?

Duration:00:31:47

Deadlocks, Parallelism and Productivity

8/17/2017
More
Download Episode (mp3) A scenario where the same sessions deadlocks itself Other ways to think about parallelism Database Scoped temporary tables in Azure SQL Database Many productivity tips

Duration:00:38:28

The Mysterious Ways of the Optimizer

8/3/2017
More
Download Episode (mp3) In this show, we talk about: Why there are more and more security and encryption projects, and how wrestling is related More issues and things to take into account with the new cardinality estimator The Baader-Meinhof Phenomenon Truncating a single partition in SQL Server 2016

Duration:00:33:17

T-SQL Tuesday Stories

7/20/2017
More
Download Episode (mp3) T-SQL Tuesday is the monthly blogging party of the SQL Server community. In this show, we tell stories based on the latest T-SQL Tuesday topics.

Duration:00:26:16

Client Stories

7/6/2017
More
Download Episode (mp3) In this show, we share some client stories from recent projects: One nice thing of being a consultant Another consolidation project with a client implemented with views Performance recommendations from a client project Trivial optimization vs.Simple Parameterization Some challenges when working with MySQL

Duration:00:29:35

If Clippy Found His Way to SQL Server Radio

6/22/2017
More
Download Episode (mp3) In this show: The challenges of consolidation projects What is the Remote Query Harden error with Availability Groups PASS Summit precons Describe your profession in one sentence What if Clippy found his way to to SSMS? The right ways to manage open transactions

Duration:00:35:06

Try Premium for 30 days

Live games for all NFL, MLB, NBA, & NHL teams
Commercial-Free Music
No Display Ads