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

We are excited to announce that SQL Server environment variables (Entra) for Power Apps support is currently rolling out and will be in Preview regions by Jan 22 and in all regions – including ...

This code ends up running SELECT DISTINCT columnName FROM my_table (it interpolates the name of the variable into the SQL): I expected it to run SELECT DISTINCT my_column FROM table (interpolate the ...

Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement. It’s sometimes difficult to know which SQL syntax to use when ...

SQL Server's OpenJson function will let you dismantle JSON structures into relational tables, including tables with foreign/primary key relationships. As I noted in an earlier column, JSON is great ...

Because the SQL Server's implementation needs to take the name of the type (table-valued parameter), I propose the following convention: set the type as the DataTable name, as in: var table = new ...

SQL Server 2014 In-Memory OLTP introduces two new widely advertised kinds of database objects: memory-optimized tables for efficient data access, and natively compiled stored procedures for efficient ...