About the Author

(Warning: shameless self-promotion ahead)

Who am I? Good question. I’m a wife, and I’m a mother. I’m also a SQL Server database developer, Microsoft SQL Server MVP, published author, accomplished presenter, and self-proclaimed scripting junkie.

I have been happily employed at Go Daddy since July 2007. I specialize in performance tuning and high-volume VLDB (very large database) development, although my experience at Go Daddy has also included database automation, operational predictive analytics, and all stages of the data lifecycle—from OLTP to data warehousing.

Aside from my family, SQL Server is my passion. I founded 380PASS, a SQL Server user group in Eastern Iowa. I also organized the first ever SQL Saturday for Iowa and continue to contribute to the annual event. Most recently, I’ve had the priviledge to co-author SQL Server Integration Services Design Patterns with an amazingly-talented group: Andy Leonard, Matt Masson, Tim Mitchell, and Jessica Moss. I frequently presents at user groups, code camps, and conferences—including PASS Summit, the largest SQL Server and Business Intelligence conference in the world.

I do not profess to be an expert. The SQL Server platform is constantly evolving, and there is always more to learn. My goal for this blog is to share some of what I learn—often the hard way!—and my love of scripting. If you learn something new or use one of my scripts, please leave a comment saying so. Some days, comments and coffee are all that keep this blog going! ;)

As I mentioned before, I’m also a mom. I have two amazing kids: a 2-year old and a 11/11/11 baby. As you can imagine, this has significantly cut into my blogging time! It also means I often look like a zombie at user groups and conferences. So if you happen to see me at one of these events, please come up to me and say “hi.” If you offer me a cup of coffee, I may even hug you. :)

Thank you for taking the time to learn a little bit more about me!

@SQLFool
michelle at sqlfool dot com

0saves
If you enjoyed this post, please consider leaving a comment or subscribing to the RSS feed to have future articles delivered to your feed reader.

17 Responses to About the Author

  1. Pingback: SQL SERVER - Automated Index Defragmentation Script « Journey to SQL Authority with Pinal Dave

  2. Royce Blanks says:

    Michelle, I really appreciate your defgra script. I just found it and you did an awesome job! I have the same desire as Nedrik. I would like to be able to let the script figure out if the next index can be completed within a certain time threshold or otherwise not get started. I work for a large bank and the green windows are strict. If you have an update to this since it was posted in May that would be great.
    By the way, I am very interested in your comments about Ola’s defrag script and how it might compare. I would appreciate an expert opinion from you on his complicated script for defragging. Some of your and his scripts have elements that are beyond my current knowledge so I appreciate any insight. thanks!

  3. peter says:

    It looks like I started developing the first website using HTML and notepad in 1997. I remember back I had to use CompuServe with connecting speed at 1600 baud modem in the 90s.

  4. Bryant says:

    Passion trumps guru any day. I learned classic ASP when Visual Interdev first went gold and wrote the first data-based application in my company using SQL Server 4.2.1. Most of what I needed was packed away in gray matter from working on another platform. I jumped in and never looked back.

    20+ years on with SQL server and I am still fascinated by how it works and what I can accomplish. Keep the passion. It is more fun. Guru just gets you called at 2 am. :-)

  5. Rich says:

    Michelle, thank you for including me as part of your test group for the ParseString UDF, and this fantastic PROC to defrag anything in it’s site that qualifies by threshold! I – much like you – have a deep passion for anything SQL, but am a bit of a newbie to the role of DBA. I love it! :)

    We have SQL Saturday (on a Friday no-less) out here in the Twin Cities, this coming fall. You should come and it would be awesome to have you speak! I work with Jason Strate of the blog StrateSQL (Twitter @StrateSQL), and we work together both at Digineer, and on the MNSSUG (MNPASS) chapter together.

  6. Chris Beardsley says:

    Michelle –

    I am just beginning testing in our Dev environment, but I wanted to thank you before I get too tied up in other things. Thank you for devoting so much time to this script and then sharing with everyone – I hope good karma keeps coming for you.

    Best,

    Chris

  7. I truly wanted to compose a small remark to express gratitude to you for these superb pointers you are giving out on this site. My long internet look up has at the end of the day been honored with useful tips to write about with my colleagues. I ‘d tell you that most of us visitors actually are quite fortunate to exist in a fantastic site with very many wonderful individuals with insightful tips. I feel quite blessed to have seen your entire webpage and look forward to plenty of more cool times reading here. Thanks a lot once again for all the details.

  8. Uma says:

    Hats off to you Michelle :) I can’t believe that you do all this with a baby :) Keep up the good work and I love your posts! Very helpful.

  9. Pingback: Sharing knowledge: Index Defrag Script | The Lonely DBA

  10. Nirav says:

    Hi Michelle

    I was reading about Partitioning and your script on it was like gold. Simple to execute and do it while learning. Keep up the good work and keep the fire burning.

    Thanks
    Nirav Shah
    Database Developer Merkle

  11. Pingback: T-SQL-ohjelmointi » Blog Archive » Indeksikyselyt by SQL Fool

  12. Lava says:

    Hi Michelle -

    First thing first, you are one amazing young lady to be able to be a mother and maintain a blog on top your work and busy life. Thank you.
    I have been trying to use sp_msForEachTable to rebuild indexes based on their fragmentation level. If it is below 30% reorg else rebuild. I tried many ways, but I get errors. Is it possible if you put out a script where it checks all databases to do reorg/rebuild based on fragmentation level?

    Thanks a lot.

  13. Hi Michelle!

    I started using these after meeting you at the 2009 PASS conference. A few people in our business really stand out and I count you among them. There are a lot of SQL MVPs out there but few contribute as much as you have. I’ve recommended your defrag/reindex script to all my current and former customers/employers. Very nice indeed!

    These days I’m working more on the Hadoop side than SQL. I’ve focused on big data along side VLDB. I noticed you’re doing Terradata — nice work if you can get it ;)

    Anyway — just a note to say thanks!

    Best Regards,

    Rowland

  14. Rob Varn says:

    Hi Michelle,
    I am planning to start using your index optimization script. How does the sp handle the fill factor when doing rebuilds? Does it simply rebuild the index with the original (what it is set to) fill factor on the index?

    Thanks for much,
    Rob

  15. Ken Pfeiffer says:

    I was going through the stored procedures in our portal db and found the defrag script in one (properly attributed, I was pleased to see.) I don’t see a thank you from anyone who might have put it there, so I am doing so: Thank you very much for sharing the fruits of your many hours of effort – it is very truly appreciated.

  16. Gourav says:

    Hey Michelle

    I read your article related to Clustered Index,
    (https://www.simple-talk.com/sql/learn-sql-server/effective-clustered-indexes/)

    It was just mind blowing, Many concepts which doubtful for me got cleared after reading this..

    Thank you sooo much

  17. mahmood says:

    hi
    you are the best
    regards

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>