25 Sep 2025, 18:35

Use SQL Management Studio to Access Dataverse

I consider being able to look at the data during development very important. So far, for inspecting data in Dataverse I have used maker environment and runtime environment. It’s a simple if somewhat inflexible option. Also, I have used XrmToolbox and SQL 4 CDS plugin. That’s better from the flexibility standpoint, but XrmToolbox somehow looks and feels like a toy:

XrmToolbox screenshot

and origin of plugins and what they might do in the background always made me uneasy.

Then, just today, I discovered that one can simply use SQL Management Studio.

SQL Management Studio accessing dataverse tables screenshot

Much simpler and better. Highly recommend.

03 Dec 2024, 20:17

Force Delete Power Platform Environment

An environment got stuck in some bad state. First, publishing was no longer possible. Then, after deleting the environment from admin center the environment was still there but Delete button was not available.

Dropping to console, issuing

pac admin delete --environment <your-guid-here>

and waiting a few minutes helped.