Hello there! 👋 I'm Luca, a BI Developer with a passion for all things data, Proficient in Python, SQL and Power BI ...

ExcelTable is a pipelined table interface to read Excel files (.xlsx, .xlsm, .xlsb, .xls, .xml), ODF spreadsheet files (.ods), and flat files (delimited or positional) as if they were external tables.

Oracle SQL Developer is a great tool for managing Oracle Databases. It has a user-friendly interface that makes it easier to handle database tasks. The software offers features to simplify workflows ...

When Oracle launched its second-generation cloud in 2016, it revealed an architecture designed from the ground up for cloud workloads: Oracle Cloud Infrastructure. In the eight years since that launch ...

Part of the SQL Server 2022 blog series. Query Store is one of the most powerful database-scoped features in SQL Server for troubleshooting performance and improving the stability of your database ...

Part of the SQL Server 2022 blog series. Query Store is one of the most powerful database-scoped features in SQL Server for troubleshooting performance and improving the stability of your database ...

Here’s something that will Blow Your Mind if you’re a Power Query/M fan. Did you know that there’s a way you can get query folding to work if you’re using a native SQL query on SQL Server or Postgres ...