Kendra Little

kendra little

New SQLChallenge: Defuse the Deadlock

New SQLChallenge: Defuse the Deadlock

When I first created SQLWorkbooks, I distilled what it was all about down into one sentence: “Learn SQL Server by Solving Problems.”

This month, I introduce my first SQLChallenge, which distills that down into practice. The SQLChallenge features 23 minutes of video with scripts that you can use to reproduce and solve the problem yourself.

Continue reading

Formatting a VTT Caption File into a Transcript with Sublime Text and Multiple Regular Expressions

Formatting a VTT Caption File into a Transcript with Sublime Text and Multiple Regular Expressions

By Kendra Little on February 8, 2018

Category: career

Do you ever need to use a text editor to apply regular expressions to files? If so, this post is for you! If not, you may wanna skip it and just return to it if you ever need it.

Continue reading

Does a Clustered Index Give a Default Ordering?

Does a Clustered Index Give a Default Ordering?

By Kendra Little on February 2, 2018

I recently got a great question: if I order by a column where all rows in that column have the same value, will SQL Server then order the results by the clustered index key?

Continue reading

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

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

A few folks have asked: will auto-tuning and adaptive query plans mean the end of performance tuning jobs for 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.

Continue reading

I Thought I Was An Introvert. Turns Out I Was Anxious as #@*]  (Dear SQL DBA Episode 53)

I Thought I Was An Introvert. Turns Out I Was Anxious as #@*] (Dear SQL DBA Episode 53)

By Kendra Little on November 8, 2017

Category: career

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.)

Continue reading

New Free Webcasts for November and December 2017

New Free Webcasts for November and December 2017

By Kendra Little on September 28, 2017

I’ve Just Scheduled a Whole Batch o’ Free Webcasts!

Webcasts are held on Thursdays at 9 AM Pacific / noon Eastern / 4 pm UTC.

Here’s the upcoming slate of topics:

  • Oct 5 – RCSI and Snapshot Isolation
  • Oct 19 – Pressure Testing Memory
  • Oct 26 – What’s REALLY in That Index?
  • Nov 9 – Filtered Columnstore Indexes
  • Nov 16 – Defragging: Reorg or Rebuild?
  • Nov 30 – In-Memory Indexes & Isolation
  • Dec 7 – Indexing for Windowing Functions
  • Dec 14 – Serializable & Repeatable Read

I can’t wait to put together these presentations, and I hope to see you on Thursdays!

Continue reading

Do I Need to Master PowerShell?

Do I Need to Master PowerShell?

By Kendra Little on September 12, 2017

As a SQL Server DBA, do you need to be a master of PowerShell scripts?

In this 9 minute episode, I talk about how much you need to know about PowerShell, and examples of ways I personally use (and struggle with) PowerShell.

Continue reading