Voice Of The DBA podcast

Player FM - Internet Radio Done Right

22 subscribers

Vor zehn Jahren hinzugefügt

Inhalt bereitgestellt von Steve Jones. Alle Podcast-Inhalte, einschließlich Episoden, Grafiken und Podcast-Beschreibungen, werden direkt von Steve Jones oder seinem Podcast-Plattformpartner hochgeladen und bereitgestellt. Wenn Sie glauben, dass jemand Ihr urheberrechtlich geschütztes Werk ohne Ihre Erlaubnis nutzt, können Sie dem hier beschriebenen Verfahren folgen https://de.player.fm/legal.

Species Unite

1
Andrew Stein: Living with Lions 46:39

vor 10 Tagen46:39

Später Spielen

Listen

Gefällt mir

Geliked

46:39

“If we march into that village and we start trying to persecute people for using poison, something that's very illegal, nobody's going to talk to us. We're not going to find out where the poison came from. We're not going to be able to shut anything down. We should take the approach that people are using poison because they're desperate, because they see no other alternative.” – Andrew Stein Andrew Stein is a wildlife ecologist who spent the past 25 years studying human carnivore conflict from African wild dogs and lions in Kenya and Botswana to leopards and hyenas in Namibia. His work has long focused on finding ways for people and predators to coexist. He is the founder of CLAWS , an organization based in Botswana that's working at the intersection of cutting-edge wildlife research and community driven conservation. Since its start in 2014 and official launch as an NGO in 2020, CLAWS has been pioneering science-based, tech-forward strategies to reduce conflict between people and carnivores. By collaborating closely with local communities, especially traditional cattle herders, CLAWS supports both species conservation and rural livelihoods—making coexistence not just possible, but sustainable.…

Voice of the DBA

Serie-Home•Feed

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.

107 Episoden

#Tech #Sqlserver #Steve Jones #News #Tech News #Database

Voice of the DBA

22 subscribers

updated vor 5 Tagen

Serie-Home•Feed

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.

107 Episoden

#Tech #Sqlserver #Steve Jones #News #Tech News #Database

Alle Folgen

Voice of the DBA

1
Database First or Application First 2:48

vor 5 Tagen2:48

2:48

One of the challenges in software development is coordinating database and application changes when one depends on the other. I find many software development teams struggle with this, especially in today's environments when no one wants to take a system offline. While some companies can stage and manage deployments, many of us find our systems need to keep running 24x7 with minimal outages (if any). Lots of you work in environments where your software is changing on a regular basis. Plenty of you will either be developing those changes, or managing the systems to which those changes are deployed. You likely will be coordinating with other people (in either case) to deploy a software artifact (C#, Java, Python, etc.) and a set of database changes in order for your clients to use whatever new functionality is being delivered. Read the rest of Database First or Application First…

Voice of the DBA

1
How Much AI Code Would You Use? 3:18

vor 7 Tagen3:18

3:18

