Power Query replaces risky and time-consuming manual edits with a safe, user-friendly system that speeds up everyday ...

Sometimes you need to take a small dataset from Excel (like item IDs, quantities, or a list of customers) and use it as an input for a SQL query. If you have permissions to create a Table-Valued ...

Since Github doesn't provide a great way for you to learn about new releases and features, don't just star the repo, join the mailing list. dsq will likely work on other platforms that Go is ported to ...

Before you can document your SQL Server environment with SQL Power Doc you'll to meet the following requirements: Permissions - SQL Power Doc makes connections to standalone SQL Server instances using ...

In my recent article I've reported about a nice free alternative to manage SQL databases, which, from the same UI can manage also MySQL databases. I thought that it might be a good idea to actually ...

A few weeks ago my colleague Dany Hoter wrote a post on the Azure Data Explorer blog about how using columns on fact tables as dimensions in DirectQuery mode can lead ...

I recently had some interesting problems and learned some cool solutions while working in Power Query in Excel =] ! The first problem I had was that I was trying to create a dynamic SQL query based on ...

With the latest public preview available, it’s time to decide if you want to upgrade to Microsoft’s most cloud-connected version of SQL Server so far. Three decades on, SQL Server is still a database ...

ASP.NET Core is a cross-platform, open source, lean, fast, and modular framework for building high-performance web applications. There are a number of ways in which you can pass parameters to action ...

A few weeks ago I received a great tip from Simon Nuss about a Power Query feature relating to ODBC data sources that I hadn’t seen before (although it’s in Power BI Desktop and Excel 365, so it can’t ...