Kendra Little

kendra little

Dear SQL DBA - Advice for Technical Leaders with Alex Robson

Dear SQL DBA - Advice for Technical Leaders with Alex Robson

By Kendra Little on August 31, 2023

Category: career

Ever wondered what it’s like to be a VP or Director of Engineering? I chatted with Alex Robson about leadership in technology, what you can get out of coaching or an MBA program (should you be interested), and what makes a high performing team.

Alex’s site and blog: https://robsonconsulting.services

Continue reading

Msg 195: STRING_SPLIT Is Not a Recognized Built-In Function Name

Msg 195: STRING_SPLIT Is Not a Recognized Built-In Function Name

Yesterday, I was writing some Transact SQL to dust off the cobwebs. I got confused when I was playing around with the STRING_SPLIT function, and kept getting the error:

Msg 195, Level 15, State 10, Line 2
'STRING_SPLIT' is not a recognized built-in function name.

I checked my database compatibility level, which must be 130 or higher for the function to be available. My database compatibility level was 160, so that was fine.

Continue reading

Dear SQL DBA - Performance Tuning with Erik Darling

Dear SQL DBA - Performance Tuning with Erik Darling

By Kendra Little on August 18, 2023

SQL Server performance tuning expert Erik Darling joins the podcast today to chat about how good queries can go bad and how bad queries can get better.

He also answers the question on everyone’s mind: if he was a database, what database would he be?

Continue reading

What To Do When They Are Sure It Was The Database... All The Time

What To Do When They Are Sure It Was The Database... All The Time

It can be tiring to have the database constantly be the Prime Suspect for performance problems.

I’ve had many variations of this conversation over the years:

“Something happened, and we’re pretty sure it was the database. Again.”

Continue reading

Dear SQL DBA: Tech Interviews in 2023 With Jeremiah Peschka

Dear SQL DBA: Tech Interviews in 2023 With Jeremiah Peschka

By Kendra Little on August 11, 2023

Category: career

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

Continue reading

Database DevOps Core Concepts: Migration Scripts

Database DevOps Core Concepts: Migration Scripts

Database migration scripts are a popular and effective way to check database code into version control.

In this post I describe the most common features of popular migration script runners for database code deployment, along with the top gotchas that folks hit when versioning their database code with migrations.

Continue reading

Dear SQL DBA - Data Roles: DBA, DBRE, and Data Engineer

Dear SQL DBA - Data Roles: DBA, DBRE, and Data Engineer

There are lots of jobs for data folks. In this episode, I discuss three hot job titles: Database Administrator (DBA), Database Reliability Engineer (DBRE), and Data Engineer (DE).

Continue reading