search
LinkedIn
school
Custom Icon

Upcoming Events

My In-Person Events
My Online Sessions
I'm Attending
My In-Person Events
  • SQL in the City – New York – Oct 12 – use code KendraLittle to register for free – Register
  • SQL in the City – London – Oct 18 – 50% off registration with code KendraL – Register
  • SQL in the City – Chicago – Oct 26 – use code KendraLittle to register for free – Register
  • PASS Summit Preconference Training Day – Prevent Fake News in Your Data – Seattle, WA – Nov 5 – $499 or bundled with conference – Register – Perks
My Online Sessions
  • Learn Indexing By Solving Problems – Sept 24-25, 8AM-12PM PT – $249 – Register
I'm Attending
  • SQL Server with Docker Containers – Oct 10, SQL PASS WIT Virtual Group – Marsha Pierce – Register

New Free Webinars! Index Tuning, Free Q&A, and Isolation Levels

Kendra Little
No Comments
I’ve got a whole slew of free webcasts and events coming this spring. I’m excited about each and every one of them! My next event is a free session sponsored by IDERA software on index tuning. For this event, you register on IDERA’s site: Mar 21 – Why Did My Clever Index Change Backfire? (Geek Sync with IDERA) Register here! After that, I’ll be doing webcasts, plus a Q&A session with the Professional Association for SQL Server using Facebook Live. Mar 22 – Configuring MAXDOP Mar 27 – PASS Facebook Live Pop-Up Q&A Session Apr 5 – Configuring Cost Threshold Apr 26 – Snapshot Isolation on AG Secondaries May 10 – Read Committed is Bonkers (repeat showing) May 24 – RCSI & Snapshot Isolation (repeat showing) Sign up here (and grab a calendar download for the Q&A session. Hope to see you at these events!
Read More

Overheard: “I just think there’s not that many women who enjoy coding. And I say that based on my daughter, too.”

Kendra Little
130 Comments
I’m at the Microsoft MVP Summit in Redmond, Washington this week. This is a great event for learning from the folks building amazing new technology at Microsoft, giving feedback and representing the community, and meeting and learning from other MVPs from around the world. This is a week of optimism and inspiration and thinking about possibility. But this morning I got a reminder of the mindsets and assumptions that limit this possibility. That squash that inspiration. That make people, particularly women, think, “tech isn’t for me.” This post is an exploration of a comment that I found surprisingly “squashing.” This post isn’t about shaming any specific people (nobody is identified except for me), it’s about exploring my own beliefs and biases that led this comment to have such power over me. Writing this was part of my personal process of defusing those beliefs and biases. I slid into breakfast slightly behind…
Read More

Using YouTube Captions & Transcript to Find Content in a Long Video

Kendra Little
No Comments
This week, I was pretty pumped to see that PASS published Erin Stellato (twitter) and Dejan Krakovic’s (linked in) excellent session on Query Store to the public. I attended this session live at the conference, and I remembered that there was one specific part on memory limits in Query Store that I wanted to watch again. I’d jotted down a note about it, but things were flying by and my note was gibberish. The recording is 75 minutes long, and it’s a great session, but I wanted to just find this one part at the moment. However, I couldn’t remember if the comment was early or late in the session. Transcripts to the rescue! Transcripts are kinda hard to see in YouTube, and I only discovered them when I was playing around with YouTube in the process of captioning my own videos. To open transcripts, I had to click on…
Read More

How I Accidentally Found a Passion for Plants (#TSQL2sDay 99)

Kendra Little
6 Comments
For  TSQL Tuesday #99,  @AaronBertrand gave us an invitation to write about something we’re passionate about outside of SQL Server. As a community we spend a lot of time digging into nerdy topics, which is fun, but I think it’s interesting to find out what people are involved in. I used to think I couldn’t grow plants I went to the kind of college where students often grew plants. That’s not a metaphor for growing pot. Quite a lot of my fellow students were into gardening and liked to grow houseplants in the dorm. But I couldn’t even keep an air-plant alive. (It turns out they don’t just live on air. I had no idea.) After a couple of failed attempts at indoor gardening, I gave up. I realized our home was not very … lively Got extra tech mugs? Perfect outer liner to grow herbs in. I picked up this oregano at…
Read More
Text to be formatted

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

Kendra Little
No Comments
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. Ever since I started working with data, I’ve occasionally had to format raw text files for a variety of reasons. Sometimes it’s a one-time import to a database system, or a one-time analysis. Often it’s not directly related to a database at all, but it’s part of a business process. I first learned about regular expressions when formatting a large data file: I needed to remove line endings, and regular expressions were the answer. Throughout my career, those regular expressions have come in handy. I need them just often enough that I can usually get the job done after a bunch of missteps and cursing. These days, I use a series of…
Read More

WordPress: Create a Sidebar List of Parent/Child Pages

Kendra Little
No Comments
Recently, I wanted to create a list of pages for a custom WordPress sidebar. Specifically, I had a “parent” page, sqlworkbooks.com/free-sql-server-quizzes. Under this page, I had more than 30 individual quiz “child” pages, each with a URL like this: sqlworkbooks.com/free-sql-server-quizzes/quiz-batch-mode-in-sql-server I wanted: A sidebar list of selected child pages (clickable URLS) The ability to show the sidebar page links only on the parent and child pages (not on the whole site) The ability to group the links and change the names The ability to add / remove links from the sidebar without having to un-publish or delete the page In the past, I’ve used the PageMash plugin for this Long ago, in a WordPress install far away, I used the PageMash plugin for organizing and managing lists of page links like this. But PageMash is one of those plugins that hasn’t been updated in (checks watch) nine years. I thought about it a little…
Read More
Menu