Nightmare Moon visits Twilight in the night, and things get biblical.

Featured on Equestria Daily, 1 May 2012.

Meet Spike, Canterlot's greatest private investigator. How great? You've probably never heard of him. But he's had hundreds of cases, big and small. He's tracked down missing ponies, engaged in shoot-outs with smugglers, and almost single-handedly took down the Pastia, the biggest gang of organized crime to date (lawyers, politicians, and academics aside).

But he's put the whole P.I. game behind him, and he's ready to settle into a quiet retirement (or as quiet a retirement you can get in Ponyville). That is until a familiar mare pays him a visit about her sister's disappearance. Armed with with only a loaded CARA. millimeter and his years of experience and cynicism, he calls upon an old friend, a certain wall-eyed pegasus. He soon finds himself embroiled in one of his toughest cases to date, one that has the fate of Equestria resting on the shoulders of everyone's favorite purple and green dragon.

Author's Note: I suffer from an advanced case of Footnote Fever, and so I wrote it with footnotes. I am since discovering that every website doesn't have a good way of doing them. So I'm just making them silvery and putting them right after the paragraph they were in. Sorry 'bout that.

Over the course of a thousand years of monotonous rule, Celestia no longer understands how to connect to ponies, and doesn't bother. But when Twilight Sparkle makes her bombastic appearance, the Princess cannot help be interested.

Featured on Equestria Daily, December 29, 2011

Many years after sending her beloved protege to Ponyville, unease sits heavily on Princess Celestia's heart as her relationship with Twilight Sparkle seems to have cooled despite all they've accomplished together. On the advice of her sister, Celestia sets out to investigate and resolve the lost connection with her most faithful student. What does it mean to be a Faithful Student...or a Princess of the Sun?

Earned a six-star rating on Equestria Daily and featured on its very own TVTropes page!.

Twilight and her five friends are transported during a botched spell, across dimensions to... Ponyville, Equestria? But not the same one that they knew. Sitting on a bench is Harpsy and Babar. The Doctoress avoids apples from an aspiring Applebuck. And in a library across town, six stallions join their forces as they try to decipher the appearance of filly look-alikes of themselves around Ponyville!

Pinkie Pie is visited by a strange customer whilst working at Sugarcube Corner. Hilarity ensues.

A thousand years is quite the generation gap, so Princess Luna decides she has to get with the times. However, this isn't quite as easy as she thinks it will be...

Be Awed and Amazed by the tale of Sweetie Belle as she traverses the multiverse in search of her lost mentor and friend, Twilight Sparkle! Will she find her in post-apocalyptic Equestria? Or maybe in a strange world where everypony is the wrong gender? Or even where a Pony claims to be a human? Read as she journeys through very familiar worlds you might have read about... if you dare!

At this point in time all the main worlds to be visited have already been chosen. Thank you all for the suggestions, and I hope you enjoy the surprises!

Here's the official TSC:F Music Intro: The Sweetie Chronicles: Fragments

WDTP: S2/3-CE
You can also visit the TV Tropes Page which has spoilers!

Twilight Sparkle is a gifted student and scholar. When she attempts to harness her creative side by writing a science-themed sensual romance novel, however, things rapidly get out of hoof. Can her friends stage an intervention before she humiliates herself (and them) at a prestigious literature recital?

No. No, they cannot.

Luna has had enough of Celestia's games, and has found the perfect means of revenge. Using a long-forbidden spell, she transforms her sister into little more than a small filly, all so she could pull the greatest prank ever. Unfortunately, she soon learns that before you fool around with dangerous magic, you really need to read the fine print...

A sequel can be found here.