The End of an Era – SQLFool scripts are now open-sourced

Hello, dear readers. It’s been a while.

For those who haven’t yet heard the news, I have switched to the dark side roles. I’m still kicking ass at GoDaddy and I’m still technical, but I now lead a team of big data engineers. As you can imagine, this means that I spend the majority of my time with Hadoop and its related ecosystem (Pig, Hive, Spark, etc.). This is very different than the performance-focused SQL Server role I had when I first created this blog. For those of you who make your living primarily or solely with SQL Server, please rest assured… SQL Server is still awesome, is still relevant, and still has a place in most enterprise data platform strategies. In fact, I’m presently working on egress automation of our Hadoop data warehouse to SQL Server for serving BI reports. Unfortunately, my change in technology focus means that my SQL Server blogging has largely come to an end, and with it, new posts on this blog. But while this blog may end, my blogging activities do not. For those interested, I have launched a new blog at Hadoopsie.com that chronicles my adventures in a non-Microsoft world with Hadoop, open-source, and development on a Mac. :)

But back to the reason for this post. Recently, I saw a trackback comment from SQLBlimp that listed my index defrag script as #3 on its SQL Server Helpfulness Hall of Fame. This filled me with mixed emotions; while it made me happy that the script has been so helpful to so many people, I couldn’t help but feel sad because I knew I would no longer be keeping it updated. I have spent countless hours on this script, which has won numerous awards and has been mentioned in blogs, presentations, online publications, & books. It’s also still extremely popular; I stopped paying attention to its metrics when it broke 100,000 downloads 3 years ago. Similarly, I’ve been surprised to observe that sqlfool.com, which broke 1 million visits in April 2014, now receives more web traffic today than it ever did at the height of my blogging activities.

For this reason, I have made two decisions. First, I will keep this blog online so that people can continue to stumble across blog posts that, while a couple of years old, are still largely relevant.

Secondly, I have decided to open source all of my SQL Server procedures & scripts on GitHub. I haven’t yet had a chance to upload all of my scripts, but I started with the most popular ones (based on traffic stats). These scripts are available in a single repository to make downloads easy. And, if you are so inclined, feel free to contribute back to the repo. For the index defrag script in particular, I have some automated regression tests that I can run against any pull requests to aid in merge approvals.

One final comment. This may be the end of my SQLFool era, but I hope to maintain the friendships I’ve made along this incredible journey. I wholeheartedly believe that the SQL Server community is the best damn technical community in the world. Thank you ALL for your camaraderie, friendship, help, support, and awesomeness. Keep kickin’ ass, my friends. :)

Love,

Michelle

Tagged , , , , , , , , . Bookmark the permalink.

10 Responses to The End of an Era – SQLFool scripts are now open-sourced

  1. Its great to see people in the SQL Community adopting an open source license for their stuff and using github. Will you be taking pull requests from people who modify your scripts?

  2. Jess says:

    End of an era indeed! I’m sure hadoopsie will be awesome too! Keep truckin’!

  3. Jess says:

    Also it’s super cool that you open-sourced all of your SQL scripts. I’m going to share this with some of my coworkers tomorrow.

  4. Very cool. I’m sure your Hadoop blog will be just as valuable to the community as this one is.

  5. Absolutely, Justin! That’s really a big part of why I moved everything to GitHub. I have automated regression tests I can run against any pull requests to that the core functionality works and to ensure backwards compatibility. :)

  6. Thank you, Jess and Lance! :)

  7. Thanks for everything over the years Michelle. You’ve always been awesome. Now you’ll just be awesome somewhere else.

  8. Greg Sohl says:

    Great of you to put these on GitHub Michelle. Good call!

  9. Nice to see you’re out getting it done as usual! Congrats to you Michelle!

  10. Gabriel Cuevas says:

    Thanks for all your help.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>