Best Sqlserver Podcasts (2024)

1
Your Computer Science Education 2:59

22h ago2:59

2:59

I know a lot of people in this business do not have computer science degrees. While some do, I suspect it's a minority. I'm certainly curious, so if you want to share your education experience in a comment, tell me if you have a degree and what the focus was, as well as answer a few other questions. At DevOps Days in Minneapolis recently, professor…

1
A Lack of Architecture and Planning 2:36

2h ago2:36

2:36

A few weeks ago, I was sitting in the audience, waiting for my turn to speak at DevOps Days in Minneapolis. Just before me, Xe Iaso delivered a funny and thought-provoking talk on building a social network on a whiteboard. It was very well done and had me feeling nervous about following that session. The talk is a bit of a satirical look at an inte…

1
What Do You Drop? 3:10

6d ago3:10

3:10

Many years ago I was training for a triathlon. I had competed in the Sandman Triathlon the previous year in Virginia Beach and wanted to do it again. I had a young child, work was busy, and I was struggling to find time to swim, bike, and run every week. One night, I was at a work event with a customer who was also a triathlete. He was much more co…

1
Prevent Complete SQL Injection 2:58

8h ago2:58

2:58

I would hope most of you reading this know what SQL Injection (SQi) is and how you can prevent it. Or at least what patterns cause problems. If not, here's a short explanation that is worth reading. If you have more questions, ask in our forums. SQL Injection has been, and continues to be, a problem in many systems. In fact, I chatted with Mike Wal…

1
A Checklist for Learning 3:00

11d ago3:00

3:00

One of the challenges many people have is focusing their learning efforts along some path. The best way to move forward is with steady effort that guides you through steps to build knowledge or skill. However, with so much information out there on the Internet, how do you decide where you focus your efforts? Lots of people choose a random method, b…

1
Episode 166 - DR Planning for SQL Server and Loading Large CSV Files 35:32

10d ago35:32

35:32

