• Home
  • My Favorite Topics
    • Blogging
    • Business
    • Career
    • Cars
    • Consulting
    • Epic Life Quest
    • Iceland
    • Marketing
    • Presenting
    • Productivity
  • My Life Quest
    • Future Achievements
  • About Me
  • My Recent Photos

The Real Problem with Relational Databases

8 years ago
nosql, performance tuning, SQL Server
10 Comments

They’ve become too easy.

It’s too easy to just dump any kind of data in there.

It’s too easy to query the database rather than cache data for a period of time in the app.

It’s too easy to join all the tables together rather than pick just the tables you need.

It’s too easy to write spectacularly, horrifically bad queries.

It’s too easy to copy/paste bad designs from the web that have gradually gained good SEO over time.

It’s too easy to install them and go live on really crappy hardware.

It’s too easy to scale for the first couple years because they just work.

Over and over, I see developers succeeding with specialized data storage platforms not because these new platforms are easy – but because they’re harder. Developers are wary of these new tools, so they’re careful. Developers pay close attention, read all the blog posts about it, the HackerNews links on it, and even dig into the source code.

If only they’d put that much time into learning relational databases.

nosql, performance tuning, SQL Server
Previous Post
Pop Quiz: What Do These Things Cost?
Next Post
How I Vote for #SQLPASS Board of Directors Members

10 Comments. Leave new

  • Buck Woody
    September 16, 2014 8:17 am

    True that. In fact, I’m doing a session at PASS on selecting the right technology to process a given datum. Because not everything is a VARCHAR(MAX) or should be used with FileStream. 🙂

    Who loves ya, Brent?

    Reply
    • Brent
      September 16, 2014 8:44 am

      JESUS DOES!

      Oh and you. Buck Woody. You can see how I would get those two confused.

      Reply
  • Kevin Boles
    September 16, 2014 10:48 am

    I regularly expound to SQL Saturday attendees about what an AWESOME platform SQL Server is because Bean (9yo daughter) can take the install disk for SQL Server and click Next-Next-Next and she has a functioning database platform. Same with a third-party app install disk and she has an application running on that SQL Server. And with default EVERYTHING (and there are some DISASTROUSLY bad defaults) SQL Server will just keep on working hard to efficiently process your data and do an AMAZINGLY good job of it – despite HORRIBLE app design, code, lack of maintenance, etc.

    But if your company is lucky you grow and reach a point where you need better SLA, response-time, scalability, concurrency, etc. Then you just got to stop doing things wrong/suboptimally and start doing things right/efficiently to get where you want to go. And again, SQL Server is an AWESOME product because there are SOOO many opportunities on both sides of that coin!!

    It is indeed TOO EASY!!

    Best,

    Kevin Boles

    Reply
  • Fizzelen
    September 18, 2014 3:28 am

    The real problems with cars is they have become too easy.
    Any fool can jump in turn the key press the pedal and drive straight into the swimming pool.

    Reply
    • Brent
      September 18, 2014 6:49 am

      Fizzelen – absolutely, and I really applaud Volvo for their Volvo 2020 initiative. They’re aiming for zero deaths in Volvos starting in the year 2020 – they want to build cars that can protect the occupants from their own bad decisions and luck.

      Reply
      • Chris Lalos
        December 8, 2020 11:30 am

        As someone stumbling across this in 2020 … is/was that real? Asking for a (you know the rest)

        Reply
  • Paul Turley
    September 18, 2014 2:16 pm

    Now there’s a catch 22. I’m also for using technology to promote safety and save lives but not at the expense of good judgment. There was the lady last year who pointed her A-Class RV straight and then got up to use the bathroom and then won a law suit after it crashed. I recently talked to someone who told me that when her legally-blind daughter is of driving age in three years that Mercedes should have vehicles equipped to make that possible. For me, the jury’s still out on that one.

    Somehow we got from SQL Server to cars. Can they build the certification exam software into the setup wizard? Seems like it would be a could pairing.

    Reply
    • Brent
      September 19, 2014 5:36 pm

      Paul – hahaha, yeah, THAT would be awesome. A multiple choice test as part of setup, and you have to pass first. (Although come to think of it, maybe that’s what Oracle does…)

      Reply
  • George Stocker
    September 19, 2014 5:00 pm

    This is a wonderful blog post. Succinct, almost Seth Godin like. Got me to thinking about Software. We write languages just to make it harder to do stupid things because we do stupid things with stunning alacrity.

    Reply
    • Brent
      September 19, 2014 5:35 pm

      Thanks sir! I appreciate it.

      Reply

Leave a Reply Cancel reply

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

Fill out this field
Fill out this field
Please enter a valid email address.

Hi. I’m Brent.

That's me, Brent.

I live in Las Vegas, Nevada. I'm on an epic life quest to have fun and make a difference.

I co-founded Brent Ozar Unlimited to help make your SQL Server go faster. I also maintain sp_Blitz® and the open source First Responder Kit repo.

My current car collection includes a Jaguar XKR-S, Porsche 944 Turbo, Porsche 356 Speedster replica, and a Ferrari 328 GTS.

profile for Brent Ozar on Stack Exchange, a network of free, community-driven Q&A sites

© 2021 Brent Ozar, all rights reserved. Privacy Policy

  • Home
  • My Favorite Topics
  • My Life Quest
  • About Me
  • My Recent Photos