Blogs

How to Get Email Notifications for TSQLTuesday

How to Get Email Notifications for TSQLTuesday

on August 21, 2017 • 2 min read

Lots of us want to write for TSQL Tuesday, but aren’t always on Twitter at the right time each month to see when the announcement comes out using the #tsql2sday hash tag. And maybe we have an RSS feed set up, but we often get behind on a big pile of posts to read. (Guilty!)

Continue reading

Recruiters, Nerves, and Saying No in Interviews (video with transcript)

Recruiters, Nerves, and Saying No in Interviews (video with transcript)

on August 17, 2017 • 6 min read

In this episode of “Dear SQL DBA”, I talk about three articles written by members of the SQL Server community on interviewing that I can’t stop thinking about.

Continue reading

Interviewing Patterns & Anti-Patterns: Advice from the SQL Server Community

Interviewing Patterns & Anti-Patterns: Advice from the SQL Server Community

on August 14, 2017 • 5 min read

Category: indexing

Introduction

I’m glad I picked interviewing as the topic of TSQL Tuesday #93, because people wrote posts chock full of great advice and funny stories. Get ready to learn, be amazed, and laugh out loud as you read these posts, which I’ve indexed by the author’s first name. Don’t blame these authors for the dorky jokes in the cartoons, though. That’s all my fault.

Community Contributions

Aaron Bertrand is “looking back at bad interviews.” In the comments, I give a sure-fire way for you to handle any technical interview questions you don’t know.

Continue reading

Do Index Changes Remove Execution Plans from Cache?

Do Index Changes Remove Execution Plans from Cache?

By Kendra Little on August 9, 2017 • 3 min read

When you modify the indexes on a table, SQL Server needs to reconsider how it executes queries that reference that table. But the way this appears when you’re looking at your execution plan cache is far from obvious:

  • Impacted query plans are NOT removed from cache at the time you change an index. The next time the query is executed, it will be recompiled, and the new plan and related execution information will be placed in cache.
  • This is true whether or not the index is used by the query.
  • Even if the index is on columns in the table which are not referenced by the query, the query will recompile on the next run.

To see this in action, you can play along with this sample script.

Continue reading

The Story of an Interview Flop

The Story of an Interview Flop

on August 8, 2017 • 11 min read

Some of the biggest lessons I’ve learned about interviewing come from an interview experience that meant a ton to me – and all my dreams came crashing down.

Continue reading

Running SQL Server in a Docker Container on a Mac

Running SQL Server in a Docker Container on a Mac

By Kendra Little on August 2, 2017 • 2 min read

A user recently asked me what a good use case might be to run SQL Server on Linux in a Docker container.

Continue reading

TSQL Tuesday #93: Interviewing Patterns & Anti-Patterns

TSQL Tuesday #93: Interviewing Patterns & Anti-Patterns

on August 1, 2017 • 2 min read

Welcome to T-SQL Tuesday for August 2017!

T-SQL Tuesday is a chance for you to join in the SQL Server community and write a blog post on a suggested topic. You can use this as a way to start a new blog, dust off a blog you haven’t used in a while, or make it part of regular blogging: your choice!

I would love for you to participate. The whole SQL Server community would. Please, join us!

Continue reading