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 (2) 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]
SSAS Tabular Tables Losing Structure of Measures 22. November 2016 JamesRussell SSAS, Tabular, Measure, Structure (2) What is the issue While recently working on a SQL Server 2012 Tabular cube in Visual Studio I came a... [More]
Shaping The Lake: Data Lake Framework 17. November 2016 UstOldfield Data Lake, Azure, Big Data (0) The Azure Data Lake has just gone into general availability and the management of Azure Data Lake St... [More]
PowerBI Optimisation P3– Extracting and Source Controlling PowerBI Data Models 17. November 2016 SimonWhiteley Power BI, Dashboards, Source Control (0) Source Control – once seen as “something proper developers do” – has been an integral part of the wa... [More]
PowerBI Optimisation P2–What’s using all my memory? 17. November 2016 SimonWhiteley Power BI, Dashboards (1) If you're a regular user of PowerBI, you're probably aware of the size limitations around datasets a... [More]
PowerBI Optimisation 1 – Connecting Via Management Studio 14. November 2016 SimonWhiteley Power BI, Dashboards (0) I recently gave a talk to the London PowerBI UserGroup and I kicked things off with a confession - "... [More]
Microsoft BI – Coming Soon to SQL Server 2016 7. November 2016 Callum-Green SQL Server 2016, SSAS, SSIS, SSRS (1) After attending the Pass Summit 2016 a couple of weeks ago, I attended a number of sessions that pro... [More]
SQL PASS Summit–Day 3 and Reflections 4. November 2016 UstOldfield PASS, SQLSummit, SQL, Azure (0) Apologies for the delay in getting this blog out to you all. When PASS finished on the Friday we had... [More]
How to do row counts in Azure SQL Data Warehouse 4. November 2016 EmmaStewart Azure, Azure DataWarehouse, General, SQL Data Warehouse (0) Continuing on from my last couple of blog post about working with the Azure Data Warehouse, here is ... [More]