Both of them searched for purpose during their lives. Both of them were puppets designed to kill and manipulate. Both of them encountered a single individual that taught them the meaning of life. And then they passed away. One was a villain determined to destroy everything. The other was a child looking for security in his limited life. They found themselves blessed to have a second chance in a new world.
They were blessed to be able to live again…

An ordinary afternoon at Canterlot's Summer Sun Faire becomes extraordinary when a young filly gets too curious and Princess Cadence experiences every foalsitter's worst nightmare. This is how one Princess discovered there is more to Twilight Sparkle than she ever imagined, and realized she is truly anything but "a regular old unicorn."

EDIT: Featured on Equestria Daily on 12/31/12. It's a New Year's miracle!

There was a question... and Spike wanted the answer. The curiosity of it was gnawing at his little dragon brain like gerbils in a vat of candy corn. In desperation, he turns to Cadence for help, and she's more than happy to assist.

After all, it's just a simple question. What's the worst that could happen?

(Takes place prior to Season 1. Rated for scattered innuendo.)

Some Canterlot entertainers aren't just musicians... and some ponies fall in love with them anyways.

When one of Equestria's most popular cellists appears at Twilight's birthday party, it's just another gig for Octavia, but a shock for Twilight and the rest of the party-goers. She arrives, wishes Twilight a happy birthday, wows them with her beautiful music, wows them with her musical beauty, and doesn't leave until after everypony else has left. So when a few ponies suggest that this 'entertainer' might be more than just a musician... some eyebrows are raised, but nothing more. Twilight is beyond reproach, after all, and Octavia can earn her living however she wants. When she sticks around Ponyville, however, it becomes a slightly different story - Twilight is romantically-naive, after all, and Octavia is... most certainly not.

The romance of Twilight Sparkle, Celestia's protege, and Octavia van Clef, Canterlot's most famous entertainer.

Rated 'Teen'. Per FimFiction's rating guidelines, this story contains some 'more adult themes', but has no 'graphically adult content'. Rated primarily for sexually suggestive material, but also (in later chapters) alcohol use and adult language.

Although she is ashamed to admit it, Rainbow Dash sleeps with a Spitfire plush. But that gets her thinking...what would it feel like to cuddle with another pony instead of a doll? Now she is determined to seek out her friends and find out.

Duke Pantarei, the Hero of the Great War.

His goal was to save the world, but perhaps his method was the wrong one.
He had been willing to sacrifice humanity for the sake of the planet, but in the end his strength wasn't enough.

So he gave the humans one final chance, but something strange happened in the process.
This place...it can't be Terca Lumireis...can it?

Tales of Vesperia crossover.
No knowledge of the game is really needed, but it would help if you at least read Duke's wiki profile or something.

When Twilight Sparkle attempts to turn herself into an Alicorn for a day, a freak accident causes the spell to mess up. How will Equestria handle thousands of Alicorns?

Thanks to Syntactics for the amazing cover art!

Commander James Bond was one of MI6's top operatives. Having succeeded in countless missions and bringing down international terrorists such as Le Chiffre and Dominic Greene, Bond is sent to Istanbul to retrieve a hard drive containing the names of every agent involved in undercover affairs. The hard drive in question has fallen into enemy hands, and it's his job to get it back.

After disastrous events in Istanbul during the mission, James finds himself in an unfamiliar land, and soon becomes entangled in a tale of international espionage.

Only one man can protect Equestria and its princesses in this new time of crisis, and his name's Bond.

James Bond.

A sequel has been published: An Equestrian Princess in London.

This story is a sequel to Aitran

Twilight and Rainbow are asked by Star Swirl the Bearded to take on the challenge of finding his lost wife and daughter in the decaying world of Sohndar, which is ruled by an old enemy of Star Swirl's family who has been trapped there for uncounted years. Although their adventures in the worlds of Aitran have given our heroes the confidence to succeed, they'll soon find that Sohndar is an entirely different bale of hay.

Image by Muffinsforever

Strange discoveries. Mysterious twitching. The curious feeling of being watched. And a sudden urge to sing. Something's happening to Applejack, and no matter how often she laughs, this is no laughing matter!