I saw an article recently that a quarter of the Y Combinator startups have 95% of the code in their repos being AI generated . The article notes that if no other startups had any AI generated code (no idea the likelihood here, then about 24% of their code for startups is GenAI written. 24% Is that high or low? If you think about all the code you've written in the last year, how much of it could be reasonably generated by AI? All the queries, schema changes, test code, dummy data insertions, refactoring to add a column to a table or result set. Could it be AI written? Read the rest of How Much AI Code Would You Use?…

Voice of the DBA

1
Part-Time DBAs 2:55

vor 12 Tagen2:55

2:55

Some of you reading this are database administrators (DBAs) who manage systems as their full-time job. Others of you might be developers, analytics people, or someone else who has another job, but you get stuck with managing the database somehow. I've seen a receptionist and a dental hygienist act in this role. We may call you the accidental DBAs, though that doesn't imply you are good or bad at managing databases. I got into this line of work as an accidental DBA who was also a developer. No matter what your job title, my guess is that you aren't over-staffed at your organization. Likely you wish you had one (or more) more person to help keep up with the work. It seems that we never have enough time to get everything done in a week. And that's with a full staff. What do you do when someone is sick or goes on vacation? If you're like me, you get further behind and feel extra stress while your coworker is out of the office. Read the rest of Part-Time DBAs…

Voice of the DBA

1
Using Feature Flags 3:03

vor 14 Tagen3:03

3:03

The use of feature flags in software development has become more and more prevalent over time, especially as teams move to DevOps-style development with frequent releases. I've often thought that using feature flags allows technical people to separate out the deployment of some feature or change from the release of that to users. There are a number of articles on this style of work ( feature flag driven development , Why Use Feature Flags? ) as well as a discussion at Reddit . I am a big believer in feature flags helping with improving your software in many ways. These articles (and others) highlight the advantages that a software organization gains by using feature flags. Failed releases become less of an issue, as the specific change that doesn't work can be turned off. This can even work with databases. I can deploy a database change and at a later time have the code (or new table/column) start being used when a feature flag is set. If there is an issue, I can turn off the feature flag and stop using the code (or populating the schema). I can then clean things up, even saving data before I make a change. Read the rest of Using Feature Flags…

Voice of the DBA

1
A Domain for Data 2:28

vor 17 Tagen2:28

2:28

A domain is a set of possible values (among other definitions). I use this word a lot in my work, often with a problem domain (the thing you're trying to solve) or the domain of possible values (like the US States and Territories list). That last one is interesting, as this is often the set of data we stick in some reference or lookup table to use in a form on a screen. There is a domain as part of the SQL specification, which I never knew about. I was reading an article from Joe Celko on the CREATE DOMAIN statement . This doesn't exist in SQL Server and T-SQL, but it has been a part of PostgreSQL for quite a few versions. The article talks about the definition of a domain from a few very experienced database design people. Read the rest of A Domain for Data…

Voice of the DBA

1
Database DevOps Metrics 3:26

vor 19 Tagen3:26

3:26

The DORA organization is dedicated to helping others build software better and faster, at a higher quality, and in a way that is more efficient. They continue to compile and publish the Accelerate State of DevOps report every year, which is a fascinating read. As a part of the report, they have identified four key metrics that identify high performing organizations in terms of software. These are divided into two areas: throughput and stability. Throughput measures are change lead time and deployment frequency. Stability measures are the change fail percentage and failed deployment recovery time. Read the rest of Database DevOps Metrics…

Voice of the DBA

1
Is GenAI Coming Faster Than You Think? 3:01

vor 21 Tagen3:01

3:01

If you're a fan, no. You're chomping at the bit, waiting to get everyone using GenAI models in their work. If you're skeptical, then you might think it's never coming to take your job, be a personal assistant, help you with coding, etc. Pick the task it won't help you with. A more nuanced view, which is similar to mine, is from Kendra Little, in which she says AI will eliminate DBA Jobs Faster Than You Think , I'm not quite as pro-AI as Kendra, mostly because I see so many companies that are slow to change, slow to adopt new tech, slow to adjust their thinking. They just soldier on and keep running their business, as they've been doing for decades. Even when you might make a case for change, or prove it's worthwhile, they just don't spend the time to change. Read the rest of Is GenAI Coming Faster Than You Think?…

Voice of the DBA

1
The Inefficiencies of Kubernetes 3:19

vor 24 Tagen3:19

3:19

Voice of the DBA

1
The End of SQL Server 2019 3:35

vor 26 Tagen3:35

3:35

Well, not really the end. I doubt anyone running SQL Server 2019 is going to stop (or upgrade) just because mainstream support ended. Actually, I wonder how many of you know that SQL Server 2019 passed out of mainstream support on Feb 28, 2025. I do think the 6 or 7 of you running Big Data Clusters likely knew this was the end of any support. I saw a report in the Register on this, which includes a survey of which versions are still running. This is from an IT asset firm and matches Brent Ozar's Population report . 44% of you are running SQL Server 2019, which is the largest percentage. Since there's an additional 32% of you running versions older than 2019, I'm sure that upgrading isn't a priority. Read the rest of The End of SQL Server 2019…

Voice of the DBA

1
Monoliths and Microservices 3:35

vor 28 Tagen3:35

3:35

Voice of the DBA

1
More Supply Chain Attacks 3:06

vor 4 weeks3:06

3:06

Voice of the DBA

1
Lower Your Attack Surface Area 3:08

vor 5 weeks3:08

3:08

It's no surprise that our systems are under attack by all sorts of criminals. Some organized, some opportunistic, some just aiming for vandalism. We need to protect our digital systems to prevent issues, and a part of better protection is reducing the number of places that are vulnerable. Those places include databases. This article discusses the rising costs of data breaches and the increased frequency of attacks. It also examines the increasing number of regulations that are demanding proof of stricter security measures. It can be hard enough to defend production systems, let alone protecting dev/test environments. I see an increasing number of organizations that limit access to production systems, even to the point that this impedes some of the daily work habits of technology professionals, but that is probably a good thing. Too many of us are too lax when it comes to security. Read the rest of Lower Your Attack Surface Area…

Voice of the DBA

vor 8 weeks5:00

5:00

Voice of the DBA

1
Is Ransomware Fading? 3:30

vor 9 weeks3:30

3:30

Voice of the DBA

1
How Much Linux Do You Need? 2:48

vor 9 weeks2:48

2:48

Voice of the DBA

1
The End of Azure Data Studio 3:14

vor 10 weeks3:14

3:14

I don't know how many of you will be disappointed or impacted by this, but Azure Data Studio (ADS) is being retired, as of 6 Feb, 2024. It will be supported for a little over a year, until 28 Feb, 2026. On one hand I'm not surprised, and on the other, I'm a little shocked by this. I have written a number of articles on ADS , and shown how things work, as well as pointed out a number of things that don't work well in the product or its extensions. These pieces have gotten a number of reads, and people have commented on them, so I wonder if there are a lot of you that are upset by this. Is this going to change the way you work? I will say that it will lightly change my work, as I do use ADS to connect to PostgreSQL, but not so much for SQL Server. Read the rest of The End of Azure Data Studio…

Voice of the DBA

1
Extended Event Comfort 2:11

vor 10 weeks2:11

2:11

Voice of the DBA

1
Unreliable Narrators 2:19

vor 10 weeks2:19

2:19

Voice of the DBA

1
Building a Data Center 3:38

vor 11 weeks3:38

3:38

Voice of the DBA

vor 12 weeks2:54

2:54

Voice of the DBA

1
Can You Become a More Productive Engineer? 3:50

vor 12 weeks3:50

3:50

The short answer is of course, most of us can learn and improve our skills to become better developers, engineers, DBAs, etc. While we might not be able to become the 10x engineer that many aspire to be, we can certainly become a better employee inside of an organization. There's a piece on becoming a more effective engineer, which is actually titled know how your org works . It a piece from an engineer that started with a tweet : The text was: You can either complain and pontificate on Twitter on how the tech industry *should* ideally work, or you can learn how your org *really* works and what’s rewarded, and optimize for that. Or quit and find another job. This might sound cynical - but it’s what it is. That sounds a little harsh, but the reality of how your org works or is structured or interacts is a reality. We all have hindsight to look back and wish someone (including us) had written code better. We might be sure if we could change one thing, or add/remove someone else, or make some other change, then things would be better. We might feel that there is a simple solution. Those things might be true, but they aren't the reality of the situation. Read the rest of Can You Become a More Productive Engineer?…

Willkommen auf Player FM!

Player FM scannt gerade das Web nach Podcasts mit hoher Qualität, die du genießen kannst. Es ist die beste Podcast-App und funktioniert auf Android, iPhone und im Web. Melde dich an, um Abos geräteübergreifend zu synchronisieren.