Jeremiah Peschka

Tech interviews are weird and wacky. How did they get this way, and how SHOULD they be? Jeremiah Peschka joins us to discuss.

Tech interviews are weird and wacky. How did they get this way, and how SHOULD they be? Jeremiah Peschka joins us to discuss.

What's up with Tech Interviews in 2023? With Jeremiah Peschka.

There are lots of jobs for data folks. In this episode, I'm discussing three hot job titles: Database Administrator (DBA), Database Reliability Engineer (DBRE), and Data Engineer (DE)  To see the venn diagrams I made for these roles, visit https://catalyzesql.com/sql-comics/

There are lots of jobs for data folks. In this episode, I'm discussing three hot job titles: Database Administrator (DBA), Database Reliability Engineer (DBRE), and Data Engineer (DE) To see the venn diagrams I made for these roles, visit <a href="https://catalyzesql.com/sql-comics/" rel="nofollow" target="_blank">https://catalyzesql.com/sql-comics/</a>

Data Roles: DBA, DBRE, and Data Engineer

I wrote a blog post inspired by Stephen Vakil's excellent suggested interview question, but I inverted it: When should you NOT choose SQL Server to store your data?  My thoughts: * When you don't actually need a database * When you're not using structured data * When you want pure analytics, or something other than a workload involving OLTP * When you need to write to multiple nodes for a single database * When your team wants a PAAS solution (lil pedantic on this, the hosted versions are slightly different) * When your team needs a cheap solution  What do you think? This podcast is available in blog post form:  https://littlekendra.com/2023/06/21/when-not-to-choose-sql-server/

I wrote a blog post inspired by <a href="https://www.linkedin.com/in/ACoAAAJmpYsBLzzbnBLD8ljriaYgHoOLncLTNBY" rel="nofollow" target="_blank">Stephen Vakil</a>'s excellent suggested interview question, but I inverted it: When should you NOT choose SQL Server to store your data? My thoughts: * When you don't actually need a database * When you're not using structured data * When you want pure analytics, or something other than a workload involving OLTP * When you need to write to multiple nodes for a single database * When your team wants a PAAS solution (lil pedantic on this, the hosted versions are slightly different) * When your team needs a cheap solution What do you think? This podcast is available in blog post form: <a href="https://littlekendra.com/2023/06/21/when-not-to-choose-sql-server/" rel="nofollow" target="_blank"> https://littlekendra.com/2023/06/21/when-not-to-choose-sql-server/</a>

When NOT to choose SQL Server to store your data

It's Down Tools Week at Redgate. I share what "Down Tools Week" is, what I'm working on this week, and why I think it's a terrific experience for fostering creativity, innovation, and teamwork. In closing I share some thoughts on variations of this kind of project which you might use in your own organization, whether you are a developer, DBA, or have another role.

It's Down Tools Week at Redgate. I share what "Down Tools Week" is, what I'm working on this week, and why I think it's a terrific experience for fostering creativity, innovation, and teamwork. In closing I share some thoughts on variations of this kind of project which you might use in your own organization, whether you are a developer, DBA, or have another role.

Down Tools Week 2020

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.

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.

3 Things That Shouldn't Be Normal in Database Development

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.

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.

Everything I Never Wanted to Know about Collation

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/

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 <a href="https://littlekendra.com/2019/11/27/my-git-cli-cheat-sheet/" rel="nofollow" target="_blank">https://littlekendra.com/2019/11/27/my-git-cli-cheat-sheet/</a>

The Manager's Guide to Git Training for DBAs

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.

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.

How Do Developers and DBAs Collaborate in a DevOps World?

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.

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.

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

Jobs change over time, and database administrator jobs are no different. In this 35 minute recorded Twitch livestream (my first ever!) I talk about threats to DBA jobs and the related opportunities.

Jobs change over time, and database administrator jobs are no different. In this 35 minute recorded Twitch livestream (my first ever!) I talk about threats to DBA jobs and the related opportunities.

DBA Jobs: Threats and Opportunities

Kendra Little's podcast discussing database performance tuning, software development, and working with data.

Great job presenting numerous topics that as a fellow DBA I find very interesting.

Excellent content for the DBA

This is the best podcast i have come across on SQL Server. Kendra is simply amazing explaining technical concepts of databases/sql and plus she got a great sense of humor! Keep up the great work Kendra 👍👍😊

Best podcast on SQL Server

Dear SQL DBA

You'd love to have a job tuning SQL Servers, but you don't have an environment to practice in. Here's how to teach yourself performance tuning and prepare yourself to land and succeed in job interviews.

You'd love to have a job tuning SQL Servers, but you don't have an environment to practice in. Here's how to teach yourself performance tuning and prepare yourself to land and succeed in job interviews.

