Conversations between DBA'S is the perfect podcast for DBA'S and especially those who use Microsoft's Data Platform. The podcast is moderated by Guy Glanzer and Eitan Blumin, Microsoft MVP'S, who have years of experience, and a lot of passion for the field, you will hear it yourself (: -The podcast is in Hebrew-
…
continue reading
A series of episodes that look at databases and the world from a data professional's viewpoint. Written and recorded by Steve Jones, editor of SQLServerCentral and The Voice of the DBA.
…
continue reading
This podcast says you about the importance of self -belief Cover art photo by https://www.behance.net/raviroshan
…
continue reading
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.
…
continue reading
Hosted by Carlos L Chacon, the SQL Data Partners Podcast focuses on Microsoft data platform related topics mixed with a sprinkling of professional development. Carlos and guests discuss new and familiar features and ideas and how you might apply them in your environments. Visit our website for episode show notes at marathonus.com/podcast and leave a comment if you have a topic you think we should discuss. We’ll see YOU on the SQL Trail.
…
continue reading
Kendra Little's podcast discussing database performance tuning, software development, and working with data.
…
continue reading
Each episode Chris and Chris will be discussing topics and news from the world of SQL Server, while enjoying and chatting about beer! So, grab yourself a beer and tune in, cheers.
…
continue reading
Our podcast includes both technical & non-technical discussions on BigData, DataScience, BI, AI, DW, Business Intelligence, TDWI, SqlServer, SQL, NoSql, AWS, Azure, R, Python. Hosts: Rajib Bahar, Shabnam Khan
…
continue reading
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…
…
continue reading
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…
…
continue reading
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…
…
continue reading
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…
…
continue reading
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…
…
continue reading
![Artwork](/static/images/128pixel.png)
1
Episode 166 - DR Planning for SQL Server and Loading Large CSV Files
35:32
35:32
Play later
Play later
Lists
Like
Liked
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…
…
continue reading
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 …
…
continue reading
גיא ואיתן מדברים על העולם המופלא של הנעילות ב-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 …
…
continue reading
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…
…
continue reading
![Artwork](/static/images/128pixel.png)
1
Episode 278: Running SQL Server on Azure VMs
1:04:29
1:04:29
Play later
Play later
Lists
Like
Liked
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…
…
continue reading
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…
…
continue reading
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…
…
continue reading
![Artwork](/static/images/128pixel.png)
1
The Biggest Database Professional Challenges Today
2:22
2:22
Play later
Play later
Lists
Like
Liked
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
…
continue reading
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…
…
continue reading
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 …
…
continue reading
![Artwork](/static/images/128pixel.png)
1
Episode 277: PostgreSQL for the SQL Server Crowd
1:02:29
1:02:29
Play later
Play later
Lists
Like
Liked
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…
…
continue reading
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…
…
continue reading
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…
…
continue reading
![Artwork](/static/images/128pixel.png)
1
Episode 165 - News in Azure SQL and Woes of Excel
38:44
38:44
Play later
Play later
Lists
Like
Liked
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…
…
continue reading
מכירים את רדיו SQL SERVER? תכירו את שיחות בין DBA'S! הפודקאסט שלנו עבר מיתוג מחדש, ואפילו צולם לראשונה(: על מה דיברנו? קצת על המהלך, על הקהילה, על Tempdb,אינדקסים ושיפור ביצועים ועוד. קישורים לערוצי הקהילה
…
continue reading
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 …
…
continue reading
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…
…
continue reading
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…
…
continue reading
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…
…
continue reading
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…
…
continue reading
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…
…
continue reading
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 …
…
continue reading