Twitter Sentiment Analysis using the Cortana Intelligence Gallery
[MP4] [0:11:30] [2017/08/31]After publishing the recent video blog on Twitter Sentiment Analysis using Streaming Analytics and Event hubs and received an email asking if there was a way to quickly deploy a Twitter sentiment…
Working with Azure Data Factory Pipelines and Activities
[MP4] [0:14:38] [2017/07/20]A data factory can have one or more pipelines. A pipeline is a logical grouping of activities that together perform a task. The activities in a pipeline define actions to perform on your data. For…
[Working-with-Linked-Services-and-Datasets]
Lab: Twitter Sentiment Analysis with Streaming Analytics and Event Hubs
[MP4] [1:02:11] [2017/07/08] Why not try out the solution to this presentation yourself? Lab instructions are below, if you get stuck, watch the video for answers about the lab. This lab can also be found at:…
Loading data into Azure SQL Datawarehouse
[MP4] [0:14:35] [2017/07/06]There are a wide range of tools and technologies to ingest data into Azure SQL Data Warehouse, including BCP and SSIS. If performance is a critical metric to meet when loading a data warehouse, loads…
Working with tables in SQL Datawarehouse
[MP4] [0:03:36] [2017/07/06] Before we get into the implementation of tables, there are several concepts that need to be understood so that you can understand the ramifications of you design choice for tables. These concepts…
Create an Azure Data Factory Instance
[MP4] [0:03:11] [2017/07/06] There a variety of methods that can be used to create an instance of an Azure Data Factory, this blog explores how you can create an ADF instance using the Azure Portal, PowerShell and Azure Resource…
Creating Databases in Azure SQL Datawarehouse
[MP4] [0:07:12] [2017/07/06] Creating databases within Azure SQL Data Warehouse uses very familiar T-SQL language constructs to create them. However, there are subtle difference in the TSQL between creating an on premise SQL…
The Scalability of Azure SQL Data Warehouse
[MP4] [0:02:47] [2017/07/06]A quick one. In the first post of Azure SQL Data Warehouse, we introduced the key business benefits of the service. Namely the ability to scale on demand, and the pause and restart the service at…
Creating a Data Warehouse in the Cloud
[MP4] [0:10:54] [2017/07/05]For a few months now, we have had a SQL Server edition in the cloud known as Azure SQL Data Warehouse. This version enables you to provision a data warehouse instance in just 3 to 5 minutes. Its main…
Cortana and PowerBI Integration
[MP4] [0:08:51] [2017/06/29]Thursday found me in Manchester, UK with the Power BI user group to discuss Cortana integration with Power BI and the Cortana Intelligence Suite. The group can be found here if you want to attend any…