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 ...

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 ...

However, SQL Server 2016 also fully supports the rowset-to-JSON query scenario when you write a regular T-SQL query and then map results to JSON objects via the FOR JSON clause. For more information ...

SQL Server partitioning addresses this by allowing your database to scale horizontally. You can add new partitions as your data grows, which can be spread across additional filegroups on new disks ...

The short answer: no. The long answer: It is, technically, possible to use Power Query (in either Power BI or Excel) to write data to a data source; for example, here’s an old post I wrote showing how ...

In SQL Server Change Data Capture, change activities in a table such as delete, insert, and update are easily available in a relational format. All the required inputs necessary to track changes made ...

SQL Server Big Data Clusters (BDC) is a capability brought to market as part of the SQL Server 2019 release. Big Data Clusters extends SQL Server’s analytical capabilities beyond in-database ...

However, SQL Server 2016 also fully supports the rowset-to-JSON query scenario when you write a regular T-SQL query and then map results to JSON objects via the FOR JSON clause. For more information ...

SQL Server Big Data Clusters (BDC) is a capability brought to market as part of the SQL Server 2019 release. BDC extends SQL Server’s analytical capabilities beyond in-database processing of ...