Twilight Sparkle has too much magic, and it will take her decades to learn to control it. Her spectacular loss of control during her entrance exam only proves that fact. She is a danger to herself and others.

After Sunset Shimmer’s disappearance, Princess Celestia needs a new student to bear The Element of Magic to defeat Nightmare Moon. With all of Equestria at stake, Twilight Sparkle…is not the pony she needs.

Princess Celestia seals Twilight Sparkle’s magic with the distant promise of one day teaching her.

But there are two diarchs of Equestria. Amidst a lucid dream, an offer is made.

“Hello, Twilight. Would you like to be my student?”

Cover art provided by Lafiir.

While visiting Canterlot with Limestone, Marble runs into an energetic pony who could match her twin in cheerfulness. And she's cute. And wants to talk to her. And cute.

Naturally, Marble explodes from shyness.

Pre-read by: Timaeus
Ch. 1 Audio Reading by TheCaptainSand - Scarlett Blade

[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]

Twilight's caught a special type of flu, and it's up to none other than Princess Celestia to nurse her through it. A special, tender little moment follows in this most unexpected of circumstances.

This story is a sequel to Upheaval: Reckoning

Equestria's fragments have reunited, and the power of sunlight shines once more within Celestia. With the remnants of the Old Kingdom destroyed, the Abyssal Throne sent away, the threat of Gravitas defeated, and Black Rose no more, Equestria now faces the encroaching darkness of Oceanus and his rebels.

But the stage is not yet fully set. Twilight Sparkle and her friends must gather what means they may before the battle is joined.

Cover art provided by Captain Nibbles

This story is a sequel to Upheaval: Breaking Point

Following the events of Breaking Point, Twilight Sparkle and her friends discover that Equestria's demise may not come from an enemy invasion, but from within. The Barrier Lands and the Heartland begin the slow and uneasy process of reuniting into a single Equestria, but this long-delayed joining is already in danger at its conception.

With Celestia's power in her grasp and her agents by her side, the wheels of Black Rose's plans for Equestria's future continue to turn. However, her brazen gamble has done more than just bring down a centuries-old barrier. Ancient powers begin to stir: the remnants of a dark period in Equestria's history, the immortal inhabitants of Celestia's homeworld, and a rising tide of darkness coming ever closer.

A breakfast conversation between the princesses turns toward Celestia's long history of losing fights.

This story is a sequel to The Age of Wings and Steel

Tyria Metrel, an ensign assigned to the Equestrian embassy in the island city of Zyre, has her hooves full dealing with pirates and bad-tempered politicians. On top of that, a new ambassador named Rye Strudel has arrived on a mission from Princess Celestia, and he might well be the strangest pony she's ever met. Ambassador Strudel is a pegacorn, one of the rare crossbreeds unable to fly or do magic, but Tyria soon learns that his disabilities don't prevent the ambassador from getting himself into deep trouble.

Rye's cheerful curiosity and drive begin to stir up feelings Tyria thought she'd given up on—when he's not making her tear her mane out in frustration. After the two of them stumble upon a treasonous plot to seize control of Zyre, they'll have to work together to foil an old enemy, save the city, and maybe even find love along the way...

... provided they don't drive each other crazy, first.

To Twilight Sparkle and Princess Celestia, it is a simple surprise visit to Canterlot. To the ponies of the Equestrian Civil Service, it is twenty-four hours of chaos, politics, weaponized dessert, politics, underhooved manipulation of media, politics, and things batrachian and tentacular. Who said bureaucracy isn't exciting?

Twilight's latest creation was meant to allow them a glimpse of civilizations not of their world. What they hear however, is more saddening, beautiful, and inspiring than they could have imagined.

Ponies picking up human transmission story for fun. Hope you enjoy.