Accepts a select query as a string input Converts query into a dict of 'simple' select queries, linked to each other through 'from' statements. A 'simple' select query is a select query without any ...

ts-sql-query is a type-safe query builder that provides a way to build dynamic SQL queries in a type-safe way, that means, the TypeScript compiler verifies the queries. Type-safe SQL means the ...

I first came across the Value.NativeQuery() M function about six months ago, but it didn’t do anything useful then so I didn’t blog about it. I checked it again recently though and now it does ...

I have written an application that takes in a fixed-width file (thanks in no small part to advice I recieved in a seperate thread) and then dissasembles each line, runs a fairly meaty SQL SELECT query ...

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 ...

Part of the SQL Server 2022 blog series. Query Store is one of the most powerful database-scoped features in SQL Server for troubleshooting performance and improving the stability of your database ...