Explore how Power Query XML functions handle null or missing values and inconsistent schema inference, a common problem causing confusion among users.

SQL Server XML Bulk Load Object Model (SQLXML 4.0) [!INCLUDE SQL Server Azure SQL Database] The Microsoft [!INCLUDE ssNoVersion] XML Bulk Load object model consists of the SQLXMLBulkLoad object. This ...

Here’s something that will Blow Your Mind if you’re a Power Query/M fan. Did you know that there’s a way you can get query folding to work if you’re using a native SQL query on SQL Server or Postgres ...

Originally this report was titled “Natively Compiled Queries”, but that doesn’t do justice to how deep this runs. When a memory optimized table is created, SQL Server will create a DLL ...

With SQL Server 2016, it now makes sense to store JSON objects in your database (even though there’s no JSON datatype). Here’s how to query JSON properties to find the rows you want.