SQL Server Radio
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 Learning, and much more.
- Update frequency
- every 27 days
- Average duration
- 37 minutes
- Episodes
- 169
- Years Active
- 2014 - 2025
Virtuaization, Data Science and More
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 produ…
Client Stories
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 fr…
If Clippy Found His Way to SQL Server Radio
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 Cl…
A Sign Your Wife is Married to a DBA…
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 i…
SQL Server 2000 Good Old Days
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..
Watermelon Shake
In this show, we host our good friend and great DBA, Shy Engelberg.
Together with Shy, we talk about:
- Guy's new online course - Advanced Query Tuning in SQL Server
- How to write queries for dynamic s…
Closed as Fixed
In this show of SQL Server Radio:
- Transactional Replication tips
- How to self destruct a SQL Server Agent job
- Storage at speed of memory on Windows Server 2016 and SQL Server 2016
- Database backup and…
PASS Summit 2016
PASS Summit is next week, and in this show, we cover the sessions, the parties, the networking opportunities and the other goodies of the summit.
Yes/No Questions
We start the show with a game of Yes/No questions.
Afterwards, we talk about:
- Must we wait to service pack 1 before installing a new SQL Server version?
- Comparing wait stats between dates
- Tests whe…
Don't Stop Me Now
Show 56 is here, and this time we talk about:
- Itzik Ben-Gan's ways for unpivoting data
- Auditing every change in every table
- The Dunning-Krugher Effect and how it's related to new technologies
- Use Ca…
Paul Has it All
Today in the show, we:
- Check whether Set Nocount On is still needed
- Extract data easily
- Deep dive into Always Encrypter
- Unmask Dynamic Data Masking
- Check why we don't get emails about deadlocks
- Chec…
The Itzik Ben-Gan Trick
Itzik Ben-Gan has many T-SQL tricks.
In this show, we talk about a few of them:
- How to get Batch Mode Processing with regular tables
- How to share Identity between different tables
- How to use Cross A…
If You Need to Think, You’re Doing It Wrong
Guy is back from a one month trip in the United States, and we're back with another show of SQL Server Radio.
In this show, we talk about a few of our upcoming speaking gigs (PASS Summit and SQL Serv…
SQL Server Radio Show 51 - SQL Server 2016
What's new in SQL Server 2016?
In this show, we celebrate the official release of SQL Server 2016 and talk about the new features of the version.
Show 50 - Top 50 Features
We can't really believe it, but it's the 50th show of SQL Server Radio! Time does fly when having fun!
To celebrate the 50th show, we have a countdown of the top 50 SQL Server features of all time..w…