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]
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]
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 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]
Statistics in Azure SQL Data Warehouse 1. November 2016 EmmaStewart Azure, Azure DataWarehouse, SQL Data Warehouse (0) Following on from my previous post about Update Queries in Azure SQL Data Warehouse, I thought I wou... [More]
Managing msdb in SQL Server 28. October 2016 Callum-Green msdb, SQL Server, SQL Agent (0) In the world of BI, the SQL Server system databases (with the exception of tembdb) are often forgott... [More]
SQL PASS Summit–Day 2 28. October 2016 UstOldfield Data Lake, Azure, SQL, PASS, SQLSummit (0) Day 2, Thursday, started off with a keynote from David DeWitt on cloud data warehousing, scalable st... [More]
SQL PASS Summit–Day 1 27. October 2016 UstOldfield SQL, Azure, PASS, SQLSummit, Data Lake (0) Day 1, Wednesday, technically started on Tuesday with a newbies speed networking event in which we h... [More]
October 28th Technical Preview for SSRS – Including Power BI in SSRS 26. October 2016 Callum-Green PowerBI, SSRS 2016, SQL Server 2016, SSRS (0) Today at the Pass Summit, Microsoft announced some cool new features that are coming into SSRS 2016.... [More]
Using Azure Machine Learning and Power BI to Predict Sporting Behaviour 24. October 2016 piotrstarczynski General, PowerBI, SQLBits, Machine Learning, Bike Experiment, Azure IoT Suite, IoT, ASP.NET (2) Can we predict peoples’ sporting performance by knowing some details about them? If so, what is bett... [More]
Setup Of Oracle Attunity Connectors 14. October 2016 JonathonEve-OConnor SSIS, Oracle, Attunity, ETL (1) Fairly often I come across a project where there is a requirement to extract data from an Oracle sou... [More]
View Native Query Function in Power Query 13. October 2016 Callum-Green Power Query, PowerBI (2) Following on from my last blog (found here), I wanted to share a new Query Folding feature in Power ... [More]
Connecting SSIS to SAP HANA 13. October 2016 ScottHudson (2) Recently I've been doing some work for a client who have upgraded their SAP system previously sittin... [More]
Stretch Databases: The Basics 28. September 2016 CameronMcLurcan SQL Server 2016, Stretch Databases, Azure (0) What Is It? A stretch database is a database where the rarely used portions of the data are stored ... [More]