Category: Sql

SQL - How to show distinct values in the most efficient way

A very common requirement is to show distinct values from a SQL Server table. The most efficient way to accomplish this is to build a view. This post walks through how to carry out this task.

Dataverse - How to access data more easily through TDS

We can more easily access records in Dataverse by enabling the TDS protocol. This opens up read-only access to tables through SQL Management Studio and PowerBI. In this post, we'll look at why we might want to do this and the steps to set this up.

SQL - What you need to know about bulk updating records

Bulk updating SQL data from Power Apps can be very slow. Read this to find out why.