/explore
|
You are here 
|
www.sqlshack.com | ||
| | | | |
curatedsql.com
|
|
| | | | | [AI summary] A collection of SQL-related blog posts from January 4, 2024, discussing topics like data manipulation, database management, and SQL Server features. | |
| | | | |
stribny.name
|
|
| | | | | A list of things that we can do when we need to scale a SQL database. | |
| | | | |
jack-vanlightly.com
|
|
| | | | | My career in data started as a SQL Server performance specialist, which meant I was deep into the nuances of indexes, locking and blocking, execution plan analysis and query design. These days I'm more in the world of the open table format such as Apache Iceberg. Having learned the internals of both transactional and analytical database systems, I find the use of the word "index" interesting as they mean very different things to different systems. I see the term "index" used loosely when discussing open table format performance, both in their current designs and in speculation about future features that might make it into their specs. But what actually counts as an index in this world? Some formats, like Apache Hudi, do maintain record-level indexes such as,... | |
| | | | |
henrikwarne.com
|
|
| | | What a great book Designing Data-Intensive Applications is! It covers databases and distributed systems in clear language, great detail and without any fluff. I particularly like that the author Martin Kleppmann knows the theory very well, but also seems to have a lot of practical experience of the types of systems he describes. There is... | ||
