On-Premise Power BI: Part 2 – What’s next? 3. February 2017 Callum-Green Power BI On-Premise, PowerBI, SSRS 2016 (1) Part 2 of this blog series focuses on the future of Power BI On-Premise and what direction Microsoft... [More]
On-Premise Power BI: Part 1 - Technical Preview 1. February 2017 Callum-Green Power BI On-Premise, PowerBI, SSRS, SSRS 2016 (1) Back in October 2016 at SQL Pass, Seattle, Microsoft announced that Power BI was going on premise.&n... [More]
Azure Data Factory - Suggested naming conventions and best practices. 31. January 2017 terrymccann (0) Years ago I stumbled on a great blog about SSIS best practices and naming conventions. In the... [More]
IoT Hub, Device Explorer, Stream Analytics, Visual Studio 2015 and Power BI 29. January 2017 josemendes Azure IoT Hub, Device Explorer, Stream Analytics, Visual Studio, Power BI (0) As we saw in my previous blog, the IoT Hub allow us to collect millions of telemetry data and establ... [More]
Continuous Integration with SQL Server 2016 for SSIS – Updated Template for SSIS Deployment 23. January 2017 JonathonEve-OConnor (1) Recently we had a couple of issues on a project setting up Continuous Integration when working with ... [More]
Setting up your first Azure Data Factory. 22. January 2017 terrymccann (1) Continuing on from the previous blog (http://blogs.adatis.co.uk/terrymccann/post/Getting-started-wit... [More]
What is Azure Data Factory? 20. January 2017 terrymccann Azure, Azure Data Factory (1) (Image 1 - Azure Data Factory – Transformation Pipeline) Overview: Azure data factory (ADF) is a b... [More]
Power BI Streaming Datasets–An Alternative PowerShell Push Script 19. January 2017 SachaTomey IoT, Power BI, PowerShell, Stream, Streaming (2) I attended the London Power BI Meetup last night. Guest speaker was Peter Myers On the topic of "Del... [More]
Azure Event Hubs and IoT Hub 18. January 2017 josemendes Azure IoT, Azure Event Hubs, Azure IoT Hub (2) Imagine that you are the CEO of a big Logistic & Transport Company that works across the UK. In ... [More]
Extracting Data from Salesforce using SSIS 18. January 2017 matthow Salesforce, SSIS (3) This blog looks at a couple of methods of extracting data from Salesforce and gives a demo of how to... [More]
Using R Tools for Visual Studio (RTVS) with Azure Machine Learning 13. January 2017 MattWillis Azure Machine Learning, R, R Tools for Visual Studio, RTVS, Visual Studio (1) Azure Machine Learning Whilst in R you can implement very complex Machine Learning algorithms, for a... [More]
Introduction to R Tools for Visual Studio (RTVS) 12. January 2017 MattWillis Azure Machine Learning, R, RTVS, Visual Studio, R Tools for Visual Studio (1) Introduction This blog is not looking at one or two exciting technologies, but THREE! Namely Visual ... [More]
Buffer() M Function in Query Editor (Power BI) 9. January 2017 Callum-Green Power Query, Query Editor, PowerBI, M (1) Whilst I have been aware of the Buffer() M function in the Query Editor of Power BI for a while, I h... [More]
Migrating Team Foundation Server backlog 4. January 2017 JamesRussell TFS, Backlog, Team Foundation Server (1) What is the issue I recently had a need to move a Microsoft Team Foundation Server (TFS) backlog I ... [More]
Attunity Connector Tips 13. December 2016 JonathonEve-OConnor (0) In keeping the theme with my previous blog I thought I would put together a quick blog detailing som... [More]
Stop Automatic checkout of SSIS Packages in Visual Studio 9. December 2016 JonathonEve-OConnor (1) Every once in a while I work on a project affected by this issue. What happens is that upon loading ... [More]
Row Level Security (RLS) using the Power BI Service 8. December 2016 Callum-Green RLS, PowerBI (1) Following on from my last blog on RLS, I will now demonstrate how to initiate the roles created in P... [More]
Row Level Security in Power BI Desktop 1. December 2016 Callum-Green PowerBI, RLS (3) In the June 2016 monthly Power BI release, Row Level Security (RLS) was introduced into Power BI des... [More]
Azure ML Regression Example - Part 3 Deploying the Model 23. November 2016 MattWillis Machine Learning, Azure Machine Learning, Regression (1) In the final blog of this series we will take the regression model we have created earlier in the se... [More]
Introduction to Azure Key Vault for SQL Server 22. November 2016 JamesRussell Azure, Key Vault, SQL Server, Encryption (0) What is it Azure Key Vault is a feature available in Microsoft Azure which can be used to manage and... [More]