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

The Real Problem with Relational Databases

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

Related

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 to Paul Turley 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.

My day job is helping people make databases go faster.

My current car collection includes a 1964 Porsche 356 SC, a 2024 Porsche 911 Targa 4S, a 2016 Rolls-Royce Dawn, and a 1992 Honda Beat.

© Brent Ozar. All rights reserved. Privacy Policy

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