Microsoft SQL Server's relational engine has offered new instrumentation that improves by light years with each new release. The introduction of Dynamic Management Views (DMVs) in SQL Server 2005 ...

This blog post is for an advanced user scenario of connecting to a SQL server by creating a flow from scratch. Make sure you read the getting started blog here first. Today, I am going to walk you ...

I'm trying to take an XML document and dump the contents into a table. Not as XML using the SQL Server 2005 XML datatype, but as the parsed data values into a table with a column for each element ...

We are excited to announce that you can now directly call SQL Server stored procedures in Power Fx. You no longer need to call a Power Automate Flow to use a stored procedure. This feature is in ...

I was super-excited when, a few days ago, the long-awaited integration of Power Query into Microsoft Flow was announced.I was then gutted when work commitments meant I couldn’t blog about it right ...