SQL Server Radio-logo

SQL Server Radio

218 Favorites

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

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


It’s 2017! Stop Doing That! – Part 2

6/8/2017
More
Download Episode (mp3) In this show of SQL Server Radio: Different types of recompile On what subject does Guy not agree with Paul White? Why the buffer cache hit ratio counter is misleading When should you stop worrying regarding the page life expectancy counter

Duration: 00:32:19


A Sign Your Wife is Married to a DBA

5/25/2017
More
Download Episode (mp3) In this show, we talk about: Our sessions at the GroupBy conference Another difference between the old and new Cardinality Estimators Lightweight Profiling in SQL Server 2016 SP1 Sign Matan's wife is married to a DBA SSDT 2017 A cool SSMS shortcut A bug with CDC after a cumulative update The overhead of Antivirus software

Duration: 00:39:23


It’s 2017! Stop Doing That! – Part 1

4/27/2017
More
Download Episode (mp3) In this show, we talk about things we've been doing forever but might not need to do them anymore. Is parameter sniffing good or bad? Should you rebuild indexes? And what about update statistics?

Duration: 00:33:00


Robin Sparkles

4/13/2017
More
Download Episode (mp3) In this show, we talk about: The GroupBy Conference Hacking Dangers in Today's World DR in the Cloud Configuration Options you have to Change The Biggest Problem with Partitioning and How to Solve it

Duration: 00:28:53


Hilbert’s Hotel

3/30/2017
More
Download Episode (mp3) We've been travelling a lot lately, so It's been a while, but we're back! In this show, we talk about: Tips for SQL Server in the cloud We're speaking at the GroupBy conference Using a Dates table for solving T-SQL problems Interesting way to explain the SQL Server security model by Kevin Hill SQL Saturday Israel

Duration: 00:26:20


Great Productivity Tips

2/23/2017
More
Download Episode (mp3) Another episode is here, and this time we talk about: Lady Gaga SQL Server is the database management system of the year Complicated issue with licensing SSMS enhancements What do you do when you can't connect to SQL Server? How hackers connect to your database

Duration: 00:28:14


Don’t Run Barefoot

2/9/2017
More
Download Episode (mp3) In this show, we talk about: Some announcements about our upcoming SQL trips Context_info enhancements in SQL Server 2016 Problems when restoring a database with single user mode Exctracting data from OLTP and inserting to a data warehouse @SQLServerRadio on Twitter

Duration: 00:28:40


SQL Server 2000 Good Old Days

1/26/2017
More
Download Episode (mp3) Today in the show, we talk about: Another optimization for cases where you have to use cursors How to migrate a database to a lower version Paging in various SQL Server versions And more..

Duration: 00:24:16


The Elephant in the Room

1/12/2017
More
Download Episode (mp3) In this show, we talk about: Guy is coming to SQLSaturday Melbourne for a Precon about Hadoop Fundamentals A problem with a common performance tuning trick The GroupBy conference The SQLGrillen conference Advantages of SQL Server 2016 Enterprise Edition The wisdom of the crowds We also have a new promo for the show! Let us know what you think about it in the comments!

Duration: 00:25:29

See More