A few months ago a new option was added to the Sql.Database and Sql.Databases functions in Power Query in Power BI and Excel which allows Power Query queries that combine data from different SQL ...

As of the November update of Power Query, it’s now possible to write your own SQL query when you’re moving data out of SQL Server into Excel using Power Query. So I got thinking… if you can write your ...

Library for lexing and parsing a SQL INSERT query. Contribute to lbreme/lexepa-sql development by creating an account on GitHub.

Joey on SQL Server A Deep Dive into SQL Server 2022's Query Performance Features, Part 1 An update to the cardinality estimator feature in SQL Server 2022 will be one of the biggest changes to the ...

Dino Esposito explains JSON-to-rowset native support in SQL Server 2016 and provides a realistic perspective of data query when you have JSON data stored in the database.

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