Blogs

Dear SQL DBA: Remembering Robert Davis, DBA Hero

Dear SQL DBA: Remembering Robert Davis, DBA Hero

By Kendra Little on August 2, 2018 • 1 min read

What makes a person a DBA Hero? In this episode, I talk about how Robert Davis made a huge impact on the SQL Server community, and the traits that Robert displayed that I hope to emulate.

Continue reading

SQL Operations Studio: Keyboard Shortcuts, Actual Plans, & More

SQL Operations Studio: Keyboard Shortcuts, Actual Plans, & More

Last week I posted a quiz on SQL Operations Studio, a free, multi-platform tool from Microsoft..

This tool is under active development and the features are improving by the day – which makes it a great time to start trying out the tool and see what you like: because you can suggest changes!

Continue reading

Changing Your Highlight Color in SQL Operations Studio

Changing Your Highlight Color in SQL Operations Studio

By Kendra Little on July 25, 2018 • 3 min read

I’ve been enjoying working with SQL Operations Studio lately - a new, free, cross-platform editor from Microsoft.  The tool is under active development and it’s a great time to try it out and suggest changes for how you’d like to see the product work. (Here’s a suggestion I made this week, for example.)

Continue reading

CROSS APPLY in T-SQL: Why to APPLY

CROSS APPLY in T-SQL: Why to APPLY

By Kendra Little on July 24, 2018 • 5 min read

Michelle asked a great question:

In your own words, why would one want to use a cross apply operator rather than a join operator? I’m old school, and I’m just not getting why a cross apply would be so much better to use than a join.

Continue reading

Dear SQL DBA: Why I Rarely Mention Service Broker

Dear SQL DBA: Why I Rarely Mention Service Broker

By Kendra Little on July 19, 2018 • 1 min read

I’ve gotten a few questions about whether I recommend learning Service Broker, and recently I was asked if I’m planning to make any courses on Service Broker.

About This Episode

In this 23 minute episode, I talk about why I personally haven’t become an expert with Broker, the factors that I believe play into Service Broker adoption, and other resources online for learning Service Broker in SQL Server.

Continue reading

The BREAK Keyword in Transact SQL

The BREAK Keyword in Transact SQL

By Kendra Little on July 16, 2018 • 3 min read

BREAK is a useful piece of control-of-flow language in SQL Server, but it only works in specific situations.

Continue reading

What the Microsoft MVP Award Means to Me in 2018

What the Microsoft MVP Award Means to Me in 2018

By Kendra Little on July 11, 2018 • 7 min read

Category: career

I recently received my seventh “Most Valuable Professional” award from Microsoft. Oddly, I don’t think I’ve ever written about what this award means to me until this point.

Continue reading