Guy and Eitan discuss the recent CrowdStrike incident and what it would mean for DBAs, and discuss options to load huge CSV files into SQL Server as fast as possible. Relevant links: 101 of Troubleshooting SQL Server on Linux - Microsoft Community Hub bcp utility - SQL Server | Microsoft Learn Altering lock escalation for SQL Server tables (mssqlti…

1
Send Metrics Not Logs 2:55

5d ago2:55

2:55

This is part of a series on observability, a concept taking hold in modern software engineering. One of the interesting things I saw in an engineering presentation on Observability from Chik-Fil-A was that they are sometimes bandwidth-constrained at remote sites. In an early version of their platform, they sent logs back to HQ, and their logs used …

1
פרק 173 - נעילות וצרות אחרות 39:39

6d ago39:39

39:39

גיא ואיתן מדברים על העולם המופלא של הנעילות ב-SQL Server ואיך להתמודד איתו. קישורים רלוונטיים: Transaction locking and row versioning guide - SQL Server | Microsoft Learn sys.dm_tran_locks (Transact-SQL) - SQL Server | Microsoft Learn sys.dm_os_waiting_tasks (Transact-SQL) - SQL Server | Microsoft Learn SET LOCK_TIMEOUT (Transact-SQL) - SQL Server …

1
Responding to a Disaster 3:52

22d ago3:52

3:52

Ryan had a planes, trains, and automobiles situation a few weeks ago. On the same day, I didn't. A delay for a few hours, but an easy trip home. Lots of other people didn't have a smooth trip, and I had a few friends who spent an extra night somewhere or had flights canceled and decided not to take a trip. The Crowdstrike outage hit the entire worl…

1
Episode 278: Running SQL Server on Azure VMs 1:04:29

22d ago1:04:29

1:04:29

Can you run SQL Server on Azure VM? Which VM is best? Is running SQL Server on a VM in Azure the right choice? Find out in this insightful episode with Anders Pedersen! With over 10 different SQL Server services now offered in Microsoft Azure, it can be difficult to know how you want to run your environment. Sometimes, the old ways are the best way…

1
A Quick Turnaround 2:50

23d ago2:50

2:50

I visited a customer last week and attended SQL Saturday Baton Rouge 2024. Both were fun events, and an enjoyable week, though I was away from my wife for 4.5 days, which she didn't love. Today, I had a quick turnaround, heading to Wisconsin Dells for THAT! Conference, which I attended last year and enjoyed. I didn't submit this to the event, but g…

1
Thinking About Technology 2:32

28d ago2:32

2:32

Technology has dramatically changed the world over time. The advent of cars dramatically changed the US, as people could go places and meet others in a way that was difficult and slow before. The telephone let us communicate with people all over the world at a pace that was previously impossible. Computer technology has furthered this at a truly am…

1
The Biggest Database Professional Challenges Today 2:22

30d ago2:22

2:22

Today I have a question for you: What are the three biggest challenges you face today as a database professional? Read the rest of The Biggest Database Professional Challenges Today

1
A Programmer's Attitude 3:25

1M ago3:25

3:25

I caught this piece on the need for programmers (developers) to not trust anyone, including themselves. It is written by a software developer for other software developers, but I think it can also apply to database work as well. It is a bit long, but it starts with the nature of abstractions in the world and how they let us work with simpler models…

1
Cloud vs On-premises 3:55

1M ago3:55

3:55

The cloud has been a controversial concept for much of its existence. While the idea has been around for many decades, AWS started selling IT services in 2006, with Azure following suit in 2008. Since then, the use of cloud services has grown tremendously. While some applications and organizations have embraced the idea from the beginning. I found …

1
Episode 277: PostgreSQL for the SQL Server Crowd 1:02:29

29d ago1:02:29

1:02:29

Is testing out pgAdmin on your to-do list? In this episode of the podcast, we chat with Ryan Booz, a PostgreSQL advocate at Redgate, about how a SQL Server professional might begin a dive into PostgreSQL, one of the most popular open source databases in the world. Ryan came from a career background in SQL Server, but after experiencing his accident…

1
Least Privilege 3:08

1M ago3:08

3:08

I assume that most of you know about the principle of least privilege. If not, please read this short blog from Brian Kelley and make sure you understand how you should approach security. In the modern world, we also ought to adapt our systems for the zero trust model, which includes the least privilege principle. However, I wonder how many of your…

1
The Stretch Database Retirement 2:57

2M ago2:57

2:57

Stretch Database is finally going away. It is being retired. It was deprecated on Nov 16, 2022, from SQL Server 2022. Effective Jul 9, 2024, the supporting Azure service is retired. I saw this in an announcement on Jul 3, though I hope anyone using this service has been seeing lots of reminders over the last couple of years. I know I'm getting MySQ…

1
Episode 165 - News in Azure SQL and Woes of Excel 38:44

1M ago38:44

38:44

Guy and Eitan discuss some important and interesting news from Microsoft about SQL Server, Straight Path Solutions publish 30 articles about SQL Server security checks, Guy talks about his experience with Excel, and Eitan is irritated about people still not doing SQL jobs correctly in AlwaysOn Availability Groups. Relevant links: SQLBits Free Video…

1
פרק 172 - TempDB, אינדקסים, ומה שביניהם 44:59

1M ago44:59

44:59

מכירים את רדיו SQL SERVER? תכירו את שיחות בין DBA'S! הפודקאסט שלנו עבר מיתוג מחדש, ואפילו צולם לראשונה(: על מה דיברנו? קצת על המהלך, על הקהילה, על Tempdb,אינדקסים ושיפור ביצועים ועוד. קישורים לערוצי הקהילה

1
An Upgrade Slog 3:16

2M ago3:16

3:16

I saw a blog post from Randolph West recently that asked How do you restore a SQL Server 2000 database in the year 2024? It's a bit of a process, involving an intermediate version and two restores. He also points out the need to run DBCC after the first restore, which is a good idea. I wonder how many people would take the time to do this, or even …

1
Midsummer Fun 4:41

2M ago4:41

4:41

Yesterday was Independence Day in the US and a day off for me. Today, I'm back to work. Same for my rocket engineer son, one day off. My wife remembers a few of her companies giving a 4-day weekend when a holiday falls on a Tuesday or Thursday, but that hasn't been my experience and isn't this week. I know we're barely into summer, which technicall…

1
Xp_cmdshell Use Cases 2:43

2M ago2:43

2:43

I had someone ask me recently how to run xp_cmdshell on a Linux version of SQL Server. I told them you can't, as it's an unsupported feature and not one that I expect to see released. I had to double-check, since I did think that supporting a BASH shell was a possibility, but it wasn't added to the product. In the feedback forums, I saw a request f…

1
The Cost of Rework 4:47

2M ago4:47

4:47

I often deal with customers who are looking to improve the way they build and manage database software. These could be small companies or large enterprises, with teams of developers trying to enhance their application software to solve new business problems. Often those enhancements require new data, with the related schema changes in a database. E…

1
What Metrics Do You Collect? 3:39

2M ago3:39

3:39

One of the hot terms in software these days is observability. There are a few definitions (Splunk, RadixWeb), but essentially this is the insight into how your software runs and performs using metrics, logs, traces, etc. In DevOps, we do this with an eye toward improving performance and identifying the root cause of issues. The focus is slightly di…

1
Where to Test Your Code 3:28

2M ago3:28

3:28

The last 10-15 years in software development have seen a widespread embracing of unit testing. Before the popularity of mobile phones and their apps, most of the organizations I'd worked in gave lip service to automated unit testing, and often even more complex integration/system tests. These days, it seems more and more people embrace unit testing…

1
What Do You Want to Learn? 2:55

2M ago2:55

2:55

There are lots of resources for learning: articles at SQL Server Central, blogs, user groups, SQL Saturday and other events, conferences, and more. In most of those cases, the editor, author, or speaker is deciding what they want to write about. If you want to learn something different, you need to go search out that information. You can certainly …

Podcasts Worth a Listen

Sqlserver Podcasts

Podcasts Worth a Listen

Quick Reference Guide