))
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 sqldatapartners.com/podcast and leave a comment if you have a topic you think we should discuss. We’ll see YOU on the SQL Trail.
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.
This podcast says you about the importance of self -belief Cover art photo by https://www.behance.net/raviroshan
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.
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.
The Ingeniously Simple podcast provides an under the hood look at how we design, build and manage Redgate's portfolio of products. We'll discuss all aspects of our product development process, with insights into how we approach research, design, engineering, product management and delivery; as part of a strong, cross-functional team culture that promotes agility, collaboration and learning.
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
Description: Kendra Little answers burning questions from SQL Server Database Administrators -- from dealing with SAN Administrators to handling index rebuilds, she helps DBAs improve their jobs.
The #SQLFamily is amazing, at least I think it is. Like many families, it's welcoming, supportive, and comforting. It's also maddening, frustrating, and exacerbating at times. Like most families, or at least the ones I know, it's not perfect, but it's what we have and at the end of the day, most of us get along with each other. It's also an open gr…
I saw this article a few months ago, which talks about engineers at Facebook not knowing where their customers' personal data is stored. The engineers were being questioned in a legal matter, where they were asked to definitively state where all personal PII data for any human was stored by Facebook. Their answer was that they didn't think anyone i…
We collect a lot of data in our databases. Not as much in bytes as a lot of the video/audio/TikTok/Instagram sites, but still enough that many of us are constantly adding storage to our systems. All this data is not only a challenge to manage, but it also means that we are regularly dealing with query tuning issues. Better code, indexes, and more b…
It couldn't have happened to a worse set of people, and I'm glad it did, but I'll still take a positive lesson out of this. A hacker sent a typo in a command to a botnet and lost control. That's kind of funny, and I'm glad it happened. The less botnets, the better, IMHO. The coding in this software didn't have good error handling, which is a lesson…
A while back I ran across a blog post that talks about the difference between database snapshots and database backups. There are certainly some similarities and some differences, as well as an overlap in the places where you might choose to use each of these technologies. Both might be useful as a way to recover from a bad code deployment, but both…
We kick off the new year discussing a new feature in SQL Server 2022 called Transact-SQL snapshot backups. Good luck with the Google search on this feature--we know we had fun. 😊 These are not the snapshot backups you were frustrated with in 2005. We talk a little bit about who will be interested in this feature and what scenarios it will come in h…
Many of you reading this probably work primarily in SQL. Even if you are a developer whose main language is something else, you write a lot of SQL. Even if you have an ORM writing the SQL that goes into production, I bet a lot of you are writing queries against a database to check that the data coming back in your application is correct. As for me,…
The pandemic forced many events online, which has worked fairly well inside many companies and certainly spurred some technological advances in how we meet and share information. With the pandemic ending or at least entering an endemic phase, there are many live events now, as well as some attempting to embrace a hybrid philosophy. I went to two co…
S
SQL Server Radio
1
Episode 148 - Rob Sewell and SQLBits 2023
40:54
40:54
Play later
Play later
Lists
Like
Liked
40:54
Today we have the pleasure of hosting Rob Sewell, and talking about the upcoming SQLBits event of 2023! Relevant links: SQLBits 2023 agenda, speakers, pricing, and registration - events.sqlbits.com/2023 YouTube playlist of all 195 sessions from SQLBits 2022 - available for free! SQLBits helpers form - beard.media/sqlbits-helpers Rob Sewell's blog -…
The US was hit with a number of storms over the Christmas holiday weekend. This disrupted air travel for many airlines and their customers, but one of the worst hit was Southwest Airlines. They accounted for most of the cancellations, over half of their scheduled flights at one point. A number of places reported talking with Southwest employees who…
There was an article on the worst technology of 2022 from the MIT Technology Review. I was hoping to get some sense of what was really useful or failure-prone technology, but it seems that the article delves into decisions on how to run technology or policy more than the actual technology. The list is here, with my short comments on those that migh…
The world of technology has undergone an amazing revolution in my lifetime. Things that I thought were incredible in my youth have come and gone in the world. I'm sure that there were dramatic changes in technology across lots of other generations, but I wonder if they were as dramatic for others as they feel for me. As I watch older movies, I'm am…
This is the last workday of 2022. Next week starts a new year, and as I've often done, I wanted to look back at the year. This time I decided to look back month by month, at some of the headlines and memorable data-related topics. I'm tackling things month-by-month. In January there was a set of "tech experts" who shared their thoughts on the best …
This month's T-SQL Tuesday invitation asked about end-of-year operations that you might take on your databases. I don't know how many of you follow any specific end-of-year routine, but you may. However, that got me thinking about an end-of-year career evaluation. It's not something I've done, but I do often look back and forward and build some car…
As we close out the year, we take a look back and think about all those SQL Server 2022 episodes we didn’t record this year—and then make the goal to increase this count in the new year. 😊 We discuss some of the Cardinality Estimation changes in this version and the scenarios in which this may affect other features. I ask Kevin and Eugene what tech…
This weekend is Christmas, and likely many of you are not working hard today and will enjoy a long weekend until Tuesday. There are many other holidays at this time of year as well, and I hope you are enjoying the season with loved ones. I want to take a moment to wish everyone a Merry Christmas and Happy Holiday season. As we come to the end of th…
I expected this to be an article from Glenn Berry. He often tries to convince me to upgrade. I think so he can justify buying his own new hardware. In this case, however, this is a note from Tom's Hardware that it's a great time to upgrade your CPU. The article is a few weeks old, referencing Cyber Monday deals, and it notes that CPU sales are at a…
Ever since I heard about the SQLOS and all the work that went into producing an operating system for SQL Server inside of the host OS, I've thought that perhaps there might be value in specializing the environment for a database platform. Given the importance of databases, especially relational ones, and the need to get every bit of performance out…
It's the holiday season and that means lots of promotions for various items to give as gifts. Black Friday took place recently and I had no shortage of advertisements that I saw for all sorts of things. From computers to televisions to headphones to any sort of tech gadget you can think of. Plenty of other types of gifts as well. One item that kept…
The decision to upgrade database servers can be a complicated one that involves features, costs, and support requirements. While I think many people would love to run database systems for ten years, often there are concerns about support, which effectively ends after five years for SQL Server. While you can purchase extended support, is that worth …
S
SQL Server Radio
1
Episode 147 - Congratulations! It's an RTM!
34:42
34:42
Play later
Play later
Lists
Like
Liked
34:42
Guy and Eitan finally celebrate the generally available release of SQL Server 2022! And also discuss other announcements from PASS Data Community Summit, and also various interesting news and features of Azure SQL announced in November 2022. Relevant links: SQL Server 2022 is now generally available Consumption-based PAYG billing model for SQL Serv…
Time is the most valuable asset I have most days. Time is often a limiting factor that dictates my priorities at work. It also often determines my stress and enjoyment levels in life. Using time effectively can lower the former and increase the latter. A few years ago I read Making Work Visible, which talks about work flow and how time can be waste…
Read the rest of An Amazing Summit
S
SQL Data Partners Podcast
1
Episode 257: The Business of Working for Yourself
39:36
39:36
Play later
Play later
Lists
Like
Liked
39:36
Have you ever thought about working for yourself? It can be very enticing for some, and in this episode, we talk with John Sterrett about the pros and cons of running your own organization. We tackle some of the reasons you might get started and we share some of our experiences of working in our own organizations. Each person’s journey is going to …
Watching the evolution of SQL Server and the Azure SQL Database (ASD) variant has been interesting across the last decade. For a long time, ASD felt crippled compared to the on-premises product. The last few years, however, it seems that ASD is getting features first, which then slip into a release that I can download and run locally. It's a cloud-…
Years ago my son asked me to buy him a copy of The Unincorporated Man. It's a science fiction book about the future, economics, and sentient AI systems. It's the first part of a series of four, and I've enjoyed reading them all. I highly recommend them if you like science fiction. In any case, I was reminded of the series when I saw this article fr…
Artificial Intelligence (AI) systems continue to pervade many industries, usually where there is a lot of data and human developers struggle to build solutions that handle the complexities of the problem. Often the experts in these subject areas can't fully articulate the reasoning behind how and why they use data to arrive at some conclusion. We d…
I saw a customer asking about Exasol recently, which is an in-memory, columnar database. I know nothing about it, and it might work great, but we don't support it. I didn't think much of it, as I'm sure the customer has a reason for choosing this platform. Later, however, I wondered if this was a good idea. Another customer had inquired about Knack…
