/explore
|
You are here 
|
jack-vanlightly.com | ||
| | | | |
www.sqlshack.com
|
|
| | | | | In this blog post we will show you step by step some tips and tricks for successful Query optimization techniques in SQL Server. | |
| | | | |
www.dquach.com
|
|
| | | | | [AI summary] The article discusses the current state of data engineering in Q3 2024, focusing on Open Table Formats (OTFs) like Apache Iceberg, Databricks, and Delta Lake, along with updates on AI prompt engineering, new tools like DuckDB, and cloud provider advancements. | |
| | | | |
www.red-gate.com
|
|
| | | | | This article is an extract from the book Tribal SQL. In this article, Mark S. Rasmussen offers a concise introduction to the physical storage internals behind SQL Server databases. He doesn't dive into every detail, but provides a simple, clear picture of how SQL Server stores data. | |
| | | | |
jack-vanlightly.com
|
|
| | | In the world of open table formats (Apache Iceberg, Delta Lake, Apache Hudi, Apache Paimon, etc), an emerging trend is to provide interoperability between table formats by cross-publishing metadata. It allows a table to be written in table format X but read in format Y or Z. Cross-publishing is the idea of a table having: * A primary table format that you write to. * Equivalent metadata files of one or more secondary formats that allow the table to be read as if it were of that secondary format. | ||
