[Complete! With TVTropes apparently!]
Also, apparently, an animated trailer.

In a world of brass and steam, Twilight Sparkle had thought she had made a life-changing discovery with the invention of the telescope. For better or worse, she was correct.

Now her discovery has not only changed her life, but the lives of those she seeks out in her desperate attempt to contact the only other creature as lonely as Twilight herself.

It all would have been much simpler, but it had to be the one Twilight could only call The Mare on the Moon.

Decidedly not within walking distance, then.

[Featured on EQD before story was meant to be submitted. 4/03/2015]

[Editing team: Southpaw, Wolfvenom, Maskedferret, SwanSong and BluePaladin42, without whom this story would be a fraction of its current state.]
[Special thanks to Novel-Idea for the updated cover]

It's a beautiful day in Ponyville. Then again, every day is a beautiful day for Derpy Hooves.

He could have said no. He should have said no. It would have been the easiest thing in the world to stop her right there and then. She would have understood. She would have forgiven him. The spell would have been gone forever, and everything would have gone back to normal.

But he didn't say no. He didn't, and now it feels too late.

It is the day of the Summer Sun Celebration, and Princess Celestia is coming to Ponyville. Twilight Sparkle is overseeing preparations yet again, and has meticulously planned every last detail to ensure that everything is perfect for her mentor's arrival. Nothing is going to go wrong.

Except when the big day comes, Twilight has gotten four hours of sleep and Fluttershy is nowhere to be found. Pinkie Pie sets off after her with nothing but a dark coat and the voice of a chain-smoking stallion, and the Apples and the Carrots are at each other's throats while Rainbow Dash is attempting to fill in for Fluttershy.

As her plans collapse around her and Ponyville descends into chaos, Twilight Sparkle must focus on obtaining the one thing that can set everything right: the all-powerful, awe-inspiring magic of caffeine.

Six Star Equestria Daily Feature

Description: Returning from Zebrica, Rainbow Dash finds her lot cast in with the brilliant and eccentric detective, Rarity, as they unravel a crime most foul.

Starring Rainbow Dash as Watson, Rarity as Holmes and Fluttershy as Lestrade.

Originally posted on Equestria Daily here: http://www.equestriadaily.com/2011/04/story-study-in-rainbows.html

Spanish translation: https://www.deviantart.com/spaniard-kiwi/art/Un-estudio-en-arcoiris-999961891

Fluttershy has disappeared.

Equestria's most dangerous criminal has escaped.

And a monster from the dawn of time hunts its prey.

Starring Rarity as Sherlock Holmes, Rainbow Dash as Watson and the Great and Powerful Trixie as Dr. Mortimer

This is a sequel to Study in Rainbows, read that first. This is also a re-upload from an old EQD post.

Spanish translation: https://www.deviantart.com/spaniard-kiwi/art/El-perro-de-Villa-Poni-999962740

Siblings are weird.

Twilight, Applejack and Rarity talk about how weird theirs are.

Proofread by Pearple Prose.

Luna and Philomena: a hate affair for the ages.

A thousand years ago, Celestia's pet harrier chases a broken Nightmare Moon through the Everfree Forest. A thousand years later, a much-diminished Princess Luna attempts to feed and take care of the elderly phoenix. In neither case does it go particularly well. Set during Season One, slightly before "A Bird in the Hoof."

Now with a Spanish translation by Spaniard Kiwi!

Applejack mourns the loss of one of the last 67,986 links she had to her dead father.

(Contains spoilers for "Made in Manehattan.")

Audiobook versions:
Scarlett Blade
L1ghtningRunn3r

Now with a Spanish translation by Spaniard Kiwi!

What started as a normal friendly visit ends up taking two ponies on a trip down memory lane that leads them both to realize their friendship began even before Rainbow Dash's first sonic rainboom.