“SQL on everything” is the tagline associated with Presto, the query engine that was initially developed by Facebook to rapidly analyze massive amounts of data — particularly data that lay scattered ...
In part 1 of my SQL Server 2022 features series, you learned about the improvements to the cardinality estimator component of query optimization. In this installment, you will learn about another ...
Google is abandoning its homegrown SQL variant as the recommended default query language for its BigQuery service in favor of a new standard-compliant dialect in the works for the managed data ...
An update to the cardinality estimator feature in SQL Server 2022 will be one of the biggest changes to the database engine since its inception. Database engines like SQL Server are incredibly complex ...
From crafting lightning-fast queries to building dashboards that tell a story, SQL remains the backbone of modern analytics. Whether you're optimizing joins, mastering window functions, or automating ...
On Friday the 13th of March 2026, M.Sc. Valter Uotila defends his PhD thesis on Quantum Computing Methods for Query Optimization in Relational Databases. The thesis is related to research done in the ...