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.

Spike is a dragon with mare troubles, and one of those mares just happens to be his mother. When he meets Lyra, who has troubles of her own, he hatches a plot that they think will be mutually beneficial.

Special thanks to Setokaiva for his proofing work.
Spanish translation by SPANIARD KIWI can be found here

Collab with The Abyss (Chapters 1 and 2)

Proofread by Neko Majin C and edited by The Abyss (Chapters 3 onwards)

Twilight Sparkle has always ignored Hearts and Hooves Day, seeing it as just another normal day with extra chocolate and the occasional broken-hearted friend to comfort. But when Rarity convinces her that not having a date during the holiday is contrary to proper princess protocol, Twilight rushes to do everything in her power to live up to the expectations presented to her.

There’s just one problem, though: Twilight has never been on a proper date before.

After a few rather disastrous attempts to find a date in Ponyville, Twilight goes to her mentor in Canterlot in a last ditch effort in the hopes of finding the answers she seeks. Princess Celestia, however, may have something more for her than either of them had anticipated.

Days after Tirek's near-takeover of Equestria, The Great And Powerful Trixie travels to Ponyville, intent on settling her rivalry with Twilight Sparkle once and for all. No trinkets to fudge her abilities, no megalomania to apologize for -- just pure and simple magician's honor!

Upon her arrival, however, she quickly learns that the information she has on Ponyville -- and Twilight -- is more than a little dated.

Edits (as well as a bit of scene inspiration) courtesy of nanashi_jones.

Prince Blueblood thought the Grand Galloping Gala was over. He thought he could just go to sleep and put it behind him. He never expected to be reliving the same disaster of a day, over and over... and over.

TV tropes page here:
http://tvtropes.org/pmwiki/pmwiki.php/FanFic/TheBestNightEver

Thanks to all the people who wrote the page and all the people who gave me a little wakeup call and comment to become aware of that fact! You can't see it, but you guys put a real smile on my face tonight.

Also, recently, extra thanks to RD Dash for giving TBNE a thorough editing. I've updated the fic accordingly (7.11.12)

Inexperience is a foreign concept to Celestia. At least she thinks it is. Right up until the moment a rash decision leaves her with a student who is a dozen years younger than what she's used to.

Enjoy.

Octavia is pointed in the direction of Carousel Boutique by a respected colleague. She intends to commision matching uniforms on behalf of her ensemble leader, the esteemed Frederic Horseshoepin. Octavia has misgivings however, when informed that the boutique in question is in Ponyville, a backwater farming town.

Can the proprietor of Carousel Boutique prove to the Canterlot mare that she has what it takes?

This story is a sequel to The Celestia Code

When the monsters created by the dark crystal engine escape their prison, it's up to Princess Twilight Sparkle to deal with them. She gets help and advice from Princess Luna, but things don't go as planned. In fact, when a pony who relies on logic and rationality tries to navigate the stormy seas of emotional entanglement while simultaneously saving Equestria from a horde of evil creatures intent on destroying everything they encounter, nothing goes as planned.
AUDIOBOOK by VisualPony
WARNING: Major spoilers in the comments.

Book 2 of the Alicorn Adventure series.

Goodreads Page
100% Approved by Twilight's Library!

The Badass Twilight tag applies more than ever, but please note the new tags.

This story is a fairly direct continuation of The Celestia Code. You might be able to follow it without having read The Celestia Code first, but it's better if you do.

The sequel is here: The Twilight Enigma

Most excellent pre-reading/editing done by the erudite AcademicPony and the dapper statoose!

Failing once in her attempt to take Canterlot and failing again in her attempt to take down Twilight, one would think Chrysalis would have cut her losses and let things be, but the queen has once again appeared, this time in broad daylight with no disguise and no army. Her weapon of choice? Diplomacy.

Now Twilight is having to deal with the changeling queen, but surely putting up with her antics will be worth the knowledge she's willing to provide about her mysterious race and the potential undiscovered agents still within their midst...right?

Takes place before Magical Mystery Cure and diverges from there.

With thanks to MisterGunpowder for proofreading and editing.

Revision History:

05/09/2015: Chapter 1 updated with millions of little corrections.
05/20/2015: Chapter 2 revised and edited with another million small and large corrections.
06/12/2015: Chapter 3 given a thorough editing and revision.
06/23/2015: Chapter 4 taken to the gutter and edited twice to be sure.
07/14/2015: Chapter 5 thoroughly brutalized with the editing stick.
08/03/2016: Chapter 6 finally edited. Yes, I'm still alive, dammit.
09/29/2016: Chapter 7 fell out of the editing tree and hit every editing branch on the way down.
10/26/2016: Chapter 8 has emerged from the editing emergency room.
11/17/2016: Chapter 9 found and edited. No casualties reported.
11/30/2016: Chapter 10 treated for whiplash after lightning fast editing.
12/22/2016: Chapter 11 edited. Chrysalis shot first.
01/17/2017: Epilogue edited. Time to hit the cider.

Princess Twilight Sparkle discovers a centuries-old mystery hidden in the Royal Archives. Her investigation leads through layer after layer of deception and misdirection, setting her hooves on a path that seems to be leading to a mysterious secret. Along the way, she learns that some friendships can be very, very strange.

Book 1 of the Alicorn Adventure series.

AUDIOBOOK by VisualPony
Featured at the Royal Canterlot Library
TV Tropes Page (Courtesy of Sandtalon)
Goodreads Page (Courtesy of Facedeer)
Equestria Daily Page

WARNING: Major spoilers in the comments. Takes place several months after the end of season four. (Not a Da Vinci Code crossover, BTW!)

Do you see a dark tag? No, you don't. Not dark. Well, okay, there are a couple of dark-ish bits, but that's all. Not enough to warrant a tag. Speaking of tags, there really ought to be "Badass Twilight" and "Friendshipping" ones.

Sequels and side-stories (and more) can be found here Offprint and AO3, and a hardbound two-volume set of all that can be ordered from The Ministry of Image.

My editor for the first edition of this story was Gogito, and I can't thank him enough for all the hard work he did. My editor for the revised version was PresentPerfect, and he did a terrific job of getting the story into excellent shape.