What’s New in SQL Server 2017

The very recent Microsoft Data Amp event provided an excellent forum for the SQL Server 2017 announcement, which is due to be released at some point this year. Perhaps the most touted feature of the new version is that it will be available to be installed on Linux; an entirely inconceivable premise 10 years ago, which [...]

Utilising SQL Server Stored Procedures with Power BI

Those who have experience working with an RDMS system like SQL Server will become accustomed towards a certain way of going about things. These can often involve a mixture of "lazy" query writing (e.g. using SELECT *... as opposed to SELECT Column1, Column2...), the manner in which you write your query (ALL CAPS or lower [...]

Overcoming Date Range Hurdles (Power BI/DAX)

The single biggest challenge when developing a reporting solution is data. Invariably, you won't always have one database that contains all the information you need; often, you will need to bring across disparate and unrelated data sources into a common model. This problem can be exasperated if your organisation has a number of application or [...]

Power BI Deep Dive: Using the Web API to Query Dynamics CRM/365 for Enterprise

I have had an opportunity recently to start getting to grips with the wonderful world of PowerBI. For those who have walked the tightrope between Excel and SQL Server Reporting Service (SSRS) Reports, PowerBI appears to be the tool with these individuals in mind. It enables you to leverage existing Excel knowledge (through PowerQuery or [...]