I'm lost, but I don't know where I'm from.
I miss them, but I don't know who they are.
My name is Rainbow Dash, but I don't know who I am, or what happened to me.

And I don't know if I'll ever be the same again.

Editing provided by LoyalLiar, Ruirik, and Mooretis. Cover art also provided by Ruirik.
Russian translation provided by Athlete; you can find it here.

For almost a thousand years, the immortal Nightmare Moon has reigned over Equestria as Empress. To the average pony, Nightmare Moon is an overarching enigma whose rule is absolute and whose wrath is terrible. But to Twilight Sparkle, who as an orphan has never known her parents, the Empress is something else entirely. When the young unicorn is brought under the royal wing as an apprentice, she learns a great deal more about the supposed tyrant than she ever knew. But as Twilight is introduced to life with her new mentor, she is thrust into a world of political intrigue, conspiracies and secrets. Secrets that were never meant to be revealed. As allies and enemies plot against the very peace of the nation, will Twilight fall prey to the perils of her new position? Or will she prosper and find in Nightmare Moon the mother she never had?

============

My eternal gratitude to my editor, LordOfTheWrongs, without whom Night's Favoured Child would not be the story it is today.

Now with added TVtropes!

During an experiment with new magic. Princess Twilight Sparkle suddenly finds herself in a strange new world and in even stranger company.

Kai is your everyday guy. He wakes up, goes to work and then comes home again, a monotonous routine that is his everyday life. That is until a talking, purple horse appears in his apartment. Well… so much for monotonous routines.

The Princess has a secret or two though, perhaps a new friendship will help her forget some old ones?

This story is a sequel to Hard Reset

After the events of Hard Reset Twilight's life and mental well being are slowly returning to normal. Her recovery is cut short, though, when a letter arrives informing her that the time loop spell she cast is causing severe damage to space and time itself. In over her head, Twilight tries to summon anypony who will know how to fix it. The pony she gets is the last one she ever thought she would meet... and nothing like she expected him to be.

Available in Spanish thanks to dgs1993
Series TV Tropes page

Anypony will tell you that Princess Celestia is the most amazing pony in Equestria. She's graceful, she's beautiful, and she always knows just what to say. Her decisions are wise and her manners are impeccable. Some might go so far as to say she's completely perfect.

Celestia has a secret, however. As it turns out, she actually is completely perfect. She's utterly infallible in every aspect. And boy, is she sick of it.

Now she's determined to manage to make just one little thing go wrong.

It won't, of course. After all, she's perfect.

---------
Written for the Equestria Daily Pre-reader battle: April 2013- The prompt was "Celestia's terrible secret- Revealed!" Unfortunately it didn't work nearly as well as I'd hoped, but hopefully someone gets a cheap chuckle out of it.

After Celestia humiliates her at a dinner, Luna storms off and ends up snooping around in her sister's room. There, she stumbles upon the journal Celestia kept immediately after the banishment of Nightmare Moon.

Cover art by bunnish on dA.
This story now has a reading by Craft Arts. Go check it out!
Featured on Equestria Daily on August 22, 2013.

Twilight is invited to Canterlot to compete with some of the greatest magicians in the world for the Moonstone Cup, a prestigious award for the most powerful and skillful magicians, unicorn and otherwise. Can she win? What sort of competition will she face?

Awesome cover image was taken from NoOneBahtim

Shining Armor goes about his usual duty of waking up Princess Celestia. When he hears it's Sunday, a time when the Princess's magic gets out of control when she sleeps, the Captain tricks an unknowing recruit into doing it for him. The recruit tries every means to get to the Princess and wake her up but finds it increasingly difficult, especially when doors are involved.

The Elements of Harmony are defeated and Nightmare Moon stands on Equestria's throne as their new Queen. Is Equestria doomed to suffer through night time eternal or will they be... perfectly fine? Twilight finds her new job as slave or "personal assistant" to her new ruler to be a bit maddening. But is this evil sarcastic queen really as bad as she originally believed? And just how many others are diabolical enough to cash in on the change in staff? Can Nightmare truly run a peaceful Equestria? Let me just answer all these questions right here in the description...

One thousand years later, the mortality-defying guardspony, Warden, has returned to his place at Luna's side. He has traveled a rough path, but he has barely glimpsed the lengths of the longest journey that awaits them...