SQL Fool Adventures in SQL Tuning – a blog for the rest of us

About the Author

I'm a SQL Server Developer, DBA, humble blogger, and complete geek!

When I'm not enjoying time with my wonderful family, I spend my free time working with the SQL community. I'm the founding President and current VP of the I380 Corridor PASS Chapter (East Iowa) and a co-leader of the PASS Performance SIG. I'm also an active blogger, a published author, and an occasional speaker on SQL topics.

I've been working with computers in a variety of roles for 12+ years.  My first job was developing websites using classic HTML in NotePad, back when everyone was still connecting to AOL at 2400 baud (lol).  From there I moved onto several different technical roles, including application and web developer, tech support, systems administrator, business analyst, and, of course, DBA.  Having the opportunity to "wear so many hats" allowed me to realize that my interests lie with databases and business intelligence.

In my current role at GoDaddy.com, I work as Senior SQL Server Developer on the Business Intelligence team. Among other things, I'm currently in the process of building a massive enterprise data warehouse. In my previous role, I had the opportunity to work with large, high volume, high performance SQL Server databases (VLDB's).  I've learned a lot in my time with this company, and I try to share some of what I've learned via this blog.  I've been working with the SQL Server platform for 7 years, and I'm still constantly learning new things.  I don't profess to be a SQL "guru," but I do have a passion for what I do.  I invite readers to respond with questions, suggestions, comments, and constructive criticisms.

Thanks for taking the time to stop by! :)

Michelle Ufford
@SQLFool
michelle at sqlfool dot com

Comments (5) Trackbacks (1)
  1. 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!

  2. 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.

  3. 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. :-)

  4. 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.

  5. 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


Leave a comment