Teach Yourself SQL Server Performance Tuning

New to learning SQL Server? Get the scoop on free online resources to look up information, ask questions of community members, and learn SQL Server from the ground up. Links from the episode are at: https://sqlworkbooks.com/dear-sql-dba/training-resources-for-sql-noobs/

New to learning SQL Server? Get the scoop on free online resources to look up information, ask questions of community members, and learn SQL Server from the ground up. Links from the episode are at: <a href="https://sqlworkbooks.com/dear-sql-dba/training-resources-for-sql-noobs/" rel="nofollow" target="_blank">https://sqlworkbooks.com/dear-sql-dba/training-resources-for-sql-noobs/</a>

Training Resources for SQL Noobs

A query is slow, and you figure out how to collect the query execution plan. Now what? In this episode I talk "big picture" about what execution plans are, what "cost" is, why to collect "compiled for" values, and the steps I take to analyze execution plans while performance tuning queries.

A query is slow, and you figure out how to collect the query execution plan. Now what? In this episode I talk "big picture" about what execution plans are, what "cost" is, why to collect "compiled for" values, and the steps I take to analyze execution plans while performance tuning queries.

How Do I Analyze a SQL Server Execution Plan?

Learn the difference between heaps, clustered and nonclustered indexes, primary keys, and columnstore indexes in SQL Server.

Learn the difference between heaps, clustered and nonclustered indexes, primary keys, and columnstore indexes in SQL Server.

Index Types: Heaps, Primary Keys, Clustered and Nonclustered Indexes

Will cloud services render DBAs obsolete? Does the cloud mean that developers will use less of SQL Server? Kendra talks about the future of database administration and gives tips on strategizing your career.

Will cloud services render DBAs obsolete? Does the cloud mean that developers will use less of SQL Server? Kendra talks about the future of database administration and gives tips on strategizing your career.

Will the Cloud Eat My DBA Job?

You're a Junior or mid-level Database Administrator with no obvious career path. How do you grow the right skills to level up your DBA career?

You're a Junior or mid-level Database Administrator with no obvious career path. How do you grow the right skills to level up your DBA career?

How to Level Up Your DBA Career

Find out if getting certified will help you land an entry level DBA job, and if you do want to get certified, get Kendra's tips on preparing for the exam.

Find out if getting certified will help you land an entry level DBA job, and if you do want to get certified, get Kendra's tips on preparing for the exam.

Should I Get Certified as a DBA?

They made their index maintenance job smarter, and their queries got slower in production afterward. Could the index maintenance have harmed performance? In this episode... 00:50 Thinking about plan freezing in Query Store and multi-team process 03:15 This week's question about index maintenance and query performance

They made their index maintenance job smarter, and their queries got slower in production afterward. Could the index maintenance have harmed performance? In this episode... 00:50 Thinking about plan freezing in Query Store and multi-team process 03:15 This week's question about index maintenance and query performance

Index Maintenance and Performance

In this week's episode, I'm not answering a reader's question. Instead, I'm talking about my personal experience with anxiety. This episode touches on on healthcare, religion, and squishy emotions -- and there's at least one curse word. I don't talk tech in this episode. (Don't worry, there's more of that coming in future weeks.)

In this week's episode, I'm not answering a reader's question. Instead, I'm talking about my personal experience with anxiety. This episode touches on on healthcare, religion, and squishy emotions -- and there's at least one curse word. I don't talk tech in this episode. (Don't worry, there's more of that coming in future weeks.)

I Thought I Was An Introvert. Turns Out I Was Anxious as #@*(

You've got some troubling wait stats in SQL Server. How can you tell which queries are causing those waits? Kendra discusses the pros and cons of different techniques to track down the cause of both common and tricky waits in SQL Server, including CXPACKET, PAGEIOLATCH, LCK, RESOURCE_SEMAPHORE, and THREADPOOL waits.

You've got some troubling wait stats in SQL Server. How can you tell which queries are causing those waits? Kendra discusses the pros and cons of different techniques to track down the cause of both common and tricky waits in SQL Server, including CXPACKET, PAGEIOLATCH, LCK, RESOURCE_SEMAPHORE, and THREADPOOL waits.

Which Queries are Causing my Wait Stats?

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.

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.

DevOps Terms - and Why They Matter to Database Specialists

Does your team know what it's doing with SQL Server? Learn what a consultant looks for when assessing a team, and signs that SQL Server may be badly configured.

Does your team know what it's doing with SQL Server? Learn what a consultant looks for when assessing a team, and signs that SQL Server may be badly configured.

Signs Your SQL Server is Running with Scissors

