It's over.
The Nightmare is finally over.

There are some things you cannot take back.
The wounds of Eternal Night cut deep in Equestria, in no one more than Celestia herself. Reeling from the painful aftershocks of betrayal and war and grief, Celestia is unraveling. But falling apart now is not an option. Equestria has lost one Princess, it cannot lose the other. There is work to be done, and The Princess of the Day must take on her sister's mantel if they are to survive.

Raise the Moon, Celestia, before the Darkness consumes you...

Shipping in an assistant librarian from Manehattan to run the Canterlot Archive is an unorthodox move to be sure, but Page Turner, fresh off the train, thinks that maybe it's just a sign that she's moving up in the world. Page is crushed when her duties in charge of the prestigious library turns out to be an endless parade of busywork.

But soon Page finds things are not quite as boring as she thought. She receives odd requests for the rarest spell books, and royal visits almost daily. Just when things seem to be looking up Page finds herself plagued by sleepless night, strange noises seeping from unseen corners, and vivid, frightening dreams.

All alone on her first time away from home, Page slowly puts together the pieces of a frightening truth:
Something is terribly wrong in Canterlot...

Dear Princess Dear Celestia,

Today I learned that sometimes how you say something can be just as important as what you have to say. It's easy to forget the true strength of words and all the subtle ways they can bring us closer together or push us apart. It doesn't matter if you're a filly in Ponyville or an Alicorn Princess in Canterlot, words are powerful.

There's still so much to learn about friendship. But I think I'm ready to start.

Your Faithful Student,
Your Friend,
Twilight Sparkle

Twilight just wants to sleep; unfortunately for her, not only is Celestia in a playful mood, but Luna is itching for some quality time. Shining Armor and Cadence then show up, and it turns into tug of war with Twilight as the rope. The prize? Spending quality time with everypony's favorite purple alicorn.

This story has Twilight/Celestia and implied Twilight/Luna. Also, Cadence has a very... vivid imagination.

Now a plotless(okay, so there's a bit of plot. Just a smidge, though.) ball of comedic fluff with multiple chapters.

Chapters currently edited:
Chapter 1 - Say It - edited by ultra1437

On a cold winter's night after Hearthswarming, Twilight Sparkle comes to Celestia with evidence of a terrible historical conspiracy. Celestia responds by teaching her what it means to be remembered.

The earth had belonged to the People since time immemorial, until the ponies came to push them out. For centuries, they have hidden in the forest and the hills, slowly losing ground to their enemies.

But now the gods have chosen two young warriors.

The history of war may be written by the winner, but the Royal Historian is the one who provides the notes and background to the writer. The recent events that some have called ‘Mare Wars’ or ‘The Invasion of the Barracks’ are no exception. The Royal Historian has painstakingly compiled this folder of notes and background material on what should more accurately be called, ‘The Opening of the Guard.’

Please remember to return the folder back to the Royal Historian when you have completed reading, in the event we gather more material that needs to be included.

Musty Pages, Royal Historian

Source for inside photo
Featured on Equestria Daily and the Royal Canterlot Library
With sequel, The Night Guard - Night Mares
And an interview by Benman

Dear Princess Celestia,

I'm sorry I haven't written in a while. Things seem to be falling through the cracks lately. Spike thinks I should go see the doctor, but...

In what could only be described as a stunningly brilliant business venture, Flim and Flam have constructed a carnival of sharks right outside Ponyville. As in, like, literally a Shark Carnival.

With actual sharks.

On actual rollercoasters.

It's going to rock so hard.

Twilight and Dash, upon discovering that the long awaited "Daring Doo 4" movie contains, eugh, Humans, decide to rent out A Nightmare Moon on Elm Street.

Of course all their friends are invited. There is absolutely no way any shenanigans could possibly ensue.

None.