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

When working with SAP HANA, especially in data-intensive environments such as BW/4HANA, even small performance bottlenecks can become a serious issue. When a Calculation View processes hundreds of ...

Every data engineering team right now is being asked the same question: "How do we build a chatbot that talks to our data?" The prototypes are deceptively simple. A developer connects GPT-5.1 to a ...

At Microsoft Build 2025, we announced the public preview of SQL Server 2025. Built on a foundation of best-in-class security, performance, and availability, SQL Server 2025 empowers customers to ...

MSF UK provides medical assistance to people affected by conflict, epidemics, disasters, or exclusion from healthcare. With teams made up of tens of thousands of professionals working in health and ...

WITH Accounts AS ( SELECT DISTINCT Name FROM trans ), Months AS ( SELECT DATEADD(MONTH, n, '2021-01-01') AS MonthStart FROM ( SELECT TOP (DATEDIFF(MONTH, '2021-01-01 ...

Imagine this: Sanji asks Luffy, “How many years has it been since One Piece started?” Luffy, true to his character, starts counting on his fingers, mumbling, “1999, 2000, 2001…” (This could take a ...

This T-SQL script is designed to calculate the optimal batch size for bulk load operations in SQL Server (2008 and later versions). It provides the necessary values to optimize bulk inserts, ensuring ...

SQL, the Structured Query Language, remains one of the most widely used programming languages, coming in fourth in Stack Overflow’s research for 2023. Just over half (51.52%) of professional ...

Calculating percentages is a common task when dealing with data analysis. In SQL, the process of calculating percentage may differ based on the database management system being used. In this article, ...