When you're a Junior DBA, it's really hard to take in all the information out there. Learn about write ahead logging: the concept that can help you make sense of recovery models and backup strategies in SQL Server. Kendra tells the story of the "Wow!" moment when she learned about write ahead logging from Kimberly Tripp of SQLSkills.com, and explains how this all works in SQL Server.

When you're a Junior DBA, it's really hard to take in all the information out there. Learn about write ahead logging: the concept that can help you make sense of recovery models and backup strategies in SQL Server. Kendra tells the story of the "Wow!" moment when she learned about write ahead logging from Kimberly Tripp of <a href="http://SQLSkills.com" rel="nofollow" target="_blank">SQLSkills.com</a>, and explains how this all works in SQL Server.

WAL: The concept that makes recovery models & backups make sense

Learn where full-text search shines, a common problem which full-text search does NOT solve, where full-text can run into performance problems.

Learn where full-text search shines, a common problem which full-text search does NOT solve, where full-text can run into performance problems.

Should I Learn Full-Text Indexing?

In this episode, I talk about three articles written by members of the SQL Server community on interviewing that I can't stop thinking about: "Playing the Third Party Recruiter Game", by Adam Machanic - http://sqlblog.com/blogs/adam_machanic/archive/2017/08/08/playing-the-third-party-recruiter-game-t-sql-tuesday-093.aspx "I Hate Interviews", by Rob Sewell - https://sqldbawithabeard.com/2017/08/08/i-hate-interviews-tsql2sday/ "Learning to say 'No'" by Mark Broadbent - https://tenbulls.co.uk/2017/08/08/learning-to-say-no/

In this episode, I talk about three articles written by members of the SQL Server community on interviewing that I can't stop thinking about: "Playing the Third Party Recruiter Game", by Adam Machanic - <a href="http://sqlblog.com/blogs/adam_machanic/archive/2017/08/08/playing-the-third-party-recruiter-game-t-sql-tuesday-093.aspx" rel="nofollow" target="_blank">http://sqlblog.com/blogs/adam_machanic/archive/2017/08/08/playing-the-third-party-recruiter-game-t-sql-tuesday-093.aspx</a> "I Hate Interviews", by Rob Sewell - <a href="https://sqldbawithabeard.com/2017/08/08/i-hate-interviews-tsql2sday/" rel="nofollow" target="_blank">https://sqldbawithabeard.com/2017/08/08/i-hate-interviews-tsql2sday/</a> "Learning to say 'No'" by Mark Broadbent - <a href="https://tenbulls.co.uk/2017/08/08/learning-to-say-no/" rel="nofollow" target="_blank">https://tenbulls.co.uk/2017/08/08/learning-to-say-no/</a>

Interview Advice from the SQL Server Community

Learn why SQL Server 2016 SP1 is a game changer, and how to take best advantage of all the cool features now in Standard and Web Editions.

Learn why SQL Server 2016 SP1 is a game changer, and how to take best advantage of all the cool features now in Standard and Web Editions.

Should I Upgrade to SQL Server 2016?

A few folks have asked: will auto-tuning and adaptive query plans mean the end of performance tuning jobs in SQL Server? In this week's episode, I talk about why I'm excited about those features rather than afraid of them. Digging into this problem, I share the #1 mindset problem I had as a DBA, why this mindset is so common among database professionals, and a daily habit that can change your approach to new technology.

A few folks have asked: will auto-tuning and adaptive query plans mean the end of performance tuning jobs in SQL Server? In this week's episode, I talk about why I'm excited about those features rather than afraid of them. Digging into this problem, I share the #1 mindset problem I had as a DBA, why this mindset is so common among database professionals, and a daily habit that can change your approach to new technology.

Auto-Tuning and the #1 Mindset Problem I had as a DBA

In this episode, I talk about how to strategize for and prepare for Microsoft Certification exams, using the Database Fundamentals exam as an example.

In this episode, I talk about how to strategize for and prepare for Microsoft Certification exams, using the Database Fundamentals exam as an example.

How Do I Prepare for Certification Exams?

As a SQL Server DBA, do you need to be a killer with scripts? In this episode I talk about how much you need to know about PowerShell, and examples of ways I personally use (and struggle with) PowerShell.

As a SQL Server DBA, do you need to be a killer with scripts? In this episode I talk about how much you need to know about PowerShell, and examples of ways I personally use (and struggle with) PowerShell.

Do I Need to Master PowerShell?

The best podcasts about ourselves as well as the world through the lense of Science. Specific topics include things about our brain, emotions to biology, physics and more!

Best Episodes on Science, Humans & The World

The best podcast episodes of the most interesting stories and things. From skyping someone while they're in space, to tracking down and meeting a telephone scammer in person, to the story of a Galapagos. These episodes will keep you and all your friends entertained and captivated for hours. Learn something new in every episode! Add episodes you're interested into your queue below!