SESSION Details

3 things you don’t want to store in a database (but sometimes have to)

Some types of data are a very bad fit for a database. For instance, if you ever tried to save logs, pictures or entities with dynamic attributes in a database, you probably have one or two horror stories to share. However, sometimes there is nothing you can do and that data will have to live in your database, like it or not.
Join me to see how to survive with a database full of data that should not be stored there. I will demonstrate how to deal with billions of rows of logs without trashing the database, how to store millions of pictures effectively and how to deal with dynamic attributes in a sensible way.

Feedback link https://sqlb.it/?7048

Starts: 10:10 11th Mar 2022
Ends: 11:00 11th Mar 2022

Q&As

Short Description
- Some types of data are a very bad fit for a database. Join me to see how to survive with a database full of data that should not be stored there. I will demonstrate how to deal with billions of rows of logs without trashing the database, how to store millions of pictures effectively and how to deal with dynamic attributes in a sensible way.

Slidedeck Link

3thingsYouDontWantInADatabase.pdf

Speakers

Gianluca Sartori

Tags

AzureOn PremisesPlatform AgnosticOperational DatabasesDevelopingModellingOptimisingDatabase EngineIntermediateHow

The SQL Bits Story

SQLBits was formed in 2007 by a group of volunteers who were passionate about the SQL Server product suite and wanted to provide much-needed community-driven education to the data community.

As one of the largest data platform conferences in the world, we offer more opportunities to a wider audience.

15 Years

We’ve grown and expanded a lot since 2007.

2500 Participants

SQLBits is the best place to meet fellow data professionals.

82 Countries

We welcome data professionals from all over the globe.

1140 recorded sessions

All the live sessions are recorded and offered for free, year round.

Experience the SQLBits Conference

Previous
Next

Want to be part of the SQLBits community?

Attend the London conference in-person or virtually on 

March 8-12, 2022 at ExCel London, UK.