The Dataverse TDS endpoint emulates Microsoft SQL Server read-only query capabilities over the Dataverse business logic. Dataverse returns the current SQL Azure version 12.0.2000.8 for `select ...

We recently added support for Active Directory authentication in the SQL Server connector. This has been one of the most requested feedback from our customers. In this post, I want to give an overview ...

We are very pleased to announce today that SQL views from the SQL Server connector available at the end of the week in PowerApps. Leveraging SQL Views will allow you to combine data in SQL Server ...

Connectors in PowerApps allow us to read data from lists and libraries and gather 2000 items at once. However, we can get around this restriction by using SQL Stored Procedures in PowerApps.

I then connected SQL Server Profiler to Power BI Desktop (the easiest way to do this is to install it as an External Tool as described here, although you can connect by finding the diagnostics port as ...

An update to the cardinality estimator feature in SQL Server 2022 will be one of the biggest changes to the database engine since its inception.