Dear SQL DBA cover image

Dear SQL DBA

Latest episodes

undefined
Jul 23, 2020 • 28min

3 Things That Shouldn't Be Normal in Database Development

Many people use entrenched processes for database development that have been in place so long that it's hard to imagine doing it any other way. In this episode, I share three things that should NOT be normal for database development-- but which are incredibly common. This episode is inspired by the book, "The Unicorn Project", by Gene Kim.
undefined
Jul 16, 2020 • 14min

Everything I Never Wanted to Know about Collation

I'm not an expert on collation in SQL Server, but there are a few important facts which I've had to learn the hard way. In this episode I share the basics, along with helpful resources to learn more. One small localization correction: the default collation on a SQL Server install will be "the oldest available version that's associated with each specific locale." So if your Windows installation has a different localization than mine (which are generally English USA), then you'll see a different default collation -- but it still won't be the recommended collation for *new* development.
undefined
Jul 8, 2020 • 19min

The Manager's Guide to Git Training for DBAs

Learning Git can be daunting for DBAs. In this 20 minute episode, I discuss why learning a VCS is necessary for DBAs, then give three tips on scoping your project, choosing the right tools, and making sure the project is successful. The cheat sheet I mention in the episode is at https://littlekendra.com/2019/11/27/my-git-cli-cheat-sheet/
undefined
Jun 12, 2019 • 41min

How Do Developers and DBAs Collaborate in a DevOps World?

You're a DBA, and your development team is all-in on doing DevOps, and they want to include the database. Should your DBA team limit the permissions or options for automation? Or should you instead re-think how your two teams work together? In this episode, Kendra discusses DevOps team topologies, the changing role of DBA teams in DevOps, and the opportunities available in creating communities of practice around database development.
undefined
Jan 29, 2019 • 21min

What a Software Evangelist Does - and Where the Job is Going

I've been working as an 'Evangelist' at Redgate for close to six months now, and one question keeps coming up: what exactly does an Evangelist do at a software company? In 21 minutes, I explain the core mission of Evangelists, and why I think being part of the sales process is an important part of the future of software evangelism.
undefined
Jan 17, 2019 • 35min

DBA Jobs: Threats and Opportunities

Threats and opportunities for DBA jobs are explored in this podcast, including the rise of managed instances and automation in the SQL Server world. The chapters discuss the challenges and benefits of managed instances, managing data flow and automation, automating deployments with replicated tables in SQL Server, the impact of digital transformation on IT operations, and the opportunity for DBAs to expand their skills and embrace digital transformation.
undefined
Oct 2, 2018 • 20min

DevOps Terms - and Why They Matter to Database Specialists

In this session, I discuss scrum, continuous deployment, test driven development, DevOps, and related concepts. I close with a quick discussion of why Database Administrators and Developers should care about DevOps.
undefined
Aug 29, 2018 • 23min

Employee Agreements & Contracts - Best Practices

So you've got an employee agreement in front of you: now what? In this 23 minute episode, I talk about practical steps you should take to make sure that you understand the terms of your contract, and how to potentially negotiate the terms.
undefined
Aug 11, 2018 • 31min

Employee Agreements & Contracts for DBAs & Developers - Anti-Patterns

When you take a new job in software engineering or in IT, within the paperwork there often lurks an employee agreement: a contract between you and your employer. In this half-hour live episode we'll talk about why these contracts exist, and multiple anti-patterns you should avoid. This is the first of a two part series. In the next episode, we'll talk best practices for understanding and negotiating the contract.
undefined
Aug 1, 2018 • 20min

Remembering Robert Davis, DBA Hero

What makes a person a DBA Hero? In this episode, I talk about how Robert Davis made a huge impact on the SQL Server community, and the traits that Robert displayed that I hope to emulate.

Get the Snipd
podcast app

Unlock the knowledge in podcasts with the podcast player of the future.
App store bannerPlay store banner

AI-powered
podcast player

Listen to all your favourite podcasts with AI-powered features

Discover
highlights

Listen to the best highlights from the podcasts you love and dive into the full episode

Save any
moment

Hear something you like? Tap your headphones to save it with AI-generated key takeaways

Share
& Export

Send highlights to Twitter, WhatsApp or export them to Notion, Readwise & more

AI-powered
podcast player

Listen to all your favourite podcasts with AI-powered features

Discover
highlights

Listen to the best highlights from the podcasts you love and dive into the full episode